Commit both in DB2 and MQ

About CICS and BMS - In this Mainframe Forum - You can post your queries on CICS

Moderators: DikDude, Natarajan, Moderator Group

Post Reply
jackie
Member
Posts: 3
Joined: Fri Dec 29, 2006 5:30 pm
Location: Israel

Commit both in DB2 and MQ

Post by jackie » Fri Jul 27, 2007 10:36 am

Hi,

In our cics program we read db2 table, take the apropriate rows and send them using MQ. After sending we mark (update) a row with status of "sent".

The question is, how it is possible to make a commit in both MQ and DB2 systems simultaneously in cics?

Is cics command 'exec cics syncpoint' is the right solution?
Jack

User avatar
dbzTHEdinosauer
Moderator
Posts: 981
Joined: Mon Oct 02, 2006 8:31 pm

Post by dbzTHEdinosauer » Fri Jul 27, 2007 1:19 pm

is mq part of websphere?
what os? os390 or z/os
what cics?
do you have RRS?
Dick Brenholtz
JCL, SQL and code in programs have an irritating habit of doing what you say,
not what you meant.

jackie
Member
Posts: 3
Joined: Fri Dec 29, 2006 5:30 pm
Location: Israel

Post by jackie » Fri Jul 27, 2007 3:16 pm

is mq part of websphere?
what os? os390 or z/os
what cics?
do you have RRS?
mq is part of websphere
z/os
cics - one of the last versions of cics
what is it - RRS ?
Jack

User avatar
dbzTHEdinosauer
Moderator
Posts: 981
Joined: Mon Oct 02, 2006 8:31 pm

Post by dbzTHEdinosauer » Fri Jul 27, 2007 3:52 pm

If you have websphere and z/os, then your shop had Resource Recovery Systems provided in the bundle. You can use RRS to manage both the db2 and mqs resources.

These manuals I have locally, you can use the number to access them from the ibm z/os library server
SG24-6980-00 Redbook
SG24-6985-00 Redbook
SA22-4616-05 /IEA2N150 Programming RRS.

and I am sure there is something in the websphere library on rrs. just do a search.
Dick Brenholtz
JCL, SQL and code in programs have an irritating habit of doing what you say,
not what you meant.

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others