Restart logic in DB2 program.

rz061m · New User Joined: 03 Mar 2006 Posts: 48 Location: Chennai

Hi all,

How do i restart a DB2 program from the record that caused the abend rather than from the first record?

What are the special definitions or DB2 statement that needs to be included in the program to handle this restart logic?

Thanks,
RZ061M

dick scherrer · Posted: Fri Sep 21, 2007 10:36 pm

Hello,

Unless you checkpoint after every insert/update/delete, you cannot.

I'd suggest you talk with youjr DBA(s) and find out how checkpoint/restart is supposed to work on your system/application. Each developer should not create their own version of checkpoint/restart.

rz061m · New User Joined: 03 Mar 2006 Posts: 48 Location: Chennai

Thanks for the info.

thanks,
RZ061M

dick scherrer · Posted: Fri Sep 21, 2007 11:24 pm

You're welcome

anv2005 · New User Joined: 14 Jul 2005 Posts: 44 Location: US

Does your program access any other data besides DB2?
Does your program process sequential or VSAM files?
Does your program rely on working-storage contents?

If the answer is yes, then you need to consider to keep these "other" application resources in sync with DB2 data as well.

This synchronization processing includes COMMITs, ROLLBACKs and application restarts.

It is not simple to synchronize DB2 and non-DB2 resources across COMMITs, ROLLBACKs and RESTART.

Regards,
Alex.