DB2 - Problem description
Problem IT25552 | Status: Closed |
UPDATING THE AUDIT DATA PATH OR THE INSTANCE DIAGPATH MAY FAIL IN AN AUTOMATED HADR ENVIRONMENT | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
In a TSA automated HADR environment, a segmentation fault (SEGV) or SQL code SQL1042C can occur when updating either the audit data path or the DIAGPATH database manager configuration parameter. If this issue is encountered, the two commands will fail as follows: 1. Audit data path update: $ db2audit configure datapath "/hafs01/db2inst1/NODE0000" Segmentation Fault 2. DIAGPATH dbm cfg update: $ db2 "update dbm cfg using DIAGPATH /db2diag/db2inst1/" SQL1042C An unexpected system error occurred. SQLSTATE=58004 As a result of these failures, the following similar stacks should be seen: 1. Audit data path update: #0 0x00007f8a1815da75 in __strcasecmp_l_avx () from /lib64/libc.so.6 #1 0x00007f8a19c9c8d5 in sqlhaCreateMount(char const*, char const*, unsigned long) () from /ecurep/sf/TS001/056/TS001056855/2018-06-25/db2auditlibs.v2.tar_ unpack/audit/libdb2.so.1 #2 0x000000000040d0ef in sqlexAuditCreateMount(char const*, short, char*) () #3 0x000000000040cf5e in sqlexAuditChangeHAMount(char*, char*) () #4 0x000000000040b446 in sqlex_db2audit_update_cfg(int, sqlexAuditCategories*, char*, char*, char*, sqlca*, SQLEX_AUTHINFO_T*) () #5 0x0000000000404b07 in sqlex_db2audit_parse_command(int, char**, sqlca*, SQLEX_AUTHINFO_T*) () #6 0x0000000000403741 in main () 2. DIAGPATH dbm cfg update: 0x00007F220C5E3F17 sqlo_trce + 0x03c7 (/db2home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00007F220C748E19 sqloEDUCodeTrapHandler + 0x03a9 (/db2home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00000037A380F7E0 address: 0x00000037A380F7E0 ; dladdress: 0x00000037A3800000 ; offset in lib: 0x000000000000F7E0 ; (/lib64/libpthread.so.0) 0x00000037A352B769 address: 0x00000037A352B769 ; dladdress: 0x00000037A3400000 ; offset in lib: 0x000000000012B769 ; (/lib64/libc.so.6) 0x00007F2206FB15E5 _Z16sqlhaCreateMountPKcS0_m + 0x0855 (/db2home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00007F220AE33464 sqlfHaParamHandler + 0x0f44 (/db2home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00007F220AE1C688 _Z20sqlf_update_db2systmP6db2CfgP5sqlcaij + 0x0668 (/db2home/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00007F220AE1BB79 _Z16sqlfUpdateDbmCfgP6db2CfgP5sqlcacij + 0x0139 (/db2home/db2inst1/sqllib/lib64/libdb2e.so.1) | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * TSA enabled * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 version 11.1 Mod 4 Fix Pack 4 or higher. * **************************************************************** | |
Local Fix: | |
1) Disable automation via "db2haicu -disable" 2) Update the DIAGPATH or audit data path 3) Re-enable automation via db2haicu | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 02.07.2018 09.12.2018 09.12.2018 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |