DB2 - Problem description
Problem IT18118 | Status: Closed |
INSTANCE CAN TRAP IN SQLDVALFROMFIXEDCOMMON WHEN SELECT A NULL CLOB | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
Instance can trap in sqldValFromFixedCommon when select a NULL CLOB. The database/table must also have been created under v6 and upgrade through to v11.1 db2diag.log: 2016-09-20-18.28.33.284000-180 I146603093F535 LEVEL: Warning PID : 2168 TID : 5104 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 DB : BDPROD APPHDL : 0-10645 APPID: *LOCAL.DB2.160920223039 AUTHID : DB2DBA HOSTNAME: DB2PMW01 EDUID : 5104 EDUNAME: db2agent (BDPROD) 0 FUNCTION: DB2 UDB, RAS/PD component, pdEDUIsInDB2KernelOperation, probe:600 DATA #1 : String, 12 bytes sqldReadNorm DATA #2 : String, 4 bytes sqld 2016-09-20-18.28.33.299000-180 I146603630F613 LEVEL: Severe PID : 2168 TID : 5104 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 DB : BDPROD APPHDL : 0-10645 APPID: *LOCAL.DB2.160920223039 AUTHID : DB2DBA HOSTNAME: DB2PMW01 EDUID : 5104 EDUNAME: db2agent (BDPROD) 0 FUNCTION: DB2 UDB, RAS/PD component, pdResilienceIsSafeToSustain, probe:800 DATA #1 : String, 37 bytes Trap Sustainability Criteria Checking DATA #2 : Hex integer, 8 bytes 0x0000000400021840 DATA #3 : Boolean, 1 bytes false ... 2016-09-20-18.28.52.053000-180 I146613258F621 LEVEL: Error PID : 2168 TID : 5104 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 DB : BDPROD APPHDL : 0-10645 APPID: *LOCAL.DB2.160920223039 AUTHID : DB2DBA HOSTNAME: DB2PMW01 EDUID : 5104 EDUNAME: db2agent (BDPROD) 0 FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:10 MESSAGE : Error in agent servicing application with APPLICATION NAME: DATA #1 : Hexdump, 7 bytes 0x0000006A0174876A : 4442 3248 4D4F 4E DB2HMON 2016-09-20-18.28.52.146000-180 I146613881F537 LEVEL: Severe PID : 2168 TID : 5104 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 DB : BDPROD APPHDL : 0-10645 APPID: *LOCAL.DB2.160920223039 AUTHID : DB2DBA HOSTNAME: DB2PMW01 EDUID : 5104 EDUNAME: db2agent (BDPROD) 0 FUNCTION: DB2 UDB, DRDA Application Server, sqljsSignalHandler, probe:10 MESSAGE : DIA0505I Execution of a component signal handling function has begun. 2016-09-20-18.28.52.178000-180 I146614420F232 LEVEL: Severe PID:2168 TID:5104 NODE:000 Title: **** DRDA ASCB **** Dump File:C:\DB2INSTALL\\IBM\DB2\DB2COPY1\DB2\FODC_Trap_2016-09-20-18 .28.33.174000_0000\2168.5104.000.dump.bin Stack: 0000000088BCB990 offset: 00000000000000E7 in <sqldValFromFixedCommon> 0000000088BCBA80 offset: 0000000000000B03 in <sqldReturnData> 0000000088BCBF80 offset: 000000000000264E in <sqldRowFetch> 0000000088BCC070 offset: 00000000000005C1 in <sqlritaSimplePerm> 0000000088BCC2E0 offset: 0000000000000504 in <sqlriSectInvoke> 0000000088BCC3C0 offset: 000000000000060E in <sqlrr_process_fetch_request> 0000000088BCC580 offset: 00000000000007F6 in <sqlrr_fetch> 0000000088BCC680 offset: 0000000000000571 in <sqljs_ddm_cntqry> 0000000088BCC730 offset: 0000000000000129 in <sqljsParseRdbAccessed> 0000000088BCC960 offset: 000000000000051C in <sqljsParse> 0000000088BCCB00 offset: 000000000000061A in <sqljsSqlam> 0000000088BCCD60 offset: 0000000000000586 in <sqljsDrdaAsInnerDriver> 0000000088BCCEA0 offset: 0000000000000163 in <sqljsDrdaAsDriver> 0000000088BCE100 offset: 0000000000000FBA in <sqeAgent::RunEDU> 0000000088BCE190 offset: 000000000000017A in <sqlzRunEDU> 0000000088BCFEB0 offset: 000000000000061D in <sqloEDUEntry> | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 11.1 Mod 2 Fix Pack 2 or higher * **************************************************************** | |
Local Fix: | |
available fix packs: | |
DB2 Version 11.1 Mod 2 Fix Pack 2 for Linux, UNIX, and Windows | |
Solution | |
First fixed in DB2 11.1 Mod 2 Fix Pack 2 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 25.11.2016 23.06.2017 23.06.2017 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |