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

Efficient Checkpoint in Db2 update program.


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

New User


Joined: 07 Dec 2007
Posts: 26
Location: Bangalore

PostPosted: Tue Dec 11, 2007 10:50 am
Reply with quote

In my cobol db2 update program ,

To implement the checkpoint logic , we use a sequential file which we will => populate before the updation.
=> commit
=> Close file after every commit .

Again Open file bfore the updation . The purpose of opening and closing file being , at any time there is only one record in the file , which can be read and restart will process from there..

I want to know if there is a more efficient way of storing the checkpoint , instead of openiing and closing the file everytime.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Tue Dec 11, 2007 5:18 pm
Reply with quote

use a db2 table (most shops call them RESTART). Using a sequential file (the closing and reopening is not necessary if it is qsam) is a 'stone wheel and hammer' approach for modern computer technology.


not really important but updation is not an english word/verb or a computer term. UPDATE (or update) is the word. Use all caps to indicate a DB2 table action if you wish.
Back to top
View user's profile Send private message
Aniyaa

New User


Joined: 07 Dec 2007
Posts: 26
Location: Bangalore

PostPosted: Tue Dec 11, 2007 6:25 pm
Reply with quote

Thanks for your suggestions ,

Yes I have heard abt the RESTART table before ,

We UPDATE the restart table every time a COMMIT is done .

At any point of time , there is only ONE record in the RESTART table ? which we would READ after a Abend.
Back to top
View user's profile Send private message
TG Murphy

Active User


Joined: 23 Mar 2007
Posts: 148
Location: Ottawa Canada

PostPosted: Fri Dec 14, 2007 1:36 am
Reply with quote

Most shops use a DB2 RESTART table that is shared by many batch jobs. In which case the table might have several rows...
Back to top
View user's profile Send private message
Aniyaa

New User


Joined: 07 Dec 2007
Posts: 26
Location: Bangalore

PostPosted: Mon Dec 17, 2007 4:32 pm
Reply with quote

Thanks for all the information
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 Using API Gateway from CICS program CICS 0
No new posts DB2 Event passed to the Application P... DB2 1
No new posts How to pass the PARM value to my targ... COBOL Programming 8
No new posts REXX code to expand copybook in a cob... CLIST & REXX 2
No new posts EZT program to build a flat file with... All Other Mainframe Topics 9
Search our Forums:

Back to Top