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 |