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
 

 

Need Help For RESTART LOGIC in DB2

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Jiya_su

New User


Joined: 11 Dec 2006
Posts: 7
Location: hyderabad

PostPosted: Wed Jan 03, 2007 12:51 am    Post subject: Need Help For RESTART LOGIC in DB2
Reply with quote

1) My table contains 1 million of records.. while writing this record to a file if any error occurs at some 99000 record instead of doing roll back all records I have to restart from the 99000 record what is the restart logic for that in db2

===> ANSWER of this Que what i know is that

The logic will be handled by a restart file where we are going to make an entry for every commit and commit count will be given by us only..
If any abend occurs the process will start from the last committed record.

But i need actual coding that how to create restart file & how it will read after ABEND this file....
I Hoping that u understand my problem.....

THANKS IS ADVANCE....
Back to top
View user's profile Send private message

DavidatK

Active Member


Joined: 22 Nov 2005
Posts: 700
Location: Troy, Michigan USA

PostPosted: Wed Jan 03, 2007 1:43 am    Post subject:
Reply with quote

Jiya_su,

Check out this PREVIOUS POST

Most shops will have a DB2 table set up just for the checkpoint records.

If questions still persist, please let me know and I can walk you through the logic.
Back to top
View user's profile Send private message
humpty
Warnings : 1

New User


Joined: 01 May 2005
Posts: 23

PostPosted: Wed Jan 03, 2007 2:53 pm    Post subject: Re: Need Help For RESTAR LOGIC
Reply with quote

dear,

what i understand from the query is that your table contains 1 million records and you want to write the records to the flat file and you want to avoid rollback.

okay. you are confused in your query. let me explain you.
the answer you gave is entirely different from the questions posted.

while inserting row in the table, if there is any invalid entry, then there is a ROLLBACK. where as in the case of writing the records from table to file you do not experience any ROLLBACK. we simpy unload the table to flat file using the unload card.

Unloading simply creates the copy of the records in the table, to a flat file. There is nothing like ROLLBACK during unloading.

whereas, while inserting the rows in the table we need to be caution about invalid keys which may result in ROLLBACK. in case of insertions we use the commit logic and restart pionts.

Clear......??
Go ahead and unload the table to flat file.

icon_smile.gif
Back to top
View user's profile Send private message
Jiya_su

New User


Joined: 11 Dec 2006
Posts: 7
Location: hyderabad

PostPosted: Thu Jan 04, 2007 9:03 pm    Post subject: Need Help For LOAD in DB2
Reply with quote

@humpty

Thanks

If possible for u can u send me JCL for card for LOAD & UNLOAD table
Or at least can u suggest any link for it......

Once again thanks in advance.......
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 Need help in building a logic Benchwarmer All Other Mainframe Topics 4 Wed Feb 22, 2017 2:49 am
No new posts Wildcard logic in COBOL dudenithy COBOL Programming 13 Thu Sep 01, 2016 7:36 pm
No new posts Sort Logic to extract data scorp_rahul23 DFSORT/ICETOOL 13 Tue Mar 01, 2016 1:22 am
No new posts Need a logic to validate the data in ... sandeep kumar302 COBOL Programming 17 Mon Feb 01, 2016 3:30 pm
No new posts Tricky sort logic required pgopi92 DFSORT/ICETOOL 3 Mon Jan 25, 2016 3:29 pm


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