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:
- Verify that the following abend was issued on the DB2 z/OS v10 data server:
0c4-00000038,loc=dsnlzllm.dsnlzinf+0974
- Apply PTF UK91146 to the DB2 z/OS v10 data server.
Related Information
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21641377