IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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

  • RB10 PSN

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
03 May 2022