Posted: Mon Jul 14, 2003 11:22 pm Post subject: failure in registration with tansaction manager
Voyager
Joined: 11 Jun 2003 Posts: 91
Hello,
I Have installed DB2 and MQ Series on Linux/Intel.
I am using MQ Manager for transaction management with DB2.
While running the database coordination sample(amqsxag0.c with only MQBankTB table),I am getting the following error while opening the cursors.
SQL0998N error occured duting transaction or heuristic processing. Reason code ="9". subcode=""
I am using the following configuration:
DB2 database name: db2test
Table Name: MQBankTB
mq.ini contains following stanza:
XaResourceManager:
Name= DB2 db2test
SwitchFile=/home/db2user/db2swit
XaOpenString=db2test
ThreadOfControl=PROCESS
I am running amqsxag executable from db2user. db2user has all privileges for MQ Series.
MQBEGIN call is successful. Cursor declaration is successful. But getting the above error while opening the cursor.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum