DB2 - Problem description
| Problem IT07688 | Status: Closed |
WHEN HIT SQL5005 DUE TO FILE OPEN FAILURE, PREVIOUS DBM CFG VERSION WAS NOT RESTORED AND OUTPUT IN DB2DIAG.LOG | |
| product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
| Problem description: | |
When DB2 attempts to update dbm cfg version to current level, if
it fails to open database manager configuration file, the
previous dbm cfg version was output in db2diag.log, it
mistakenly output current level.
The value of ptr->dbm_cfg_version shown in below db2daig.log is
not previous dbm cfg version, but current level (v10.1 in
following example). DB2 should restore and output previous value
instead:
2015-01-20-07.01.00.526124+000 I110470A402 LEVEL: Error
PID : 29819206 TID : 1 PROC :
db2gcf
INSTANCE: db2edwp1 NODE : 089
HOSTNAME: sa73edwdsp12
EDUID : 1
FUNCTION: DB2 UDB, config/install, sqlf_fix_dbm_cfg, probe:2804
MESSAGE : SQL5005: sqloopen rc =
DATA #1 : Hexdump, 4 bytes
0x0FFFFFFFFFFF6584 : 870F 0016
....
2015-01-20-07.01.00.527647+000 I110873A492 LEVEL: Error
PID : 29819206 TID : 1 PROC :
db2gcf
INSTANCE: db2edwp1 NODE : 089
HOSTNAME: sa73edwdsp12
EDUID : 1
FUNCTION: DB2 UDB, config/install, sqlfGetDbmCfg, probe:110
RETCODE : ZRC=0xFFFFEC73=-5005
SQL5005C The operation failed because the database
manager failed to
access either the database manager configuration file
or the database
configuration file.
...........
2015-01-20-07.01.00.539434+000 I112618A424 LEVEL: Error
PID : 29819206 TID : 1 PROC :
db2gcf
INSTANCE: db2edwp1 NODE : 089
HOSTNAME: sa73edwdsp12
EDUID : 1
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary
logging function), probe:50
MESSAGE : ptr->dbm_cfg_version
DATA #1 : Hexdump, 2 bytes
0x0FFFFFFFFFFF6BA4 : 2774
't | |
| Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 10.5 Fix Pack 7 * **************************************************************** | |
| Local Fix: | |
| Solution | |
First fixed in Version 10.5 Fix Pack 7 | |
| Workaround | |
not known / see Local fix | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 13.03.2015 20.01.2016 20.01.2016 |
| Problem solved at the following versions (IBM BugInfos) | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 10.5.0.7 |
|