DB2 - Problem description
Problem IT23909 | Status: Closed |
INTERMITTENT DB21018E ERROR RETURNED TO CLP DURING CONNECTION TOA DATABASE. | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - 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: * * Users running Db2 10.5 FP9 and multiple instances per server * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.1.4.4 * **************************************************************** | |
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 : IT23905 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 31.01.2018 29.01.2020 29.01.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |