home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT07621 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 / A10 - 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.1 Fix Pack 5                       * 
****************************************************************
Local Fix:
Solution
First fixed in Version 10.1 Fix Pack 5
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
10.03.2015
21.07.2015
21.07.2015
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
10.1.0.5 FixList