View previous topic :: View next topic
|
Author |
Message |
smakkena
New User
Joined: 04 May 2005 Posts: 8
|
|
|
|
HI all,
could u explain what is the restart table in db2?
thnkas in advance
Suresh |
|
Back to top |
|
|
Girishm
New User
Joined: 09 Mar 2005 Posts: 35 Location: Mysore
|
|
|
|
It is a table which stores the necessary information of a particular job, in case the job terminates abnormally and if the job is restarted, then the processing takes places starting from the saved position.
For eg;
Consider a program is inserting/updating data for a table and for some exception, program abnormally terminated. in such situation we can save the record count/primary key value/unique field value .. into this restart table and then abend the program. When it is restarted, if the log was made in this restart table, then the processing will be carried out from that point (before abend) of input instesd of repeating the entire processing.
This concept will be used if millions/trillions of records need to be processed to avoid rework on the earlier run (abend run).
Hope this helps,
_______
GM |
|
Back to top |
|
|
nirenchan
New User
Joined: 21 Jul 2005 Posts: 23 Location: USA
|
|
|
|
hi giri,
cud u pls more specific...
We can restart a job but how can we restart from the mid of the file, means if the job abended due to some reasons and tht too in the mid of a 1 million record.
If you have a log (restart table). then how to restart the process with tht data?
thanks and regards,
Niren |
|
Back to top |
|
|
shobam
New User
Joined: 18 Jul 2005 Posts: 34 Location: CN
|
|
|
|
The LOG Table will be maintaing the inforamtion about the last record processed , which includes the position of the record in the INPUT file.
If it is SEQUENTIAL file perform a READ until the LAST-REC-BEFORE-ABEND is reached.(No processing is done only the READ operation).
If the INPUT file is a VSAM file you can use the KEY FIELD information stored in the RESTART table to start processing after the LAST record processed before ABEND.
PS:
Usually the LOG file will be updated at a specific interval of time. So the record which is maintained in the LOG file need not be the LAST rec processed.
Please correct me If i am wrong. |
|
Back to top |
|
|
Girishm
New User
Joined: 09 Mar 2005 Posts: 35 Location: Mysore
|
|
|
|
Yes I agree with shoba. that is what the restart log will have the info and gets started processing when restarted.
_______
GM |
|
Back to top |
|
|
Girishm
New User
Joined: 09 Mar 2005 Posts: 35 Location: Mysore
|
|
|
|
Yes I agree with shoba. that is what the restart log will have the info and gets started processing when restarted.
_______
GM |
|
Back to top |
|
|
Prasanthhere
Active User
Joined: 03 Aug 2005 Posts: 306
|
|
|
|
The restart table contains information that enables the Capture program to restart from the earliest required log or journal record. This table replaces the warm start table from DB2 replication Version 7 and earlier versions. It contains one row, which is updated at every commit point; therefore, the Capture program can always restart from exactly the right place without recapturing information that it already processed and inserted into the CD and UOW tables.
Quote: |
Attitudes greater than aptitudes |
[/code] |
|
Back to top |
|
|
|