Updating the db2 records

ramya_1714 · New User Joined: 22 Feb 2006 Posts: 2

Hi all!

one of my job doing update the database, the total record is 3500, the job got abend after updating some of the records, how to restart to update the record, which got updated last, any log is there?pleas let me clear my doubt

Thanks
Ramya

Gurmeet · New User Joined: 22 Feb 2006 Posts: 46 Location: Pune

Ramya,

Lets take following cases,

1. If you are trying to update all the 3500 records in one update query, then you cannot restart the job i.e. the updates happened before abend would be rolled back and you need to run the query again from the beginning.

2. If there are multiple queries then you need to fire commit statement after each update query to make the updates permanent. In this case you can restart you job from the query which abended.

Hope this clarifies your doubt.

Regards,
~Gurmeet

stly · New User Joined: 25 Jul 2005 Posts: 93

please search in the forum regarding restart of cobol-db2 program.
iu iwll get the necessary info.

d?b?2-fr · New User Joined: 31 May 2006 Posts: 1

Hello Ramya,

as Gurmeet said, DB2 always lets the data in a consistency state, depending on how your application is written.
Is there a program or a simple SQL request running ?
Are there explicit COMMIT Sql statements ?
What was the SQL return code ?
Did your unit of work update any dataset during the same time ?
....

Many questions to answer to, before deciding to rerun the job or not .

Good luck.

VITTAL · New User Joined: 13 Mar 2006 Posts: 1

PL EXPLAIN HOW I NEED TO CONVERT CHARACTER FORMAT INTO DATE FORMAT IN DB2