IBM Support

IT35256: DB2 TERMINATES ABNORMALLY COMPILING A QUERY.

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 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

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