Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

what is the restart table in db2?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: what is the restart table in db2?
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    Post subject: Re: what is the restart table in db2?
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    Post subject: Re: what is the restart table in db2?
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    Post subject:
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    Post subject: Re: what is the restart table in db2?
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    Post subject: Re: what is the restart table in db2?
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    Post subject: Restart
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Data replication from multiple Db2 ta... kishpra DB2 5 Mon Mar 27, 2017 9:58 pm
No new posts how to send just 10 rows in a CICS sc... Megha Gupta CICS 5 Thu Feb 23, 2017 6:57 pm
No new posts Join of more than one table dibyendumandal11111 DB2 6 Mon Feb 13, 2017 11:36 pm
No new posts SQL query to run through list of valu... Ni3-db2 DB2 14 Wed Dec 14, 2016 9:52 am
No new posts Need Rexx Program to Load in to DB2 T... Hareesh Verma CLIST & REXX 22 Tue Sep 20, 2016 2:59 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us