what is the restart table in db2?

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

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

nirenchan · New User Joined: 21 Jul 2005 Posts: 12 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

shobam · New User Joined: 18 Jul 2005 Posts: 33 Location: Chennai

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.

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

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

Prasanthhere · Senior Member Joined: 03 Aug 2005 Posts: 304

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.