IBM Support

Connecting to DB2 z/OS v10 with Data Studio v4.1 or InfoSphere Data Architect v9.1 results in SQL error code -4499 or -1224

Troubleshooting


Problem

The program fix (PTF) UK91146 must be applied to the DB2 z/OS v10 data server that you want to connect to with the database clients.

Symptom

If you are having connection issues when you attempt to connect to a DB2 z/OS v10 data server with the database clients, you might see the following symptoms:

The following abend occurs on the DB2 z/OS server: 0c4-00000038,loc=dsnlzllm.dsnlzinf+0974

In the database clients, the connection attempt fails and you might receive the following SQL error codes: -4499 or -1224

Cause

The database clients use the IBM Data Server Driver for JDBC and SQLJ to establish connections to DB2 z/OS data servers. The version of the IBM Data Server Driver for JDBC and SQLJ that is bundled with the Data Studio v4.1 client and InfoSphere Data Architect v9.1 requires that the program fix (PTF) UK91146 is applied to the DB2 z/OS data server.

The IBM Data Server Driver for JDBC and SQLJ is operating at a higher DRDA level, so when the database clients attempt to connect to the DB2 for z/OS data server, an internal processing error occurs in the DB2 10 for z/OS data server. For example, SQLAM 11 or higher will cause connection errors with DB2 10 for z/OS data servers unless PTF UK91146 is applied on the data server.

For details about this connection error, see Hiper APAR 79161 at http://www-01.ibm.com/support/docview.wss?uid=swg1PM79161.

Resolving The Problem

To resolve the connection error:

  1. Verify that the following abend was issued on the DB2 z/OS v10 data server: 0c4-00000038,loc=dsnlzllm.dsnlzinf+0974
  2. Apply PTF UK91146 to the DB2 z/OS v10 data server.

Related Information

[{"Product":{"code":"SS62YD","label":"IBM Data Studio"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"General","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"4.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SS9UM9","label":"IBM InfoSphere Data Architect"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Not Applicable","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"9.1","Edition":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21641377