DB2 - Problem description
Problem IT34184 | Status: Closed |
DB2 CRASHED FOR C0000005 EXCEPTION ON SQLV_CHR_2_NUM | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem 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: Exception C0000005 Occurred Exception Address = 00007FFEBC570F6E Other Unknown access fault ------RBP--------------RIP--------------ARGS-------------------- ------------------------------------- 0000001C0495B740 00007FFEBC570F6E ..... offset: 000000000000056E in 0000001C0495B7C0 00007FFE7B51F7BD ..... offset: 000000000000009D in 0000001C0495BF80 00007FFE78902EC3 ..... offset: 0000000000001523 in 0000001C0495C3E0 00007FFE7C152171 ..... offset: 0000000000000F61 in 0000001C0495C4E0 00007FFE7C15040C ..... offset: 00000000000002EC in 0000001C0495C690 00007FFE7C0B84C0 ..... offset: 0000000000002120 in | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.1 mod4 FP6 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.1 mod4 FP6 * **************************************************************** | |
Comment | |
Upgrade to Db2 11.1 mod4 FP6 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 11.09.2020 18.02.2021 18.02.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |