DB2 - Problem description
Problem IT23905 | Status: Closed |
INTERMITTENT DB21018E ERROR RETURNED TO CLP DURING CONNECTION TOA DATABASE. | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
You man encounter intermittent DB21018E error returned to CLP during connection to a database. The issue was first encountered in 10.5 FP9 due to recent code changes. The issue is prevalent on servers with multiple Db2 instances created. The following message may be observed in the db2diag.log file :     2017-11-29-15.10.05.276023-300 E19736E431      LEVEL: Error (OS)     PID   : 23300               TID : 139913161488256 PROC : db2     INSTANCE: db2inst            NODE : 000     HOSTNAME: hostname     FUNCTION: DB2 UDB, oper system services, sqloOpenMLNQue, probe:4     MESSAGE : ZRC=0x870F00BB=-2029059909=SQLO_QUE_NO_ACCESS          "do not have the access right"     CALLED  : OS, -, open               OSERR: EACCES (13) | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Linux servers with multiple Db2 instances present. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 V10.5 version Fix Pack 10 * **************************************************************** | |
Local Fix: | |
You may be able to work around the issue by shutting down all Db2 instances (db2stop) except one. | |
Solution | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : follow-up : IT23909 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 31.01.2018 11.07.2018 11.07.2018 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |