DB2 FOR LUW / DB2FORLUW / 970 - DB2

After a load with allow read access option, aA 901 error may be 
returned on the table when doing selects, runstats or anything 
that access the table. The table must have a XML column, and a 
constraint for this to occur.  The problem does not occur if 
allow read access option is not used. 
 
For example: 
db2 "create table t1 (a int, b int check (b > 0), c xml)" 
db2 create table t2 like t1 
db2 load from load.del of del insert into t1 allow read access 
db2 load query table t1 
db2 set integrity for t1 allow read access immediate checked for 
exception in t1 use t2     <== error 
 
 
data file load.del 
============= 
1,1,"<XDS FIL='load.del.001.xml' OFF='0' LEN='44' />" 
2,0,"<XDS FIL='load.del.001.xml' OFF='44' LEN='47' />" 
 
 
data file load.del.001.xml 
=================== 
<?xml version="1.0" encoding="UTF-8" ?><hi/><?xml version="1.0" 
encoding="UTF-8" ?><hello/> 
 
 
Error returned. 
 
SQL0901N  The SQL statement failed because of a non-severe 
system error. Subsequent SQL statements can be processed. 
(Reason "could not fetch basetable region root node".) 
SQLSTATE=58004 
 
Db2diag.log message returned. 
 
2013-11-11-14.28.59.018047-300 I11305287A1884     LEVEL: Severe 
PID     : 16973934             TID  : 12727       PROC : db2sysc 
0 
INSTANCE: db2inst              NODE : 000         DB   : SAMPLE 
APPHDL  : 0-8270               APPID: *LOCAL.db2inst. 
AUTHID  : DB2INST 
EDUID   : 12727                EDUNAME: db2agent (SAMPLE) 0 
FUNCTION: DB2 UDB, XML Node Manager, XmlrnNodeMgrFetchNode, 
probe:333 
MESSAGE : ZRC=0x82A40001=-2103181311=XMLRN_PRG_ERR 
          "XMRN unexpected system error" 
          DIA8532C An internal processing error has occurred. 
DATA #1 : String, 42 bytes 
could not fetch basetable region root node 
DATA #2 : EXT_LXID, PD_TYPE_XMRN_EXT_LXID, 40 bytes 
XMLS_EXT_LXID: 
   documentID:           0xd300000022c100 
   versionID:            0xacefa59 
   nodeID address:       0x0000000000000000 
   nodeIDDigit address:  0x0000000111bb29c8 
   nodeIDLen:            0 
   nodeIDDigitLen:       1 
   tbspID:               6 
   objectID:             6 
   objectClass:          0x0 
CALLSTCK: 
  [0] 0x09000000094153CC pdLog + 0xC0 
  [1] 0x0900000006F8AC50 
fetchNode__12XmlrnNodeMgrFP11XMLSTORE_CBP17xmlDataDescriptorR13X 
MLS_EXT_LXIDP12XmlsNidStackR8XMLS_XIDRP9XmlrnNodePUsbP13XMLS_WA 
+ 0x2D0 
  [2] 0x0900000006F1B3EC 
initWalker__15XmlrnTreeWalkerFP17xmlDataDescriptorUs + 0x350 
  [3] 0x090000000866C560 
getNodeStats__13XmlrnNodeInfoFP17xmlDataDescriptorP10SQLD_TSTATP 
10SQLD_CSTAT + 0x124 
  [4] 0x0900000006FECE94 
xdst__12XmlrnStatsCBFP17xmlDataDescriptorP10SQLD_TSTATP10SQLD_CS 
TAT + 0x150 
  [5] 0x0900000005F11D18 
traverseOneXMLDoc__12XmlrnStatsCBFP8SQLD_VALP10SQLD_TSTATP10SQLD 
_CSTAT + 0x1B0 
  [6] 0x0900000006FEBBF4 sqldtcst__FP10SQLD_TSTAT + 0xC40 
  [7] 0x0900000006FEA840 sqldtcst__FP10SQLD_TSTAT@glueA90 + 0x74 
  [8] 0x0900000005BC8CF8 
sqldEvalDataPred__FP13SQLD_DFM_WORKPUlP10SQLD_DPRED + 0x220 
  [9] 0x09000000094D2630 sqldReadNorm__FP13SQLD_DFM_WORKl + 
0x53C

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to V9.7 fix pack 10.                                  * 
****************************************************************

Load Table without the allow read access option.

Will be fixed in V9.7 fix pack 10.

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

20.11.2013
10.11.2014
10.11.2014

9.7.FP10