Checkpoint Restart for DB2 select query.



Support for OS/VS COBOL, VS COBOL II, COBOL for OS/390 & VM and Enterprise COBOL for z/OS

Checkpoint Restart for DB2 select query.

Postby arpitpatel01 » Mon Aug 03, 2015 12:59 pm

Hi,
I have a cobol code which uses a DB2 SELECT query to unload all the data present in the DB2 table and then write it to a flat file.
My question is, if during the execution of this DB2 select query, if due to any reason(DB2 region down, etc.), job abends, then i need to restart the job
again and the execution should start from the last row fetched before abend.

Is this possible ? If Yes, then how?

(Note: SELECT query includes data to be fetched from 5 DB2 tables)

Kindly assist me on this.
arpitpatel01
 
Posts: 15
Joined: Wed Mar 25, 2015 9:32 am
Has thanked: 0 time
Been thanked: 0 time

Re: Checkpoint Restart for DB2 select query.

 

Re: Checkpoint Restart for DB2 select query.

Postby enrico-sorichetti » Mon Aug 03, 2015 1:35 pm

... DB2 region down ...


if the DB2 production region is down, your organization has bigger issues than an interrupted select :mrgreen:
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2790
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 148 times

Re: Checkpoint Restart for DB2 select query.

Postby arpitpatel01 » Mon Aug 03, 2015 2:29 pm

You are correct, Enrico. I agree with you.
But that was just a scenario that i mentioned. :)

Could you please assist me with the solution to my acutal question ?
arpitpatel01
 
Posts: 15
Joined: Wed Mar 25, 2015 9:32 am
Has thanked: 0 time
Been thanked: 0 time

Re: Checkpoint Restart for DB2 select query.

Postby NicC » Mon Aug 03, 2015 3:13 pm

Have you searched for check-point restart in the forum or in the big wide world? It is mentioned often enough in the forum - check both the Languages section and the DB2 section.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 2820
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 118 times


Return to IBM Cobol

 


  • Related topics
    Replies
    Views
    Last post