How To restart DB2 Query

IBM's flagship relational database management system

How To restart DB2 Query

Postby prasadnaidu » Wed Sep 23, 2009 7:17 pm


i am facing a problem while working with DB2 in COBOL. i.e,

in my table i have 2000 records. i am upadting total records.
after updating 992 record my job is abended. i want to restart my job from 993 record onwards to update.
is there any option to do like this.

help me any one,

Posts: 14
Joined: Fri Aug 14, 2009 10:25 pm
Has thanked: 0 time
Been thanked: 0 time

Re: How To restart DB2 Query

Postby dick scherrer » Thu Sep 24, 2009 12:33 am


There is nothing automatic. . . You would need to incorporate the site standard restart procedure (if the system handles this sort of processing, there should already be a standard method and this process should use the standard).

Is there some reason the updates were not backed out? Suggest that such a process does not want/need commits.
Hope this helps,
User avatar
dick scherrer
Global moderator
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Return to DB2


  • Related topics
    Last post