Page 1 of 1

Commit both in DB2 and MQ

Posted: Fri Jul 27, 2007 10:36 am
by jackie
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?

Posted: Fri Jul 27, 2007 1:19 pm
by dbzTHEdinosauer
is mq part of websphere?
what os? os390 or z/os
what cics?
do you have RRS?

Posted: Fri Jul 27, 2007 3:16 pm
by jackie
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 ?

Posted: Fri Jul 27, 2007 3:52 pm
by dbzTHEdinosauer
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.