Topic
  • 1 reply
  • Latest Post - ‏2009-12-10T14:48:09Z by sfvn
sfvn
sfvn
2 Posts

Pinned topic SQLCODE=-901, SQLSTATE=58004, SQLERRMC=sqlno_itr_plan::next

‏2009-12-10T11:31:25Z |
SQL Exception: DB2 SQL Error: SQLCODE=-901, SQLSTATE=58004, SQLERRMC=sqlno_itr_plan::next [300]:rc( 0) , DRIVER=4.0.100

--

Environment: RedHat Linux 5 (64 bit), DB2 9.7 Express-C using pureXML and Text Search, Tomcat 6

Yesterday after lots of updates on XML columns we did not get any search results and found the following in db2diag.log.

Restarting db2ts, db2 and the OS didn't help. sqlno_itr_plan::next seems to be only related to db2 8

2009-12-09-11.40.13.045353+000 E517416E546 LEVEL: Severe
PID : 2382 TID : 47888147147072PROC : db2sysc
INSTANCE: {removed} NODE : 000 DB : {removed}
APPHDL : 0-40967 APPID: 127.0.0.1.51585.091209104023
AUTHID : {removed}
EDUID : 25730 EDUNAME: db2agent ({removed})
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-09-11.40.13.073451+000 I517963E447 LEVEL: Severe
PID : 2382 TID : 47888147147072PROC : db2sysc
INSTANCE: {removed} NODE : 000 DB : {removed}
APPHDL : 0-40967 APPID: 127.0.0.1.51585.091209104023
AUTHID : {removed}
EDUID : 25730 EDUNAME: db2agent ({removed})
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:250
RETCODE : ZRC=0x00000000=0=PSM_OK "Unknown"

2009-12-09-11.40.13.073549+000 I518411E620 LEVEL: Severe
PID : 2382 TID : 47888147147072PROC : db2sysc
INSTANCE: {removed} NODE : 000 DB : {removed}
APPHDL : 0-40967 APPID: 127.0.0.1.51585.091209104023
AUTHID : {removed}
EDUID : 25730 EDUNAME: db2agent ({removed})
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:275
MESSAGE : MASTER TIME INFO
DATA #1 : Hexdump, 32 bytes
0x00002B8E7F1BF2A0 : 8A59 1E4B 0000 0000 F700 0000 73C7 0300 .Y.K........s...
0x00002B8E7F1BF2B0 : 74C7 0300 8A59 1E4B 0000 0000 0000 0000 t....Y.K........

2009-12-09-11.40.13.073638+000 I519032E189 LEVEL: Severe
PID:2382 TID:47888147147072 NODE:000 Title: MASTER TIME INFO
Dump File:{removed}/sqllib/db2dump/2382.25730.000.dump.bin

2009-12-09-11.40.13.073780+000 I519222E880 LEVEL: Severe
PID : 2382 TID : 47888147147072PROC : db2sysc
INSTANCE: {removed} NODE : 000 DB : {removed}
APPHDL : 0-40967 APPID: 127.0.0.1.51585.091209104023
AUTHID : {removed}
EDUID : 25730 EDUNAME: db2agent ({removed})
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: 58
sqlerrmc: sqlno_itr_plan::next [300]:rc( 0)
sqlerrp : SQLNO093
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000008 (5) 0xFFFFFED4 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:

2009-12-09-11.40.13.073867+000 I520103E178 LEVEL: Severe
PID:2382 TID:47888147147072 NODE:000 Title: SQLCA
Dump File:{removed}/sqllib/db2dump/2382.25730.000.dump.bin

2009-12-09-11.40.13.073942+000 I520282E521 LEVEL: Severe
PID : 2382 TID : 47888147147072PROC : db2sysc
INSTANCE: {removed} NODE : 000 DB : {removed}
APPHDL : 0-40967 APPID: 127.0.0.1.51585.091209104023
AUTHID : {removed}
EDUID : 25730 EDUNAME: db2agent ({removed})
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:400
MESSAGE : CREATOR
DATA #1 : Hexdump, 8 bytes
0x00002B8DE9B46E58 : 4E55 4C4C 4944 2020 NULLID

2009-12-09-11.40.13.074029+000 I520804E521 LEVEL: Severe
PID : 2382 TID : 47888147147072PROC : db2sysc
INSTANCE: {removed} NODE : 000 DB : {removed}
APPHDL : 0-40967 APPID: 127.0.0.1.51585.091209104023
AUTHID : {removed}
EDUID : 25730 EDUNAME: db2agent ({removed})
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:450
MESSAGE : PACKAGE
DATA #1 : Hexdump, 8 bytes
0x00002B8DE9B46E50 : 5359 5353 4832 3030 SYSSH200

