SQL0901n error is returned when sql query accessing XML data
runs.
The complete error message looks like this when the sql is run
from CLP:
SQL0901N The SQL statement failed because of a non-severe system
error.
Subsequent SQL statements can be processed. (Reason "".)
SQLSTATE=58004
The following error messages are written into db2diag.log:
2009-12-18-10.20.08.222315-360 E1280A552 LEVEL: Severe
PID : 626942 TID : 11114 PROC : db2sysc
0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-47367 APPID: local.db2.appid
AUTHID : METASVC
EDUID : 11114 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc,
probe:200
MESSAGE : ADM0001C A severe error has occurred. Examine the
administration
notification log and contact IBM Support if necessary.
2009-12-18-10.20.08.241188-360 I1833A486 LEVEL: Severe
PID : 626942 TID : 11114 PROC : db2sysc
0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-47367 APPID: local.db2.appid
AUTHID : METASVC
EDUID : 11114 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc,
probe:250
RETCODE : ZRC=0x80A6040A=-2136603638=XMLVNOMEM "Not enough
memory in
xmlvCB"
2009-12-18-10.20.08.241561-360 I2320A699 LEVEL: Severe
PID : 626942 TID : 11114 PROC : db2sysc
0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-47367 APPID: local.db2.appid
AUTHID : METASVC
EDUID : 11114 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc,
probe:275
MESSAGE : MASTER TIME INFO
DATA #1 : Hexdump, 40 bytes
0x0700000048E42598 : 0000 0000 4ACA AAFF 0135 0000 0004 BA4F
....J....5.....O
0x0700000048E425A8 : 001C 7CB9 BA68 AB0D 0000 0000 004D 84F6
..|..h.......M..
0x0700000048E425B8 : 801C 7CB9 BA68 AB0C
..|..h..
2009-12-18-10.20.08.241865-360 I3020A187 LEVEL: Severe
PID:626942 TID:11114 NODE:000 Title: MASTER TIME INFO
Dump
File:/udbhome/db2inst1/sqllib/db2dump/626942.11114.000.dump.bin
2009-12-18-10.20.08.256042-360 I3208A827 LEVEL: Severe
PID : 626942 TID : 11114 PROC : db2sysc
0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-47367 APPID: local.db2.appid
AUTHID : METASVC
EDUID : 11114 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc,
probe:300
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: 0
sqlerrmc:
sqlerrp : SQLRI354
sqlerrd : (1) 0x80A6040A (2) 0x0000040A (3)
0x00000000
(4) 0x00000000 (5) 0xFFFFFFBA (6)
0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: |
