|
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) |
