IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

How to restart from a particular record


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
brahmanandareddy

New User


Joined: 16 Dec 2004
Posts: 44
Location: Hyderabad

PostPosted: Wed Dec 21, 2005 1:09 am
Reply with quote

I have 2 lakhs records in a table. I used commit for every 1000 records. While running the cobol-db2 program it was abended at 50001st record. I want to run from this record. How should I restart running from 50001st record?
Back to top
View user's profile Send private message
raghunathns

Active User


Joined: 08 Dec 2005
Posts: 127
Location: rochester

PostPosted: Wed Dec 21, 2005 12:44 pm
Reply with quote

hi,

there will be a restart table in your environment. if not you create a table for restart.

in your program before commit you write the last record processed key to the restart table and commit. this will happen after each 1000th record.

if it abends after commiting 5000 records. restart table have 5000 record key.
second time you program will check the restart table key and start from > 5000 record key.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts FINDREP - Only first record from give... DFSORT/ICETOOL 3
No new posts To find whether record count are true... DFSORT/ICETOOL 6
No new posts Validating record count of a file is ... DFSORT/ICETOOL 13
Search our Forums:

Back to Top