Problem with Two phase commit (WebShpere-MQ)

[Devesh H Rao]

Hi,

I need some help to figure out what may be happening as i am not getting any error trace or exception.

I am selecting some values from database packaging the information and putting it in MQ, if the steps are successful i am updating certain statuses in the database so the flow is for the following transactions are

1. Select
2. Put in MQ
3. Update

I am facing a problem where in the tables locks whenever the API is called. after some time the transaction times out and rolls back.

I am working on the following config

Server = Websphere v5
MQ = v5.2
DB2 = v8.1
Database Drivers = Type 2 XA complaint
API transaction type = "TX_REQUIRED"

can anyone help me out in here as i think i have missed out on some configuration or done some configuration in a wrong way.


Thanks & Regards
[ May 23, 2004: Message edited by: Devesh H Rao ]

[Suttan Pym]

Hi,
What is the isolation-level used during database access. The porblem seems that the select is getting lock on the table and you are not able to update the data. To confirm this just try to start the Transaction after the select and it would work. (Anyway select need not be within a Transaction - right).

Suttan