Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 24 Sep 2003 @ 07:48:13 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Long running archive job
From:   Harizanov, Ivan A

Dear All,

Recently we had a problem which I couldn't explained to the management.

In our environment we had a Production job which is using "ARCMAIN" utility to backup a table of 10gb. Elapsed time for this job is approximately 35min. On the day of the problem the same job/JCL took 23hours and we had to cancel the backup.

During the archiving process(23h) there was not any activity(Mload etc) on that table.

Are there any kind of utilities in TD Manager or some DBC tables to show what was holding the table or any meaning full explanation?

I did look into : DBC.AccessLog/DBC.Events/DBC.Logonoff

We are running Teradata V2R4.1.3.44

Any help or recommendations are welcome.

Many thanks

Ivan Harizanov
EDS, Sydney Solution Centre(SySC)
Data Warehouse

  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023