IBM Support

IC77846: SEG-V DURING CREATION SQL PROCEDURE IF CREATED FROM A NON-CATALOG PARTITION AND WITH AUDIT CHECKING EVENTS ENABLED

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • In a DPF instance, the creation of an SQL procedure from a
    partition that is not the catalog partition can result in a
    segmentation fault if
    the db2audit facility is active and 'checking events' are
    enabled.
    
    A representative stack would include:
    
    setAuthid
    sqlr_audit
    sqlr_audit_checking
    sqlrlCheckSchemaPriv
    sqlrlgsa
    sqlrl_rpc_cat_router
    sqlrr_rpc_router
    

Local fix

  • avoid this by creating sql procedures from a connection at the
    catalog partition or disable db2audit checking events
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Partitioned Database environment                             *
    * Audit Checking enabled                                       *
    * creation of SQL procedures from non-catalog partition        *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Seg-v during creation of SQL procedure                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Move to DB2 for LUW version 9.7, fixpack 5                   *
    ****************************************************************
    

Problem conclusion

  • Fixed in DB2 for LUW version 9.7, fixpack 5
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC77846

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-07-29

  • Closed date

    2012-01-19

  • Last modified date

    2012-01-19

  • 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

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC77846

Modified date: 19 January 2012