IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

what is the restart table in db2?


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
smakkena

New User


Joined: 04 May 2005
Posts: 8

PostPosted: Thu Jun 30, 2005 5:13 pm
Reply with quote

HI all,

could u explain what is the restart table in db2?

thnkas in advance
Suresh
Back to top
View user's profile Send private message
Girishm

New User


Joined: 09 Mar 2005
Posts: 35
Location: Mysore

PostPosted: Thu Jun 30, 2005 5:32 pm
Reply with quote

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
View user's profile Send private message
nirenchan

New User


Joined: 21 Jul 2005
Posts: 23
Location: USA

PostPosted: Tue Jul 26, 2005 2:38 pm
Reply with quote

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
View user's profile Send private message
shobam

New User


Joined: 18 Jul 2005
Posts: 34
Location: CN

PostPosted: Wed Jul 27, 2005 10:39 am
Reply with quote

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
View user's profile Send private message
Girishm

New User


Joined: 09 Mar 2005
Posts: 35
Location: Mysore

PostPosted: Mon Aug 01, 2005 1:41 pm
Reply with quote

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
View user's profile Send private message
Girishm

New User


Joined: 09 Mar 2005
Posts: 35
Location: Mysore

PostPosted: Mon Aug 01, 2005 1:41 pm
Reply with quote

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
View user's profile Send private message
Prasanthhere

Active User


Joined: 03 Aug 2005
Posts: 306

PostPosted: Wed Aug 03, 2005 3:09 pm
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Load new table with Old unload - DB2 DB2 6
No new posts Pulling a fixed number of records fro... DB2 2
No new posts Multiple table unload using INZUTILB DB2 2
No new posts Check data with Exception Table DB2 0
No new posts Dynamically pass table name to a sele... DB2 2
Search our Forums:

Back to Top