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 |
