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
 

 

Cursor and Abend

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: Cursor and Abend
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

Site Director


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

PostPosted: Fri Jan 29, 2010 8:21 am    Post subject:
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    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 IMS BMP program causes 878 system abend Artemk IMS DB/DC 7 Tue Nov 22, 2016 8:26 pm
No new posts Updating Cursor row withour using FOR... chandan.inst DB2 15 Tue Nov 08, 2016 11:17 am
No new posts abend sort based on count records in ... anatol DFSORT/ICETOOL 5 Mon Oct 17, 2016 10:10 pm
No new posts hot to get details when "EXEC CI... Andi1982 CICS 11 Tue Sep 20, 2016 5:01 pm
No new posts Variable for cursor names ravikumar15 DB2 5 Sun Jul 17, 2016 7:08 am


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