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 IT01985 Status: Closed

HADR PRIMARY OR STANDBY MIGHT TERMINATE ABNORMALLY WHEN DB2 AUDIT IS ACTIVE

product:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problem description:
HADR Primary or Standby might terminate abnormally if 
DB2 Audit is active. 
 
 
Following entries can be found in db2diag.log: 
 
2014-03-20-07.52.08.777994-240 I8983E541             LEVEL: 
Error 
PID     : 7697                 TID : 140264240834304 PROC : 
db2sysc 0 
INSTANCE: db2inst1             NODE : 000            DB   : 
HADRDB 
APPHDL  : 0-79                 APPID: 
*LOCAL.db2inst1.140320115207 
AUTHID  : DB2INST1             HOSTNAME: inst2 
EDUID   : 202                  EDUNAME: db2agent (HADRDB) 0 
FUNCTION: DB2 UDB, High Availability Disaster Recovery, 
hdrResolveHostNameAndPort, probe:1540 
MESSAGE : ZRC=0x810F0032=-2129723342=SQLO_HOST_UNKNOWN "Host 
unknown" 
 
... 
 
2014-03-20-07.52.09.231352-240 I11989E510            LEVEL: 
Severe 
PID     : 7697                 TID : 140264291165952 PROC : 
db2sysc 0 
INSTANCE: db2inst1             NODE : 000            DB   : 
HADRDB 
HOSTNAME: inst2 
EDUID   : 226                  EDUNAME: db2hadrs.0.0 (HADRDB) 0 
FUNCTION: DB2 UDB, RAS/PD component, 
pdResilienceIsSafeToSustain, probe:800 
DATA #1 : String, 37 bytes 
Trap Sustainability Criteria Checking 
DATA #2 : Hex integer, 8 bytes 
0x200000000000884C 
DATA #3 : Boolean, 1 bytes 
false 
 
... 
 
2014-03-20-07.52.22.171887-240 I26795E1517           LEVEL: 
Event 
PID     : 7697                 TID : 140264291165952 PROC : 
db2sysc 0 
INSTANCE: db2inst1             NODE : 000            DB   : 
HADRDB 
HOSTNAME: inst2 
EDUID   : 226                  EDUNAME: db2hadrs.0.0 (HADRDB) 0 
FUNCTION: DB2 UDB, oper system services, 
sqloPGRPRegisterOneCrash, probe:2158 
MESSAGE : lastCrashCount 
DATA #1 : unsigned integer, 8 bytes 
0 
DATA #2 : String, 10 bytes 
inRecovery 
DATA #3 : Boolean, 1 bytes 
false 
CALLSTCK: (Static functions may not be resolved correctly, as 
they are resolved to the nearest symbol) 
  [0] 0x00007F91EA28C7EC sqloPGRPRegisterOneCrash + 0x17C 
  [1] 0x00007F91EA2DD38A sqloEDUCodeTrapHandler + 0x9EA 
  [2] 0x00007F91EF9FD5D0 /lib64/libpthread.so.0 + 0xF5D0 
  [3] 0x00007F91E970B71F 
_ZN14sqlexAuditData26setUnspecifiedFieldsServerEP5sqlca + 0x3F 
  [4] 0x00007F91E97068B0 _ZN14sqlexAuditData8logEventEP5sqlca + 
0x690 
  [5] 0x00007F91E733AA59 
_Z15sqlfUpdateDbCfgP16sqeLocalDatabaseP6db2CfgjiiP5sqlcas + 
0x32F9 
  [6] 0x00007F91E9729DFA 
_Z28sqlf_set_automatic_parameteriiPcP16sqeLocalDatabasebP5sqlca 
+ 0xCA 
  [7] 0x00007F91EA38D69D 
_Z24sqlpUpdateHadrSpoolLimitP16sqeLocalDatabasej + 0xDD 
  [8] 0x00007F91E88229DF _Z13hdrDbcbCreateP6hdrEdu + 0x8DF 
  [9] 0x00007F91E883DAF7 _ZN6hdrEdu10RunEDUInitEv + 0x57 
  [10] 0x00007F91E867BC84 _ZN9sqzEDUObj9EDUDriverEv + 0xD4 
  [11] 0x00007F91E7ECF617 sqloEDUEntry + 0x2F7 
  [12] 0x00007F91EF9F55F0 /lib64/libpthread.so.0 + 0x75F0 
  [13] 0x00007F91E21A784D clone + 0x6D 
 
Trap file has the following stack: 
_ZN14sqlexAuditData26setUnspecifiedFieldsServerEP5sqlca + 0x003f 
_ZN14sqlexAuditData8logEventEP5sqlca + 0x0690 
_Z15sqlfUpdateDbCfgP16sqeLocalDatabaseP6db2CfgjiiP5sqlcas + 
0x32f9 
_Z28sqlf_set_automatic_parameteriiPcP16sqeLocalDatabasebP5sqlca 
+ 0x00ca 
_Z24sqlpUpdateHadrSpoolLimitP16sqeLocalDatabasej + 0x00dd 
_Z13hdrDbcbCreateP6hdrEdu + 0x08df 
_ZN6hdrEdu10RunEDUInitEv + 0x0057 
_ZN9sqzEDUObj9EDUDriverEv + 0x00d4 
sqloEDUEntry + 0x02f7
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All users                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to DB2 10.5  Fix Pack 5                               * 
****************************************************************
Local Fix:
Turn off DB2 Audit
Solution
Problem was first fixed in DB2 10.5  Fix Pack 5
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
23.05.2014
13.03.2015
13.03.2015
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
10.5.0.5 FixList