xa_open failure with SQLCODE=-1032

I am using a Tuxedo(v12.2.2.0.0) on Linux（x64) to access DB2 on mainframe through DB2 Connect Server(v9.7).

Now i meet a problem that the TMS_UDB can not start up。 From Tuxedo ULOG, it says:

ERROR: tpopen TPERMERR xa_open returned XAER_RMERR

I checked db2dial log it shows:

2018-XX-XX-xxxx E4387E703   LEVEL: Error
PID     : 12673 TID: 139892007870912 PROC: TMS_UDB
INSTANCE: db2inst1
HOSTNAME: XXXX
FUNCTOIN: DB2 UDB, XA DTP Support, sqlxaConnect, probe: 5329
MESSAGE : XA Interface SQLCA
DATA #1 : SQLCA, PD_DB2TYPE_SQLCA, 136 bytes
 sqlcaid : SQLCA   sqlcabc: 136 sqlcode: -1032 sqlerrml:0
 sqlerrmc:
 sqlerrp : SQLJCMN
 sqlerrd : (1) 0x81360012 (2) 0x00000012 (3) 0x00000000
           (4) 0x00000002 (5) 0x00000004 (6) 0x00000000
 sqlwarn : (1)   (2)   (3)   (4)   (5)   (6)
           (7)   (8)   (9)   (10)  (11)
 sqlstate: 00000 

Any DB2 export, how can i make it fixed ? thanks

I have verified DB2 client CONNECT command($ db2 connect to DBXX user USERxx using PASSXX), and query out data using SELECT statement. and also have following the Tuxedo guide to set DB2 configuration items. https://docs.oracle.com/cd/E26665_01/artrt/docs11gr1/cicsref/db2conn.html

Converting the comment thread to an answer.

For a new installation of Tuxedo where XA transactions are required (managed by Tuxedo as TP monitor) with one leg being Db2 for Z/OS, it is necessary to configure both Tuxedo and Db2-connect to support XA transactions, in addition to basic actions for Db2 connectivity and in addition to any Db2 licensing activities.

Note that Linux/AIX/Windows: command-line connections (from the workstation to Db2 for Z via Db2-connect) will only verify connectivity and userid/password access, but this will not test XA. Command-line connections are Type-1 connections (i.e they are not using distributed units of work).

The configuration details can be version specific so always consult the version-specific documentation for both Tuxedo and Db2-connect products.

For Tuxedo, the documentation page is https://docs.oracle.com/cd/E26665_01/artrt/docs11gr1/cicsref/db2conn.html

For Db2-Connect v9.7 (later versions are also accessible from here) the page is: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_9.7.0/com.ibm.db2.luw.qb.dbconn.doc/doc/t0006168.html

Typical configuration for Db2-connect includes:

`db2 update dbm cfg using tp_mon_name TUXEDO 

db2 update dbm cfg using spm_name bjaix  # hostname of the node running Db2-connect

db2 update dbm cfg using max_connections 500 

db2 update dbm cfg using max_coordagents 200 

// You may also want to enable the Db2-connect connection-concentrator depdending on your peak concurrency needs and the available resources

db2stop

db2start`

Additional configuration of Tuxedo is required, in part referencing some of the Db2-configuration, refer to the Oracle Tuxedo documentation for details.