IBM Support

IT31751: DB2 server may failed during query compilation with DECODE FUNCTION

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

  • when using decode in a query, an error could happen with
    the following stack
    
    <StackTrace>
    -----FUNC-ADDR---- ------FUNCTION + OFFSET------
    0x00007F7CAD6867A6
    _Z25ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm +
    0x0356
    0x00007F7CAD6863EB ossDumpStackTraceV98 + 0x002b
    0x00007F7CAD682597 _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm +
    0x00d7
    0x00007F7CB4858807 sqlo_trce + 0x03c7
    0x00007F7CB49BF30B sqloDumpDiagInfoHandler + 0x020b
    0x00007F7CBC22F630 address: 0x00007F7CBC22F630 ; dladdress:
    0x00007F7CBC220000 ; offset in lib: 0x000000000000F630 ;
    0x00007F7CAC69915A semtimedop + 0x000a
    0x00007F7CB4866DEF sqloWaitEDUWaitPost + 0x03bf
    0x00007F7CB329DBBB _ZN11sqkfChannel13WaitRecvReadyEii + 0x075b
    0x00007F7CB329D346
    _ZN11sqkfChannel16ReceiveAnyBufferEPP10sqkfBufferiPi + 0x0496
    0x00007F7CB32E32E3
    _Z8sqlkqrcvP8SQLKQ_CBP8sqeAgentPiPP10sqkfBufferS3_PN7ibm_cde5que
    ry16RuntimeStatEntryES3_Pb + 0x1403
    0x00007F7CB32FEE64 _Z8sqlktrcvP9sqlri_taoPi + 0x00e4
    0x00007F7CB3302CBC
    _Z18sqlkt_unpack_tupleP9sqlri_taoPiPbP5sqlcaPjPmP8sqeAgentP31sql
    kq_prof_tq_recv_events_timesPh + 0x225c
    0x00007F7CB32F7AA2 _Z8sqlktftcP8sqeAgentP9sqlri_taoP5sqlcaPjPm +
    0x0542
    0x00007F7CB56DA81B _Z8sqlritqaP8sqlrr_cb + 0x083b
    0x00007F7CB56DA503 _Z8sqlritqaP8sqlrr_cb + 0x0523
    0x00007F7CB55E6267 _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm
    + 0x04b7
    0x00007F7CB4FEAF53
    _Z27sqlrr_process_fetch_requestP14db2UCinterface + 0x0673
    0x00007F7CB4FECA06
    _Z10sqlrr_openP14db2UCinterfaceP15db2UCCursorInfo + 0x0eb6
    0x00007F7CB31CAF61
    _Z16sqljs_ddm_opnqryP14db2UCinterfaceP13sqljDDMObject + 0x0431
    0x00007F7CB31B549B
    _Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U
    Cinterface + 0x00fb
    0x00007F7CB31B656E
    _Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb +
    0x054e
    
    
    or
    
    <StackTrace>
    -----FUNC-ADDR---- ------FUNCTION + OFFSET------
    0x00007F7CAD6867A6
    _Z25ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm +
    0x0356
    0x00007F7CAD6863EB ossDumpStackTraceV98 + 0x002b
    0x00007F7CAD682597 _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm +
    0x00d7
    0x00007F7CB4858807 sqlo_trce + 0x03c7
    0x00007F7CB49BF8C1 sqloEDUCodeTrapHandler + 0x03b1
    0x00007F7CBC22F630 address: 0x00007F7CBC22F630 ; dladdress:
    0x00007F7CBC220000 ; offset in lib: 0x000000000000F630 ;
    0x00007F7CB56C22C7 _Z8sqlrisrtP8sqlrr_cb + 0x0047
    0x00007F7CB5658425 _Z8sqlrievlP8sqlrr_cb + 0x05d5
    0x00007F7CB55E6267 _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm
    + 0x04b7
    0x00007F7CB5023419
    _Z21sqlrr_subagent_routerP8sqeAgentP12SQLE_DB2RA_T + 0x0de9
    0x00007F7CB2BB76DF address: 0x00007F7CB2BB76DF ; dladdress:
    0x00007F7CADBD8000 ; offset in lib: 0x0000000004FDF6DF ;
    0x00007F7CB2BB5FB0 _Z21sqleProcessSubRequestP8sqeAgent + 0x03e0
    0x00007F7CB2BEA537 _ZN8sqeAgent6RunEDUEv + 0x05d7
    0x00007F7CB64043E6 _ZN9sqzEDUObj9EDUDriverEv + 0x0116
    0x00007F7CB49BC808 sqloEDUEntry + 0x0578
    0x00007F7CBC227EA5 address: 0x00007F7CBC227EA5 ; dladdress:
    0x00007F7CBC220000 ; offset in lib: 0x0000000000007EA5 ;
    0x00007F7CAC6978CD clone + 0x006d
    

Local fix

  • Use'Case' function in place of 'decode'
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply v11.1 Mod 4 Fixpack 6 to DB2 server                    *
    ****************************************************************
    

Problem conclusion

  • First fixed in v11.1 Mod 4 Fixpack 6
    

Temporary fix

  • See LOCAL FIX
    

Comments

APAR Information

  • APAR number

    IT31751

  • 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

    2020-02-04

  • Closed date

    2021-03-29

  • Last modified date

    2021-03-29

  • 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

[{"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:
31 March 2021