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) |
