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
 

 

Efficient Checkpoint in Db2 update program.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: Efficient Checkpoint in Db2 update program.
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    Post subject:
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    Post subject: Reply to: Efficient Checkpoint in Db2 update program.
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: 149
Location: Ottawa Canada

PostPosted: Fri Dec 14, 2007 1:36 am    Post subject:
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    Post subject: thanks
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    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 Executing OO COBOL program invoking J... Virendra Shambharkar COBOL Programming 2 Tue Jan 10, 2017 6:37 pm
No new posts Need Suggestion on COBOL program vickey_dw COBOL Programming 5 Thu Jan 05, 2017 10:55 pm
No new posts I can not compile my program PL1 V3.R... Miguel Fernandez PL/I & Assembler 13 Tue Dec 06, 2016 8:30 pm
No new posts IMS BMP program causes 878 system abend Artemk IMS DB/DC 7 Tue Nov 22, 2016 8:26 pm
No new posts -913/-911 Deadlock during UPDATE stat... NoSleep319 DB2 5 Fri Nov 18, 2016 12:37 am


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