2009-12-09-11.40.13.074107+000 I521326E180 LEVEL: Severe
PID:2382 TID:47888147147072 NODE:000 Title: CREATOR
Dump File:{removed}/sqllib/db2dump/2382.25730.000.dump.bin

2009-12-09-11.40.13.074168+000 I521507E180 LEVEL: Severe
PID:2382 TID:47888147147072 NODE:000 Title: PACKAGE
Dump File:{removed}/sqllib/db2dump/2382.25730.000.dump.bin

2009-12-09-11.40.13.074228+000 I521688E185 LEVEL: Severe
PID:2382 TID:47888147147072 NODE:000 Title: REQUEST TYPE
Dump File:{removed}/sqllib/db2dump/2382.25730.000.dump.bin

2009-12-09-11.40.13.134075+000 I521874E188 LEVEL: Severe
PID:2382 TID:47888147147072 NODE:000 Title: APM COMMON INFO
Dump File:{removed}/sqllib/db2dump/2382.25730.000.dump.bin

2009-12-09-11.40.13.134142+000 I522063E184 LEVEL: Severe
PID:2382 TID:47888147147072 NODE:000 Title: CONTEXT MCB
Dump File:{removed}/sqllib/db2dump/2382.25730.000.dump.bin

2009-12-09-11.40.13.134203+000 I522248E186 LEVEL: Severe
PID:2382 TID:47888147147072 NODE:000 Title: PACKAGE ENTRY
Dump File:{removed}/sqllib/db2dump/2382.25730.000.dump.bin

2009-12-09-11.40.13.134264+000 I522435E193 LEVEL: Severe
PID:2382 TID:47888147147072 NODE:000 Title: CACHED PACKAGE ENTRY
Dump File:{removed}/sqllib/db2dump/2382.25730.000.dump.bin

2009-12-09-11.40.13.143771+000 I522629E192 LEVEL: Severe
PID:2382 TID:47888147147072 NODE:000 Title: Recursive dump_sect
Dump File:{removed}/sqllib/db2dump/2382.25730.000.dump.bin

2009-12-09-11.40.13.143832+000 I522822E187 LEVEL: Severe
PID:2382 TID:47888147147072 NODE:000 Title: SECTION NUMBER
Dump File:{removed}/sqllib/db2dump/2382.25730.000.dump.bin

2009-12-09-11.40.13.143892+000 I523010E186 LEVEL: Severe
PID:2382 TID:47888147147072 NODE:000 Title: SECTION ENTRY
Dump File:{removed}/sqllib/db2dump/2382.25730.000.dump.bin

2009-12-09-11.40.13.143953+000 I523197E192 LEVEL: Severe
PID:2382 TID:47888147147072 NODE:000 Title: SECTION CURSOR INFO
Dump File:{removed}/sqllib/db2dump/2382.25730.000.dump.bin

2009-12-09-11.40.13.144059+000 I523390E186 LEVEL: Severe
PID:2382 TID:47888147147072 NODE:000 Title: SIBLING ENTRY
Dump File:{removed}/sqllib/db2dump/2382.25730.000.dump.bin

2009-12-09-11.40.13.144120+000 I523577E3777 LEVEL: Severe
PID : 2382 TID : 47888147147072PROC : db2sysc
INSTANCE: {removed} NODE : 000 DB : {removed}
APPHDL : 0-40967 APPID: 127.0.0.1.51585.091209104023
AUTHID : {removed}
EDUID : 25730 EDUNAME: db2agent ({removed})
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_sibling, probe:200
MESSAGE : section stmt
DATA #1 : Hexdump, 654 bytes
0x00002B8E7F6E46A0 : 5345 4C45 4354 202A 2046 524F 4D20 2820 SELECT * FROM (
0x00002B8E7F6E46B0 : 5345 4C45 4354 2052 4F57 4E55 4D42 4552 SELECT ROWNUMBER
0x00002B8E7F6E46C0 : 2829 204F 5645 5228 2920 4153 2052 4F57 () OVER() AS ROW
0x00002B8E7F6E46D0 : 5F4E 554D 2C20 494E 4E45 525F 5441 424C _NUM, INNER_TABL
0x00002B8E7F6E46E0 : 452E 2A20 4652 4F4D 2028 2009 5345 4C45 E.* FROM ( .SELE

... ... ...
... ... ...
[lots more]
Updated on 2009-12-10T14:48:09Z at 2009-12-10T14:48:09Z by sfvn
  • sfvn
    sfvn
    2 Posts

    Re: SQLCODE=-901, SQLSTATE=58004, SQLERRMC=sqlno_itr_plan::next

    ‏2009-12-10T14:48:09Z  
    ran: RUNSTATS ON TABLE tablename FOR INDEXES ALL

    -> problem fixed

    db2 had problems with one sql/xml script only; the same script without parameter markers worked fine

    ... how to avoid this to happen again?

    the database may get updated frequently and heavily

    i can't possibly run RUNSTATS after every update