IT34184: DB2 CRASHED FOR C0000005 EXCEPTION ON SQLV_CHR_2_NUM

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