|
Problem IC61933
|
Status: Closed |
SQL0901N ERROR WHEN RUNSTATS WITH TABLESAMPLE OPTION AGAINST TABLE HAS XML COLUMN WITH LARGE AMOUNT OF ROWS. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
SQL0901N error is hit when runstats with tablesample option
against table has XML columns with over 10,000,000 non null XML
rows.
db2diag.log has the following kind of messages:
2009-05-02-13.02.58.480811-240 I2139319E1676 LEVEL: Severe
PID : 16375 TID : 189699975520 PROC :
db2sysc 0
INSTANCE: db2inst NODE : 000 DB :
SAMPLEDB
APPHDL : 0-50023 APPID:
*LOCAL.db2inst.090502105741
AUTHID : MSDB2
EDUID : 353 EDUNAME: db2agent (SAMPLEDB) 0
FUNCTION: DB2 UDB, XML Node Manager, XmlrnStatsCheckSanity,
probe:20
MESSAGE : ZRC=0x82A40001=-2103181311=XMLRN_PRG_ERR
"XMRN unexpected system error"
DIA8532C An internal processing error has occurred.
DATA #1 : String, 32 bytes
XML Stats Sanity check is failed
CALLSTCK:
[0] 0x0000002A989438F7
_Z21XmlrnStatsCheckSanityP13SQLO_MEM_POOLP8sqlrg_pdi + 0x163
[1] 0x0000002A97ED1B67
_Z20sqlr_update_catalogsP8sqlrr_cbP11sqlrrstringS2_P10SQLD_TSTAT
iPP10SQLD_ISTATPiPP8sqlrg_pdP5sqlcaiP14sqlrg_nodecardtjm +
0x3FFB
[2] 0x0000002A97EBE877
_Z17sqlrLocalRunstatsP8sqlrr_cbP11sqlrrstringS2_S2_httPP8sqlrg_p
diiiiP16sqlrl_stats_colsPPsjPPtjdjtPP20sqlr_runstats_resultS8_m
+ 0x2267
[3] 0x0000002A97EB72FA
_Z8sqlrrstaP8sqlrr_cbP11sqlrrstringS2_S2_hhP17sqlrl_stats_parmsP
KhPs + 0xD1E
[4] 0x0000002A97F14AF6 _Z17sqlrr_runstats_DAP5sqldaP5sqlca +
0x852
[5] 0x0000002A9705A6F6
_Z19sqlerKnownProcedureiPcPiP5sqldaS2_P13sqlerFmpTableP8sqeAgent
P5sqlca + 0xFE0
[6] 0x0000002A9705CF62
_Z11sqlerCallDLP14db2UCinterfaceP9UCstpInfo + 0xE30
[7] 0x0000002A97155C65
_Z19sqljs_ddm_excsqlsttP14db2UCinterfaceP13sqljDDMObject + 0x361
[8] 0x0000002A9714A5F3
_Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U
Cinterface + 0x3E7
[9] 0x0000002A9714AD08
_Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterface + 0xF4 |
| Problem Summary: |
SQL0901N ERROR WHEN RUNSTATS WITH TABLESAMPLE OPTION AGAINST
TABLE HAS XML COLUMN WITH LARGE AMOUNT OF ROWS. |
| Local Fix: |
Perform runstats without tablesample option |
| available fix packs: |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
First fixed in DB2 UDB Version 9.7, FixPak 1 |
| Workaround |
Perform runstats without tablesample option |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 09.07.2009
28.12.2009
28.12.2009 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.1
|
 |
