IBM Mainframe Forum

by **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.

by **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:

by **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 ?

by **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.

IBM Mainframe Forum

Checkpoint Restart for DB2 select query.

Checkpoint Restart for DB2 select query.

Re: Checkpoint Restart for DB2 select query.

Re: Checkpoint Restart for DB2 select query.

Re: Checkpoint Restart for DB2 select query.