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

Cursor and Abend


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

Active User


Joined: 27 May 2008
Posts: 121
Location: India

PostPosted: Fri Jan 29, 2010 6:29 am
Reply with quote

Case Study related to the Cursor--

Suppose we are updating or we have to update a DB of 5000 records and after updating 50 records we commit the DB and after commiting there is an Abend.What precautions we can take at this step so that we can smoothly update the rest of the records?

OR

After the abend suppose we solve the abend then how do we proceed further to update rest of the records?

a.The same case above can be implemented for some other transaction rather than updating. What should be done in such case?

b.If while performing some transaction through cursor, there is an abend then how it can be resolved?

3.Where and when the cursor hits the DB for the first time?
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Fri Jan 29, 2010 8:21 am
Reply with quote

Hello,

Determining a restart/recovery strategy is not really a forum-type topic. It is also not something addressed by some individual developer for one requirement.

Organizations that use checkpoint/restart have a formal methodology in place and if you intend include this in your processes, you need to learn and follow whatever the current standards require.

More and more places no longer implement this due to the increased power of the cpus and dasd.
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 ISAM and abend S03B JCL & VSAM 10
No new posts Abend S0C4 11 (Page Translation Excep... PL/I & Assembler 16
No new posts WER999A - UNSUCCESSFUL SORT 8ED U Ab... SYNCSORT 5
No new posts the system or user abend SF0F R=NULL COBOL Programming 0
No new posts Need to get an DLI abend like U0200 IMS DB/DC 2
Search our Forums:

Back to Top