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

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

product:
DB2 FOR LUW / DB2FORLUW / A10 - 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                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to v10.1 FP5                                         * 
****************************************************************
Local Fix:
Turn off DB2 Audit
Solution
Fixed in DB2 v10.1 FP5
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
23.07.2014
15.07.2015
15.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