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

hai,

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,

regarrds,
prasad
prasadnaidu
 
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

Hello,

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,
d.sch.
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
    Replies
    Views
    Last post