| Author |
Message
|
| brgmo |
 Posted: Mon Dec 08, 2003 2:24 pm Post subject: global unit of work on as/400 |
 |
|
Master
Joined: 03 Jun 2002
Posts: 227
|
Hi All
Can i update queue and a database simultaneously on AS/400 using mqseries classes for java or in other words is global unit of work concept supported on as/400.
regards
brgmo |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Mon Dec 08, 2003 2:36 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
If you have an XA compliant datasource for your database on AS/400, and you configure your queue manager to act as a transaction manager for the database, including supplying (and possibly compiling) a switch file.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| leongor |
| Posted: Tue Dec 09, 2003 12:43 am Post subject: |
|
|
Master
Joined: 13 May 2002
Posts: 264
Location: Israel
|
Jeff, I think at AS/400 there is no support for Queue Manager to be transaction manager.
If you need global UOW you must use AS/400 Commitment Control to act as transaction manager.
MQ and Database are only resource managers in this case.
_________________
Regards.
Leonid.
IBM Certified MQSeries Specialist. |
|
| Back to top |
|
|
| mrlinux |
| Posted: Tue Dec 09, 2003 6:29 am Post subject: |
|
|
Grand Master
Joined: 14 Feb 2002
Posts: 1261
Location: Detroit,MI USA
|
The AS/400 does have a OS level Commit/Control logic to allow you to do the UOW transaction, I was under the impression with the release of
MQ v5.2 they added that support to MQSeries, I could be wrong though.
_________________
Jeff
IBM Certified Developer MQSeries
IBM Certified Specialist MQSeries
IBM Certified Solutions Expert MQSeries |
|
| Back to top |
|
|
| leongor |
| Posted: Tue Dec 09, 2003 8:53 am Post subject: |
|
|
Master
Joined: 13 May 2002
Posts: 264
Location: Israel
|
Only for internal UOW. If you want global one you need to use OS/400 Commitment Control.
Here from WebSphere MQ for iSeries System Administration Guide :
| Quote: |
A local unit of work is one in which the only resources updated are those of the WebSphere MQ queue manager. Here, syncpoint coordination is provided by the queue manager itself using a dual-phase commit process and the MQI calls MQBACK and MQCMIT.
WebSphere MQ for iSeries can support and participate in global units of work as a resource manager, coordinated by the OS/400 COMMIT and ROLLBACK commands.
|
_________________
Regards.
Leonid.
IBM Certified MQSeries Specialist. |
|
| Back to top |
|
|
| brgmo |
| Posted: Tue Dec 09, 2003 10:33 am Post subject: |
|
|
Master
Joined: 03 Jun 2002
Posts: 227
|
| how to establish connection between os/400 commitment control and websphere mq for iSeries or as/400 |
|
| Back to top |
|
|
| mrlinux |
| Posted: Tue Dec 09, 2003 11:04 am Post subject: |
|
|
Grand Master
Joined: 14 Feb 2002
Posts: 1261
Location: Detroit,MI USA
|
Actually that is done by a system command, I cant remember the command, but it is in one as400 os system manuals
_________________
Jeff
IBM Certified Developer MQSeries
IBM Certified Specialist MQSeries
IBM Certified Solutions Expert MQSeries |
|
| Back to top |
|
|
|
|
