DB2 FOR LUW / DB2FORLUW / 970 - DB2

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

SQL0901N ERROR WHEN RUNSTATS WITH TABLESAMPLE OPTION AGAINST 
TABLE HAS XML COLUMN WITH LARGE AMOUNT OF ROWS.

Perform runstats without tablesample option

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
 

First fixed in DB2 UDB Version 9.7, FixPak 1

Perform runstats without tablesample option

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

09.07.2009
28.12.2009
28.12.2009

9.7.