Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Restarting job after a updatation of some rows

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
suny_sn1

New User


Joined: 26 Jun 2007
Posts: 6
Location: India

PostPosted: Wed Oct 10, 2007 11:00 am    Post subject: Restarting job after a updatation of some rows
Reply with quote

Hi,
I m currently running a job to update the salary of the employees for 2008 and i have a commit logic for comminting after 1000 rows.now if i have to restart my job which suppose abended after updating 2000 records out of a total of 20k records, i found 2 solutions to it..

a) get the timestamp field added to the salary update table and from the cursor exclude the rows for which salary have been updated for 2008 by checking timestamps.

b)second method was using db2 checkpoints but i dont how to use them in the progam.

Now which of the two solutions should i go for and new ideas are always invited.icon_smile.gif
Also if you have link about how to use db2 checkpoints please provide me so as i cudnt find the same in sql reference and appplication programming guide for db2
Thanx in advance
Back to top
View user's profile Send private message

Prasanthhere

Active User


Joined: 03 Aug 2005
Posts: 306

PostPosted: Wed Oct 10, 2007 2:31 pm    Post subject: Reply to: Restarting job after a updatation of some rows
Reply with quote

Hi,

For this you have to include the restart logic with in your program.

Please check this link

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNAG0G3/4.4?DT=20010421154551
Back to top
View user's profile Send private message
hemanth.nandas

Active User


Joined: 18 Aug 2007
Posts: 120
Location: Chennai

PostPosted: Wed Oct 10, 2007 5:16 pm    Post subject:
Reply with quote

Hi All,


Quote:
For this you have to include the restart logic with in your program.

Please check this link

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNAG0G3/4.4?DT=20010421154551



This link is different requirement than one asking for.

Hi Prashanth, The link you had given here is for STARTING OR RESTARTING DB2 System when system goes down.

But Suny asked for Check Point and Restart Logic. That, we usually adopt in program logic.

Many Application uses this logic with different scenerio.

Hi Suny,

In our application we are calling pgm to do so. In this, we are checking rec-count, based on this we will make the entry in DB2 table(we are using separate table as check_point_table). And hence pgm will refer the same in check_point_table when next time you run the pgm.

But Same can be achieved, If you are running a IMAGE utility for DB2 in your job(I am not sure about it, But it may be CA11 PROC, IF any one knows it please answer for the same).

Thanks & Regards
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 Conditional highlighting of rows in I... packerm CLIST & REXX 2 Thu Sep 21, 2017 6:50 pm
No new posts column with count of rows within dist... ronald wouterson DB2 4 Sun Sep 17, 2017 9:48 pm
No new posts Convert rows and column into JSON for... Dinesh Manivannan DB2 2 Sun Sep 03, 2017 6:50 pm
No new posts self-restarting jobs in OPC jzhardy IBM Tools 1 Mon Aug 21, 2017 10:15 am
No new posts compare 2 rows within the same file ram_vizag SYNCSORT 7 Wed Jun 14, 2017 12:34 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us