IBM Support

IC75195: INSTANCE MAY ABEND DURING COMPILATION OF A QUERY IF AN SQL0101N IS ENCOUNTERED.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Instance may abend during compilation of a query if an SQL0101N
    is encountered.
    
    Such a scenario may be identified by an entry in db2diag.log
    that looks similar to:
    ...
    YYYY-MM-DD-HH24.MI.SS.NNNNNN+NNN xxxxxxxxxxxxxx   LEVEL: Severe
    PID     : xxxxxx               TID  : xxxxx       PROC : db2sysc
    x
    INSTANCE: xxxxxx               NODE : xxx         DB   :
    xxxxxxxx
    APPHDL  : xxxxxx               APPID: xxxxxx
    AUTHID  : xxxxxx
    EDUID   : xxxxxx               EDUNAME: db2agent (xxxxxx) xxx
    FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc,
    probe:300
    DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
     sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -101   sqlerrml: 0
     sqlerrmc:
     sqlerrp : SQLNQ155
     sqlerrd : (1) 0x8B0F000C      (2) 0x0000000C      (3)
    0x00000000
               (4) 0x00000000      (5) 0xFFFFFF74      (6)
    0x00000000
     sqlwarn : (1)      (2)      (3)      (4)        (5)       (6)
               (7)      (8)      (9)      (10)        (11)
     sqlstate:
    ...
    
    Followed by a subsequent instance abend, whose stack trace looks
    similar to:
    sqlofmblkEx
    sqlnq_describe_output
    sqlnq_describe
    sqlnn_cmpl
    sqlnn_cmpl
    ...
    

Local fix

  • Increase the value of the STMTHEAP database configuration
    parameter.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error description field for more information.            *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version 9.7 Fix Pack 5 or later.              *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in DB2 Version 9.7 Fix Pack 5.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC75195

  • 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-03-23

  • Closed date

    2011-12-07

  • Last modified date

    2011-12-07

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

    IC72824

  • 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 #: IC75195

Modified date: 07 December 2011