IBM Support

IT30558: DB2 MAY ABEND WHILE COMPILING COMPOUND SQL (COMPILED) STATEMENTS

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • Db2 may terminate abnormally while compiling compound SQL
    (compiled) statements. This includes anonymous blocks and SQL
    routines.
    
    An example stack trace seen in this scenario looks similar to
    the following:
    
    ------FUNCTION------
    ossDumpStackTraceInternal
    ossDumpStackTraceV98
    OSSTrapFile::dumpEx
    sqlo_trce
    sqloEDUCodeTrapHandler
    psm_SQL_EXPRESSION_node::~psm_SQL_EXPRESSION_node
    psmProgram::deleteParseTree
    psm_ctrl::psm_cleanup
    sqlnq_psm_sem_act
    sqlnp_smactn
    sqlnp_parser
    sqlnp_main
    sqlnn_cmpl
    sqlnn_cmpl
    sqlra_compile_var
    sqlra_find_var
    sqlra_get_var
    sqlrr_prepare
    sqljs_ddm_prpsqlstt
    sqljsParseRdbAccessed
    sqljsParse
    sqljsSqlam
    sqljsDriveRequests
    sqljsDrdaAsInnerDriver
    sqljsDrdaAsDriver
    sqeAgent::RunEDU
    sqzEDUObj::EDUDriver
    sqloEDUEntry
    pthread_timedjoin_np
    clone
    

Local fix

  • The problem may be avoided increasing the statement heap size
    limit (via database configuration parameter STMTHEAP) or
    altering statement heap to be AUTOMATIC (the default).
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * The user is running compound SQL(compiled) statements.       *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 for LUW V11.1 Mod4 Fixpack6 or later.         *
    ****************************************************************
    

Problem conclusion

  • This problem is firstly fixed on V11.1 Mod4 Fixpack6.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT30558

  • 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

    2019-10-09

  • Closed date

    2021-03-21

  • Last modified date

    2021-03-21

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

    IT30557

  • 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

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

Document Information

Modified date:
22 March 2021