Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
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
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?


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


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 Testing rerad cursor for status with ... John F Dutcher DB2 8 Fri May 19, 2017 9:35 pm
No new posts Getting -504 Cursor Name GTT-ARTS-CUR... Robin Sulsona DB2 2 Fri Mar 17, 2017 1:43 am
No new posts IMS region inactive - User abend code... gthmrj IMS DB/DC 5 Tue Mar 07, 2017 12:29 pm
No new posts Release of Adabas Cursor mohitsethi All Other Mainframe Topics 1 Mon Feb 06, 2017 8:36 pm
No new posts IMS BMP program causes 878 system abend Artemk IMS DB/DC 7 Tue Nov 22, 2016 8:26 pm

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