RE: MQSeries

["McCallion, Martin" <martin.mccallion@xxxxxxxxx>]

Patrick F. O'Dowd wrote:

> Thanks Martin, would you know if the commit and backout from the
> MQQueueManger class can control updates to the database on 
> the as400 as
> well as the MQ messages e.g. I read messages from a queue 
> under syncpoint,
> write them to a file then issue a commit if all is okay, a 
> backout if there
> is an error, the commit/backout would apply to both the MQ messages/db
> updates, from what I remember previously I had to do the db commit and
> rollback via  a CL (this was about 4 years ago from C on the 400)


Patrick,

Sorry I didn't get back sooner.  I'm afraid I don't know whether the
methods on the MQQueueManger class will affect the database, but I'd be
fairly surprised if it did.  Similarly to you, I have done combined
database and MQ operations, but from RPG.  In that case RPG's commit and
rollback operations affected both the DB and the queue manager.
However, to be able to control it all from the MQQueueManger class I
think you would have to be using MQSeries as an XA transaction manager.
Which I think you can do, but I don't know how.

Cheers,

Martin.

-- 
Martin McCallion
Senior Technical Consultant
Misys Wholesale Banking Systems
1 St George's Road, London, SW19 4DR, UK
T +44 (0)20 8486 1951
F +44 (0) 20 8947 3373
martin.mccallion@xxxxxxxxx
www.misys.com

This email and any attachments have been scanned for known viruses using
multiple scanners. We believe that this email and any attachments are
virus free, however the recipient must take full responsibility for
virus checking. This email message is intended for the named recipient
only. It may be privileged and/or confidential. If you are not the
intended named recipient of this email then you should not copy it or
use it for any purpose, nor disclose its contents to any other person.
You should contact the Misys Banking and Securities Division as shown
below so that we can take appropriate action at no cost to yourself. 

Misys Banking and Securities Division, 1 St George's Road, Wimbledon,
London, SW19 4DR, England. Email: banking.postmaster@xxxxxxxxxx Tel: +44
(0) 20 8879 1188 Fax: +44 (0) 20 8947 3373