IBM Support

IT34184: DB2 CRASHED FOR C0000005 EXCEPTION ON SQLV_CHR_2_NUM

Subscribe

You can track all active APARs for this component.

 

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: DB2INST1             NODE : 000           DB   :
    MYDB1
    APPHDL  : 0-16895              APPID: X.X.X.X.0000.200101070000
    UOWID   : 78                   ACTID: 1
    AUTHID  : USER1                 HOSTNAME: myhost1
    EDUID   : 8692                 EDUNAME: db2agent (MYDB1) 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 schema1.ta
    0x0000001CE5263C50 : 7267 5F6C 6175 6665 6E64 2075 7620 7365
    b1 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 tab2.gue
    0x0000001CE5263C90 : 6C5F 6162 2C20 646F 7562 6C65 2820 7376
    l_ab, double( tab
    0x0000001CE5263CA0 : 312E 7765 7274 2029 2066 726F 6D20 7365
    2.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

    2022-03-30

  • 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:
04 May 2022