Re-insert record into a DB2 table.

Somnath Pal Chaudhuri429 · New User Joined: 28 Feb 2013 Posts: 1 Location: India

Hi -

Can anyone please let me know how to start re-inserting records into a DB2 Table from a file (thru a program) from the record that was inserted last before the job or DB2 went down.

Ex: I have 100 records. Now i have inserted some 'X' records & committed when the DB2 fails / job abends. Once the issue is fixed, I have to start inserting the records in the Table again but from 'X+1' record of the file. Now how to keep a track of the 'X' no. of records that are already committed in the DB2 Table.

Can anyone please let me know (with explanation) how it can be done.

prino · Posted: Tue Mar 05, 2013 3:19 pm

By completely redesigning the process from the bottom up.

Records that are to be inserted into a table should be correct, so you need a program that is run before the program that inserts them to check their validity.

Anuj Dhawan · Posted: Tue Mar 05, 2013 4:36 pm

Unless you deploy a check-point restart in the system, I doubt it can be done. However, if it's one time job and as you talked about input file here:

GuyC · Posted: Thu Mar 07, 2013 9:15 pm

You might want to go to best-buy and get a DB2 row-re-inserter. I think they are about 50$.

dick scherrer · Posted: Fri Mar 08, 2013 7:57 am

Hello,

For 100 rows, do not be concerned with restart. Run the process as a single unit of work. If there is an abend, all will be backed out. If the run is successful, all will be committed.

Anuj Dhawan · Posted: Fri Mar 08, 2013 12:08 pm

enrico-sorichetti · Posted: Fri Mar 08, 2013 12:40 pm

from the TS profile