IBM Support

IT35256: DB2 TERMINATES ABNORMALLY COMPILING A QUERY.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When database configuration parameter STRING_UNITS is set to
    CODEUNITS32.
    Db2 may terminate abnormally with the following stack:
    
    <StackTrace>
    -------Frame------ ------Function + Offset------
    0x09000001525D9478 sqlofmblkEx + 0x98
    0x0900000156B0C5C0
    sqlnq_encap_doit__FiP9sqlnq_pidPP9sqlnq_pidP12sqlnq_stringPUcP3l
    ocC16SqlnqEncapPolicy + 0x680
    0x09000001546C6A38
    sqlnq_fun_res_walk__FP9sqlnq_pidP12sqlnq_stringPUcPP9sqlnq_pidP3
    lociT6 + 0x1338
    0x09000001546C5618
    sqlnq_fun_tres__FP9sqlnq_pidP12sqlnq_stringPUcPP9sqlnq_pidP3loci
    T6 + 0x198
    0x0900000156A92068
    sqlnq_sem_function_call__FPP8stknode_i10actiontypePUcP3loc +
    0x1A28
    0x09000001575B9064 sqlnp_smactn__FP8sqlnp_cbi + 0x424
    0x09000001575B1640 sqlnp_parser__FP8sqlnp_cb + 0xAC0
    0x0900000157586268
    sqlnp_main__FP12sqlnq_stringbP3locPP9sqlnq_qur + 0xDA8
    0x090000015750A334
    sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq
    lrr_cmpl_enviT7PP9sqlnq_qur + 0x8194
    0x0900000157502128
    sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq
    lrr_cmpl_env + 0x28
    0x090000015483255C
    sqlra_compile_var__FP8sqlrr_cbP14sqlra_cmpl_envPUciUsN54P14SQLP_
    LOCK_INFOP16sqlra_cached_varPiT11_Pb + 0xBDC
    0x09000001537684FC
    sqlra_find_var__FP8sqlrr_cbP17sqlra_cached_stmt13sqlra_stmt_idUi
    T4PUcT4UsUcP14sqlra_cmpl_env15sqlra_fill_modePiiT12_N313_T12_P14
    SQLP_LOCK_INFOPP16sqlra_cached_varT12_bT
    0x0900000154824B94 sqlra_get_var__FP8sqlrr_cbiT2bPbT5 + 0xBF4
    0x0900000153F8429C
    sqlrr_prepare__FP14db2UCinterfaceP16db2UCprepareInfo + 0x57C
    0x09000001593803B0
    sqljs_ddm_prpsqlstt__FP14db2UCinterfaceP13sqljDDMObject + 0x12B0
    0x090000015930AB90
    sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
    interface + 0x2B0
    0x090000015930DBD0
    sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb +
    0x2250
    0x09000001592DA04C
    IPRA.$sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0xEAC
    0x09000001592E2B14
    sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xB4
    0x09000001592D80F0
    IPRA.$sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x13F0
    0x09000001592D5534 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T +
    0x334
    0x09000001526E0CA0 RunEDU__8sqeAgentFv + 0xB60
    0x09000001526C37A0 EDUDriver__9sqzEDUObjFv + 0x2E0
    0x09000001525B3714 sqloEDUEntry + 0x374
    </StackTrace>
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to the latest fix pack.                              *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in DB2 UDB Version 11.1 fix pack 6
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT35256

  • 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-12-11

  • Closed date

    2021-03-19

  • Last modified date

    2021-03-19

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

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

    IT35257

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