IBM Support

IT34184: DB2 CRASHED FOR C0000005 EXCEPTION ON SQLV_CHR_2_NUM

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

  • db2 crashed during update execution :
    
    ```
    2020-08-26-20.30.35.792000+120 I4486861F7965        LEVEL:
    Severe
    PID     : 11104                TID : 8692           PROC :
    db2syscs.exe
    INSTANCE: DB2                  NODE : 000           DB   :
    PRODDAT
    APPHDL  : 0-16895              APPID: XXXXXXXXXXXXXXXXXXX
    UOWID   : 78                   ACTID: 1
    AUTHID  : PDFS                 HOSTNAME: XXXXXXXX
    EDUID   : 8692                 EDUNAME: db2agent (PRODDAT) 0
    FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary
    logging function), probe:50
    MESSAGE : RDS UCINTFC: pStatementText =
    DATA #1 : Hexdump, 1426 bytes
    0x0000001CE5263C40 : 7570 6461 7465 2075 6562 7A75 6B2E 766F
    update uebzuk.vo
    0x0000001CE5263C50 : 7267 5F6C 6175 6665 6E64 2075 7620 7365
    rg_laufend uv se
    0x0000001CE5263C60 : 7420 2820 6775 656C 5F61 622C 2073 6174
    t ( guel_ab, sat
    0x0000001CE5263C70 : 7A31 2029 203D 2028 2073 656C 6563 7420
    z1 ) = ( select
    0x0000001CE5263C80 : 6469 7374 696E 6374 2073 7631 2E67 7565
    distinct sv1.gue
    0x0000001CE5263C90 : 6C5F 6162 2C20 646F 7562 6C65 2820 7376
    l_ab, double( sv
    0x0000001CE5263CA0 : 312E 7765 7274 2029 2066 726F 6D20 7365
    1.wert ) from se
    0x0000001CE5263CB0 : 7373 696F 6E2E 766F 7267 6162 656E 2073
    ssion.vorgaben s
    
    From the formatted trap file here:
    <SignalDetails>
    Exception C0000005 Occurred
    Exception Address = 00007FFEBC570F6E
    Other Unknown access fault
    </SignalDetails>
    
    ------RBP--------------RIP--------------ARGS--------------------
    -------------------------------------
    0000001C0495B740 00007FFEBC570F6E ..... offset: 000000000000056E
    in <sqlv_chr_2_num> <S:\..\sqv\sqlvcnv2.C:1562>
    0000001C0495B7C0 00007FFE7B51F7BD ..... offset: 000000000000009D
    in <sqlric2n> <S:\..\sqri\sqlri_misc_sclr.C:1513>
    0000001C0495BF80 00007FFE78902EC3 ..... offset: 0000000000001523
    in <sqldDataFetch> <S:\..\include\sqlriManageSections.h:1348>
    0000001C0495C3E0 00007FFE7C152171 ..... offset: 0000000000000F61
    in <sqliScanLeaf2> <S:\..\sqx\sqlischf.C:1124>
    0000001C0495C4E0 00007FFE7C15040C ..... offset: 00000000000002EC
    in <sqlifnxt> <S:\..\sqx\sqlischf.C:17365>
    0000001C0495C690 00007FFE7C0B84C0 ..... offset: 0000000000002120
    in <sqlirdk> <S:\..\sqx\sqlirdk.C:2314>
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1 mod4 FP6                                 *
    ****************************************************************
    

Problem conclusion

  • Upgrade to Db2 11.1 mod4 FP6
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT34184

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

  • Closed date

    2021-02-18

  • Last modified date

    2021-02-18

  • 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:
27 February 2021