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: India

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 Splitting one row into multiple Rows ... Rajan Moorthy DFSORT/ICETOOL 9 Mon May 14, 2018 10:58 pm
No new posts help to replace columns by rows Vikas Maharnawar DFSORT/ICETOOL 8 Tue Mar 06, 2018 3:27 pm
No new posts Merging 2 records at multiple rows wi... Bijesh DFSORT/ICETOOL 2 Wed Dec 06, 2017 1:50 am
No new posts Can we combine the rows with same key... V S Amarendra Reddy DB2 14 Fri Dec 01, 2017 10:29 pm
No new posts Conditional highlighting of rows in I... packerm CLIST & REXX 2 Thu Sep 21, 2017 6:50 pm

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