IBM Support

Getting SQL1042N from connecting to a database.

Troubleshooting


Problem

Getting SQL1042N from connecting to a database.

Symptom


Getting SQL1042N from connecting to a database.

db2diag.log shows:

2016-10-27-14.28.13.189000-360 I4209F443            LEVEL: Error
PID     : 10604                TID : 11320          PROC : db2bp.exe
INSTANCE: DB2                  NODE : 000
HOSTNAME: AAA
EDUID   : 11320
FUNCTION: DB2 Common, Cryptography, cryptDynamicLoadGSKitCrypto, probe:998
MESSAGE : ECF=0x90000007=-1879048185=ECF_UNKNOWN
          Unknown
DATA #1 : unsigned integer, 4 bytes
60
DATA #2 : String, 14 bytes
gsk8sys_64.dll

2016-10-27-14.28.13.190000-360 I4654F391            LEVEL: Error
PID     : 10604                TID : 11320          PROC : db2bp.exe
INSTANCE: DB2                  NODE : 000
HOSTNAME: AAA
EDUID   : 11320
FUNCTION: DB2 Common, Cryptography, cryptContextInit, probe:105
MESSAGE : ECF=0x90000007=-1879048185=ECF_UNKNOWN
          Unknown
DATA #1 : Hex integer, 4 bytes
0x90000007

2016-10-27-14.28.13.190000-360 I5047F443            LEVEL: Error
PID     : 10604                TID : 11320          PROC : db2bp.exe
INSTANCE: DB2                  NODE : 000
HOSTNAME: AAA
EDUID   : 11320
FUNCTION: DB2 Tools, DB2 administration server, dasEncryptOneTimeInit, probe:30
DATA #1 : String, 3 bytes
DB2
DATA #2 : String, 39 bytes
C:\Program Files\IBM\SQLLIB\\bin\\icc64
DATA #3 : signed integer, 4 bytes
-1879048185

Cause

The error is caused by an UNC directory name in the PATH environment variable.  When this is not reachable, Error 53 "The network path was not found." would be returns.

Diagnosing The Problem



Run gsk8ver_64.exe from the gskit and it returned "application was unable to start correctly(0xc00000be)" 0xC00000BE(STATUS_BAD_NETWORK_PATH) means "The network path cannot be located."

Resolving The Problem

Removing the unreachable UNC directory name in PATH.

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"--","Platform":[{"code":"PF033","label":"Windows"}],"Version":"9.7;10.1;10.5;11.1","Edition":"Advanced Enterprise Server;Advanced Workgroup Server;Enterprise Server;Express;Express-C;Personal;Workgroup Server","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21995329