View previous topic :: View next topic
|
Author |
Message |
shriya reddy Warnings : 1 New User
Joined: 05 Jun 2004 Posts: 43
|
|
|
|
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. |
|
Back to top |
|
|
shriya reddy Warnings : 1 New User
Joined: 05 Jun 2004 Posts: 43
|
|
|
|
Hi friends,
Any body give me the answer.
bye
shriya |
|
Back to top |
|
|
janardhana Reddy
New User
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. |
|
Back to top |
|
|
shriya reddy Warnings : 1 New User
Joined: 05 Jun 2004 Posts: 43
|
|
|
|
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 |
|
Back to top |
|
|
janardhana Reddy
New User
Joined: 20 Oct 2004 Posts: 17 Location: Bangalore
|
|
|
|
Hi ,
You find record in ceedump or check in the spool |
|
Back to top |
|
|
ksivapradeep
New User
Joined: 30 Jul 2004 Posts: 95
|
|
|
|
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 |
|
Back to top |
|
|
|