IBM Support

IC74405: CRASH WHEN CONNECT_PROC IS SET AND AUDIT IS ON

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • When DB CFG parameter CONNECT_PROC is set to not NULL value and
    AUDIT policy is turned on, customer may see the crash at
    database connect time with below call stack:
    0x00002AEE3328DFB8 _Z10sqlr_auditP8sqlrr_cbP14sqlexAuditDataPii
    + 0x065c
      (/home/hotel47/gstager/sqllib/lib64/libdb2e.so.1)
    0x00002AEE33290CE2
    _Z18sqlr_audit_executeP8sqlrr_cbsP19sqlrr_curr_activitymP5sqlcai
    + 0x134a
      (/home/hotel47/gstager/sqllib/lib64/libdb2e.so.1)
    0x00002AEE33236329 _Z8sqlrrcomP8sqlrr_cbii + 0x0dd9
      (/home/hotel47/gstager/sqllib/lib64/libdb2e.so.1)
    0x00002AEE33209252 _Z21sqlrr_callConnectProcP14db2UCinterfaceb +
    0x06dc
      (/home/hotel47/gstager/sqllib/lib64/libdb2e.so.1)
    0x00002AEE310AB500
    _Z32sqljsPostProcessingConnectAttachP13sqljsDrdaAsCbP14db2UCinte
    rfacei
    + 0x0362
      (/home/hotel47/gstager/sqllib/lib64/libdb2e.so.1)
    0x00002AEE310A9CE8
    _Z18sqljsConnectAttachP13sqljsDrdaAsCbP14db2UCinterface + 0x02ca
    
      (/home/hotel47/gstager/sqllib/lib64/libdb2e.so.1)
    0x00002AEE31055307
    _Z16sqljs_ddm_accsecP14db2UCinterfaceP13sqljDDMObject + 0x020f
      (/home/hotel47/gstager/sqllib/lib64/libdb2e.so.1)
    0x00002AEE3104B379
    _Z17sqljsParseConnectP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UCint
    erface
    + 0x011f
      (/home/hotel47/gstager/sqllib/lib64/libdb2e.so.1)
    0x00002AEE3104C816
    _Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb +
    0x01c2
      (/home/hotel47/gstager/sqllib/lib64/libdb2e.so.1)
    

Local fix

  • turn audit policy off or set connect_proc to NULL
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * customer who set connect_proc as non-NULL and turned on      *
    * audit policy                                                 *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * When DB CFG parameter CONNECT_PROC is set to not NULL value  *
    * and                                                          *
    * AUDIT policy is turned on, customer may see the crash at     *
    *                                                              *
    * database connect time with below call stack:                 *
    *                                                              *
    * 0x00002AEE3328DFB8                                           *
    * _Z10sqlr_auditP8sqlrr_cbP14sqlexAuditDataPii                 *
    * + 0x065c                                                     *
    *                                                              *
    *   (/home/hotel47/gstager/sqllib/lib64/libdb2e.so.1)          *
    *                                                              *
    * 0x00002AEE33290CE2                                           *
    *                                                              *
    * _Z18sqlr_audit_executeP8sqlrr_cbsP19sqlrr_curr_activitymP5sqlc
    * + 0x134a                                                     *
    *                                                              *
    *   (/home/hotel47/gstager/sqllib/lib64/libdb2e.so.1)          *
    *                                                              *
    * 0x00002AEE33236329 _Z8sqlrrcomP8sqlrr_cbii + 0x0dd9          *
    *                                                              *
    *   (/home/hotel47/gstager/sqllib/lib64/libdb2e.so.1)          *
    *                                                              *
    * 0x00002AEE33209252                                           *
    * _Z21sqlrr_callConnectProcP14db2UCinterfaceb +                *
    * 0x06dc                                                       *
    *                                                              *
    *   (/home/hotel47/gstager/sqllib/lib64/libdb2e.so.1)          *
    *                                                              *
    * 0x00002AEE310AB500                                           *
    *                                                              *
    * _Z32sqljsPostProcessingConnectAttachP13sqljsDrdaAsCbP14db2UCin
    * rfacei                                                       *
    *                                                              *
    * + 0x0362                                                     *
    *                                                              *
    *   (/home/hotel47/gstager/sqllib/lib64/libdb2e.so.1)          *
    *                                                              *
    * 0x00002AEE310A9CE8                                           *
    *                                                              *
    * _Z18sqljsConnectAttachP13sqljsDrdaAsCbP14db2UCinterface +    *
    * 0x02ca                                                       *
    *                                                              *
    *                                                              *
    *   (/home/hotel47/gstager/sqllib/lib64/libdb2e.so.1)          *
    *                                                              *
    * 0x00002AEE31055307                                           *
    *                                                              *
    * _Z16sqljs_ddm_accsecP14db2UCinterfaceP13sqljDDMObject +      *
    * 0x020f                                                       *
    *   (/home/hotel47/gstager/sqllib/lib64/libdb2e.so.1)          *
    *                                                              *
    * 0x00002AEE3104B379                                           *
    *                                                              *
    * _Z17sqljsParseConnectP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UCi
    * erface                                                       *
    *                                                              *
    * + 0x011f                                                     *
    *                                                              *
    *   (/home/hotel47/gstager/sqllib/lib64/libdb2e.so.1)          *
    *                                                              *
    * 0x00002AEE3104C816                                           *
    *                                                              *
    * _Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb + *
    *                                                              *
    * 0x01c2                                                       *
    *                                                              *
    *   (/home/hotel47/gstager/sqllib/lib64/libdb2e.so.1)          *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * turn audit policy off or set connect_proc to NULL            *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IC74405

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-02-10

  • Closed date

    2011-04-28

  • Last modified date

    2011-04-28

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

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

Fix information

Applicable component levels

  • R970 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
28 April 2011