Global Unit of Work - Or Read from MQ insert into Table

[mark1024]

I have a MQ job that reads MQ, parses the table name, then parses the columns for that table. I would like to only delete the msg off the MQ when the DB2 commits. delete (under transaction).

THe problem I am having is that if I get a resource unavilable on DB2 Side and get a sig int, then the commit does nto happen and the Message is still taken off MQ, because "Only local units of work are supported"

From the MQ Connectivity Guide.

Note: Global units of work cross MQ and RDBMS boundaries, such as reading a message, then performing an SQL insert. These global units of work are not currently supported. Only local units of work are currently supported.

Reading from MQ and inserting into a DB is excatly want I want to do within a transaction.

Any suggestions on how to do this? I read some blogs online, but not any good solutions.

--All coded up and nowhere to go.

[eostic]

...take a close look at the DTS Stage --- the Distributed Transaction Stage....it takes advantage of MQ's ability to perform the overall unit of work......so that......"if" you have things correctly configured in MQ to support a x-resource (XA) unit of work between MQ and DB2 or MQ and Oracle [ODBC came a long a little while ago also, as I recall], then the DTS stage will issue the appropriate calls to make it happen.....

...it's more complicated than that, with a work queue that "saves" the message at the source, as soon as you read it, under syncpoint, so that it is not lost, etc., but DTS is the place to start.

Ernie