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
 

 

Isolation level in IMS

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
View previous topic :: :: View next topic  
Author Message
Nagendran

New User


Joined: 24 Jan 2007
Posts: 89
Location: USA

PostPosted: Thu Sep 04, 2008 8:19 pm    Post subject: Isolation level in IMS
Reply with quote

Hi,

I am having an online transaction which will update three IMS Databases.

The job abended After updating first two IMS databases and before updating third database.

Even though the job got abended, the update was not rolled back from the first two database.

Here the three DB's are not in Sync. Could any body tell me how to maintain ISOLATION level in IMS?


Thanks,
Nagendran.R
Back to top
View user's profile Send private message

rajatbagga

Active User


Joined: 11 Mar 2007
Posts: 188
Location: india

PostPosted: Sun Sep 07, 2008 1:34 am    Post subject:
Reply with quote

Hello,

In this regard ISOLATION level in IMS can be maintained by using Checkpoints in the application program.

Regards,
Rajat
Back to top
View user's profile Send private message
Sandy Zimmer

Active Member


Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE

PostPosted: Tue Sep 09, 2008 4:09 am    Post subject:
Reply with quote

You cannot have checkpoints in an IMS DC program - only in BMP. You may want to check with your systems programmers about your automatic backout. If your program updated 2 of 3 databases in 1 transaction and did not automatically backout the updates then you have a big problem.
Back to top
View user's profile Send private message
rajatbagga

Active User


Joined: 11 Mar 2007
Posts: 188
Location: india

PostPosted: Wed Sep 10, 2008 9:46 am    Post subject:
Reply with quote

Well i did and there i a way for Checkpoints in MPPs and Transaction-Oriented BMPs.

kindly refer to the link below for more information:

http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.ims9.doc.apdg/p1hpprc.htm
Back to top
View user's profile Send private message
Bitneuker

CICS Moderator


Joined: 07 Nov 2005
Posts: 1105
Location: The Netherlands at Hole 19

PostPosted: Fri Sep 12, 2008 9:31 pm    Post subject:
Reply with quote

That probably was muliple-mode. Sandy referred to the common way of single-mode where checkpoints are implicit at the GU-call at the message-queue which is done after hitting the ENTER key (or after the program switch).

Edit:
For TS; follow the sticky, there's a lot about isolation.
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 -> IMS DB/DC All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Syncsort TPF Level Majid Hussain SYNCSORT 2 Wed Apr 13, 2016 2: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 DB2 10.1 Share level locking and Sele... Mary Lewis DB2 1 Wed Apr 15, 2015 9:51 pm
No new posts CICS SE Level Openings in Accenture enikhilk Mainframe Jobs 0 Mon Sep 01, 2014 6:39 pm
No new posts 88 level variable logic not working sandeep kumar302 COBOL Programming 19 Thu Jul 31, 2014 10:59 am


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