Fixes are available
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