Page 1 of 1

Checkpoint Restart for DB2 select query.

PostPosted: Mon Aug 03, 2015 12:59 pm
by arpitpatel01
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.

Re: Checkpoint Restart for DB2 select query.

PostPosted: Mon Aug 03, 2015 1:35 pm
by enrico-sorichetti
... DB2 region down ...


if the DB2 production region is down, your organization has bigger issues than an interrupted select :mrgreen:

Re: Checkpoint Restart for DB2 select query.

PostPosted: Mon Aug 03, 2015 2:29 pm
by arpitpatel01
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 ?

Re: Checkpoint Restart for DB2 select query.

PostPosted: Mon Aug 03, 2015 3:13 pm
by NicC
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.