Recommended value of DB2 XA_OPEN string Thread of Control parameter for TXSeries

Technote (troubleshooting)


Problem(Abstract)

This document explains the recommended setting for IBM DB2 XA Open string parameter Thread of Control parameter for TXSeries.

Symptom

The XAER_PROTO error appears with the CICS application server when you use IBM DB2 as XA configured RM with TXSeries.

The following error messages might get logged into CICS region console file:

ERZ080101W/8017 06/28/10 11:22:02.105439756 REGION01 1261888/0011 :
XA Resource Manager error -6 in 'XA_COMMIT' by 'DB2 for AIX' for XID '
539e561f33149e7b44daee583c504c9f0358bbf5
01f49d2967d6c4a1ad1ed54265f0ac68a45be5eb28' (Transaction='J60',
TermId='', UserId='CICSUSER'). 'The Resource Manager has not committed
its work'. ''.
11 16704 10/06/28-11:22:02.112184 5c2c0827 W Unexpected xaRetCode --
0xfffffffa (XAER_PROTO) from xa_commit to RM 0 for XID --
(formatID=113577, gtrid_length=20, bqual_length=21,
gtrid=539e561f33149e7b44daee583c504c9f0358bbf5,
bqual=01f49d2967d6c4a1ad1ed54265f0ac68a45be5eb28).
11 16704 10/06/28-11:22:02.118068 5c401417 W Recording heuristic
damage for XID -- (formatID=113577, gtrid_length=20, bqual_length=21,
gtrid=539e561f33149e7b44daee583c504c9f0358bbf5,
bqual=01f49d2967d6c4a1ad1ed54265f0ac68a45be5eb28)
11 16704 10/06/28-11:22:02.118668 5c400417 W Recording heuristic
damage for XID -- (formatID=113577, gtrid_length=20, bqual_length=21,
gtrid=539e561f33149e7b44daee583c504c9f0358bbf5,
bqual=01f49d2967d6c4a1ad1ed54265f0ac68a45be5eb28)
ERZ016007E/0220 06/28/10 11:22:02.448087649 REGION01 1261888/0001 :
Abnormal termination A16Y: Problem during SYNCPOINT



Resolving the problem

The error appears when you use DB2 xa_open connection string parameter Thread of Control with default value as T (OS Thread) instead of P (OS Process). You need to use the Thread of Control parameter of xa_open string as P for IBM TXSeries when you configure DB2 as XA Resource Manager.

Rate this page:

(0 users)Average rating

Document information


More support for:

TXSeries
CICS

Software version:

6.2, 7.1

Operating system(s):

AIX, HP Itanium, HP-UX, Solaris, Windows

Reference #:

1613432

Modified date:

2013-09-23

Translate my page

Machine Translation

Content navigation