Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Commit/Rollback DB2 in IMS program

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

New User


Joined: 26 Aug 2008
Posts: 6
Location: India

PostPosted: Thu Aug 28, 2008 10:29 am    Post subject: Commit/Rollback DB2 in IMS program
Reply with quote

I am coding DB2 sql statements inside a IMS DB/DC program. Can we use SQL COMMIT and SQL ROLLBACK statements inside the IMS program? If not then how can we commit or rollback DB2 ?

Any inputs in this regard would be appreciated.
Back to top
View user's profile Send private message

rajatbagga

Active User


Joined: 11 Mar 2007
Posts: 193
Location: india

PostPosted: Sun Sep 07, 2008 2:51 am    Post subject:
Reply with quote

Hello,

Oh Yes, I remember i did it long time back...

The SQL verbs COMMIT and ROLLBACK are not valid in IMS/TM program, When an IMS checkpoint is issued in a IMS/TM-DB2 a two phase commit is performed to synchronize the updates made to IMS database with those made to DB2 tables.A component of IMS/TM called the syncpoint coordinator handles the coordiantion of commits.

You can code the IMS checkpoint command which implements the COMMIT as follows:

CALL 'CBLTDLI' USING NUM-OPS,
'CHKP',
IO-PCB,
CHKP-LENGTH,
CHKP-AREA.

You can also code the IMS rollback command as follows:

CALL 'CBLTDLI' USING NUM-OPS,
'ROLB',
IO-PCB,
CHKP-LENGTH,
CHKP-AREA.

In short the IMS commits the data in DB2 as well with the IMS-DB when checkpoint is issued.....same is the case with rollback...

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

New User


Joined: 26 Aug 2008
Posts: 6
Location: India

PostPosted: Mon Sep 08, 2008 11:28 am    Post subject: Commit/Rollback DB2 in IMS program
Reply with quote

Hi Rajat,

Can you please tell me how CHKP-LENGTH and CHKP-AREA should be declared in the IMS-DB2 program and where should it be declared?

Also, I believe IO-PCB is the PCB mask we declare in an IMS/DC MPP program. Correct?


Thanks,

Bala.
Back to top
View user's profile Send private message
rajatbagga

Active User


Joined: 11 Mar 2007
Posts: 193
Location: india

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

Hello Balasubra,

Well from here I ask you to follow the link below:

[url]http://publibz.boulder.ibm.com/cgi-bin/bookmgr/BOOKS/dfsp20d1/1.4.3[/ur

I hope this will help you....

Regards,
Rajat
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 Writing a file using online program grvtomar PL/I & Assembler 3 Fri Jun 30, 2017 1:06 pm
No new posts pre-compiler for program in an HFS Pedro DB2 0 Fri Jun 23, 2017 11:13 pm
No new posts Compiling program in endeavor for tra... RALAKKAL Compuware & Other Tools 4 Mon Jun 05, 2017 8:27 pm
No new posts COBOL DB2 program - zIIP eligible vasanthz COBOL Programming 7 Wed May 31, 2017 5:12 am
No new posts DB2 Program abending without giving a... rahulgarg14 DB2 7 Mon May 29, 2017 8:10 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us