suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

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
Db2 Version 11.1 Mod2 Fix Pack2 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod2 Fix Pack2 iFix002 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix002 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)