IBM Support

SQLCODE: -5042 returned when connecting to DB2 on Z/OS from Websphere Application Server using Type 4 JDBC XA driver.

Troubleshooting


Problem

Connection from Websphere Application Server to DB2 on Z/OS using Type 4 JDBC XA driver fails with exception: java.sql.SQLException: DB2 SQL error: SQLCODE: -5042.

Symptom

   Exception received:
          java.sql.SQLException: DB2 SQL error: SQLCODE: -5042, SQLSTATE: ,
          SQLERRMC: ;1208;FCCAPP ;CQDB;QDB2; ; ; ;1208; ;DSRA0010E: SQL State = ,
          Error Code = -5,042. View JVM logs for further details.
                                                                                                                                                

Cause

Usually this issue is caused by SPM_NAME (SyncPointManager Name) not set in dbm cfg (Database Manager Configuration) of the DB2 Connect instance.                                                                                                                                              

Resolving The Problem

Update the SPM_NAME in dbm cfg to the hostname of DB2 connect server.

  1. db2 update dbm cfg using SPM_NAME <hostname of DB2 connect server>
  2. db2stop
  3. db2start
                                                                                                                                                

Related Information

SPM_NAME

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"OTHER - Uncategorised","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.7;9.5;9.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
23 June 2018

UID

swg21405243

Page Feedback