IBM MAINFRAME HELP & SUPPORT FORUMS

shriya reddy · Joined: 05 Jun 2004 Posts: 45

Hi friends,

I have one query on restart logic in DB2.

In insertion of records in tables i want put commit after every 100 records.how i write the source code.

In insertion my job is abend after 250 records. How i Know that at what record it Abended.

How i restart the job after succssful commit.

please give me these source code....

Regards,
Shriya Reddy.

shriya reddy · Joined: 05 Jun 2004 Posts: 45

Hi friends,

Any body give me the answer.

bye
shriya

janardhana Reddy · Joined: 20 Oct 2004 Posts: 17 Location: Bangalore

Nothing to worry in this case... Any how you are saying that job abended at 250 th record. Check the 250 th record you required updates or inserted at 250 th row.

Basic thing you need to understand is once the job completed normally or abnormally commmit will be done.

Nothing to worry restart as from abended step. In this case you have to know if any scheduler constraints there.

Note: Db2 won't allow more than 10,000 record updates in one job without commit.

shriya reddy · Joined: 05 Jun 2004 Posts: 45

Hi Janardhan,

thanks for reply.

If i don't know at which record insertion my job is abended.how i should know that.

Bye
Shriya

janardhana Reddy · Joined: 20 Oct 2004 Posts: 17 Location: Bangalore

Hi ,

You find record in ceedump or check in the spool :shock:

ksivapradeep · Joined: 30 Jul 2004 Posts: 98

hi, janardhana Reddy

is there any specificlimit that we cant update more than 10000 records b4 commit if so suppose if i give more space to the records for update what happens becoz after giving commit only the records are stored in the table is it correct

regards,
siva pradeep