IBM Support

IT37964: SEGV AT SQLV_MIXD_BUILD_LIKE_SUBPAT()

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Db2 instance trap at sqlv_mixd_build_like_subpat(). The
    following is the stack trace of the EDU trapped:
    
    <StackTrace>
    -------Frame------ ------Function + Offset------
    0x0900000009FDFD8C
    IPRA.$sqlv_mixd_build_like_subpat__FP8sqlrr_cbiPUcT2P12sqlv_patt
    ernP15sqlv_subpatternPiPlN28 + 0xB4C
    0x0900000009FE1774
    sqlv_mixd_lob_search__FP8sqlrr_cbP9sqlv_textP10sqlz_valueP12sqlv
    _patternPl + 0xAF4
    0x0900000006C521D8
    sqlri_like_long_body__FP8sqlrr_cbP10sqlz_valueN22Pi + 0x458
    0x0900000006C51CC8 sqlri_like_long__FP8sqlrr_cb + 0x448
    0x0900000008426698 sqlrita__FP8sqlrr_cb + 0x798
    0x0900000007069238 sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm +
    0x618
    0x0900000008C3AD08 sqlrr_smp_router__FP8sqlrr_cb + 0x188
    0x0900000008C371C8
    sqlrr_subagent_router__FP8sqeAgentP12SQLE_DB2RA_T + 0xFC8
    0x0900000008C228A4 IPRA.$sqleSubRequestRouter__FP8sqeAgentPUiPUl
    + 0x7C4
    0x0900000008C1C938 sqleProcessSubRequest__FP8sqeAgent + 0x2C38
    0x090000000411282C RunEDU__8sqeAgentFv + 0x9EC
    0x09000000040ECBC0 EDUDriver__9sqzEDUObjFv + 0x300
    0x0900000003FCE200 sqloEDUEntry + 0x360
    </StackTrace>
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * all                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to 11.1.4.7                                          *
    ****************************************************************
    

Problem conclusion

  • Upgrade to 11.1.4.7
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT37964

  • 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

    2021-08-10

  • Closed date

    2022-04-17

  • Last modified date

    2022-04-17

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

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

    IT38087

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