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