Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

How to RESTART the Job after the 250 Record Updated

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
shriya reddy
Warnings : 1

New User


Joined: 05 Jun 2004
Posts: 43

PostPosted: Tue Nov 16, 2004 11:23 pm    Post subject: How to RESTART the Job after the 250 Record Updated
Reply with quote

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
View user's profile Send private message

shriya reddy
Warnings : 1

New User


Joined: 05 Jun 2004
Posts: 43

PostPosted: Fri Nov 19, 2004 6:20 pm    Post subject:
Reply with quote

Hi friends,

Any body give me the answer.

bye
shriya
Back to top
View user's profile Send private message
janardhana Reddy

New User


Joined: 20 Oct 2004
Posts: 17
Location: Bangalore

PostPosted: Sat Nov 20, 2004 11:21 am    Post subject:
Reply with quote

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
View user's profile Send private message
shriya reddy
Warnings : 1

New User


Joined: 05 Jun 2004
Posts: 43

PostPosted: Sat Nov 20, 2004 10:30 pm    Post subject:
Reply with quote

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
View user's profile Send private message
janardhana Reddy

New User


Joined: 20 Oct 2004
Posts: 17
Location: Bangalore

PostPosted: Tue Nov 23, 2004 3:00 pm    Post subject:
Reply with quote

Hi ,

You find record in ceedump or check in the spool icon_eek.gif
Back to top
View user's profile Send private message
ksivapradeep

New User


Joined: 30 Jul 2004
Posts: 95

PostPosted: Mon Nov 29, 2004 3:40 pm    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Restart=Step not working ALAK SAHA JCL & VSAM 6 Fri Jun 30, 2017 6:28 pm
No new posts Need to write record of PS File in ex... Chandan1993 JCL & VSAM 1 Wed Jun 07, 2017 1:35 am
No new posts Adding big TEXT lines to each record ... bshkris SYNCSORT 4 Sat May 06, 2017 1:40 am
This topic is locked: you cannot edit posts or make replies. Merge two files and update Trailer re... Yashashri JCL & VSAM 1 Thu May 04, 2017 12:54 pm
No new posts Sort Large record length cmsmoon DFSORT/ICETOOL 14 Tue Apr 11, 2017 5:49 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us