IBM Support

IT25552: UPDATING THE AUDIT DATA PATH OR THE INSTANCE DIAGPATH MAY FAIL IN AN AUTOMATED HADR ENVIRONMENT

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

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

Local fix

  • 1) Disable automation via "db2haicu -disable"
    2) Update the DIAGPATH or audit data path
    3) Re-enable automation via db2haicu
    

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.      *
    ****************************************************************
    

Problem conclusion

  • Problem first fixed in DB2 version 11.1 Mod 4 Fix Pack 4.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT25552

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-07-02

  • Closed date

    2018-12-09

  • Last modified date

    2018-12-09

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RB10 PSN

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
09 December 2018