Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

DB2DIAG.LOG Error

216 views
Skip to first unread message

Fin

unread,
Feb 4, 2013, 10:56:54 AM2/4/13
to
During a db2rbind of ALL, I am getting the following error on 4 tables. Anyone got any ideas as to what is causing the problem ? The rebind log is indicating no issues whatsoever. As far as I can tell the tables themselves are fine.

This has only started happening since applying/installing the fixpak 2 build of Express-C 10.1

DB2 EXPRESS-C 10.1.2 on Windows 7 Pro SP1

2013-02-04-10.34.56.409000-300 I7738F1008 LEVEL: Info (Origin)
PID : 4832 TID : 2164 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : DB_NAME
APPHDL : 0-739 APPID: *LOCAL.DB2.130204153449
AUTHID : NONAME HOSTNAME: PC
EDUID : 2164 EDUNAME: db2agent (SQ4TEST)
FUNCTION: DB2 UDB, SW- query graph, sqlnq_cat_look, probe:120
MESSAGE : ZRC=0x80310004=-2144272380=SQLNN_E_NFOUND
"Could not find an internal object required to process the command"
DATA #1 : String, 51 bytes
CAT_LOOK (trace point 120): Timetamp checking for:
DATA #2 : String with size, 16 bytes
[TABLE_NAME]
DATA #3 : String, 12 bytes
createTime:
DATA #4 : Hexdump, 10 bytes
0x00000000CE3BC3E8 : 2012 1229 1906 5710 0001 ..)..W...
DATA #5 : String, 8 bytes
bindTs:
DATA #6 : Hexdump, 10 bytes
0x00000000CF0B43B0 : 2012 1228 2224 4817 2003 ..("$H. .

TheBoss

unread,
Feb 4, 2013, 3:32:16 PM2/4/13
to
Fin <tdav...@hotmail.com> wrote in
news:dbc9b8bc-1968-4ac8...@googlegroups.com:
I don't see any 'error' in above snippet of the db2diag.log, only an
informational message. You probably have set the diaglevel to 4?

--
Jeroen

Fin

unread,
Feb 4, 2013, 3:50:30 PM2/4/13
to
Sadly nope, thought about that, DIAGLEVEL is set to 2.

Fin

unread,
Mar 9, 2013, 2:50:49 AM3/9/13
to
Still getting this message every time I do a rebind for the table in question. I have even dropped and recreated the table from scratch but it still keep appearing. It may have an INFO tag but I ail to see how an INFO message is stating "Could not find an internal object required to process the command" Sounds like an error to me even when diaglevel = 2.

Can anyone please shed some light on this ?

2013-03-09-02.41.47.721000-300 I19625F1017 LEVEL: Info (Origin)
PID : 9536 TID : 6444 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : DB_NAME
APPHDL : 0-7 APPID: *LOCAL.DB2.130309074135
AUTHID : DB2ADMIN HOSTNAME: [PC_NAME]
EDUID : 6444 EDUNAME: db2agent (XXX)
FUNCTION: DB2 UDB, SW- query graph, sqlnq_cat_look, probe:120
MESSAGE : ZRC=0x80310004=-2144272380=SQLNN_E_NFOUND
"Could not find an internal object required to process the command"
DATA #1 : String, 51 bytes
CAT_LOOK (trace point 120): Timetamp checking for:
DATA #2 : String with size, 25 bytes
[TABLE_NAME]
DATA #3 : String, 12 bytes
createTime:
DATA #4 : Hexdump, 10 bytes
0x00000000CEAC5B00 : 2012 0723 2029 4688 4001 ..# )F.@.
DATA #5 : String, 8 bytes
bindTs:
DATA #6 : Hexdump, 10 bytes
0x00000000CEAD43B0 : 2012 0721 0518 4880 0001 ..!..H...
0 new messages