You must be doing some db2/mq work under the covers and the queue you have
accessed has a message that has an invalid
format. So either another program put the bad message in the queue or
somehow your process to load up that queue is tainted.
Check out the queue.
"Mohammed Mohsin
"
<db2udbdba-ezmlms To
hield-x24659396.x "LazyDBA Discussion"
[Email Address Removed] <[Email address protected]
a.com> cc
04/25/2006 03:21 Subject
AM LOAD RELATED
Hi All,
I am on solaris 5.8 with db2 8.1.6 and I am trying to load data into a
table through an informatica session, while doing so iam getting the
following error:
WRITER_1_*_1> WRT_8229 Database errors occurred:
[IBM][CLI Driver][DB2/SUN64] SQL2044N An error occurred while accessing a
message queue. Reason code: "4".
sqlstate =
Database driver error...
Function Name : Execute
DB2 Fatal Error
DB2 bulk execute (CLI load) failed.
WRITER_1_*_1> Mon Apr 24 14:14:24 2006
WRITER_1_*_1> WRT_8076 Writer run terminated. [Commit Error]
After identifying the following Error code SQL2044N
An error occurred while accessing a message queue. Reason code:
"<reason-code>"4
An invalid message was received from a message queue.
My db2diaglog.log reads as follows:
Interrupt received in formatter 0.
2006-04-24-14.14.22.169291 Instance:db2inst Node:000
PID:24571(db2agent (PRDDB) 0) TID:1 Appid:*LOCAL.db2inst.05DF64130501
database utilities DIAG_ERROR Probe:0 Database:PRDDB
LOADID: 24571.2006-04-24-14.05.02.084667.0 (3;4)
Unexpected msg. 7, 0, Detected in file: sqluvld.C,line 5072
2006-04-24-14.14.22.739489 Instance:db2inst Node:000
PID:24571(db2agent (PRDDB) 0) TID:1 Appid:*LOCAL.db2inst.05DF64130501
database utilities sqlulBMResponse Probe:385 Database:PRDDB
DIA0001E An internal error occurred. Report the following error code : "".
PID:24571 TID:1 Node:000 Title: rc
0xFFFFFFFF7FFF50BC : 0x00000000
2006-04-24-14.14.24.580186 Instance:db2inst Node:000
PID:24571(db2agent (PRDDB) 0) TID:1 Appid:*LOCAL.db2inst.05DF64130501
relation data serv sqlrr_array_input_load Probe:100 Database:PRDDB
DIA8532C An internal processing error has occurred.
ZRC=0x82150001ÿ
2006-04-24-14.14.24.601936 Instance:db2inst Node:000
PID:24571(db2agent (PRDDB) 0) TID:1 Appid:*LOCAL.dbinst.05DF64130501
relation data serv sqlrr_array_input_load Probe:110 Database:PRDDB
DIA8532C An internal processing error has occurred.
ZRC=0x82150001ÿ
2006-04-24-14.14.24.665699 Instance:dbinst Node:000
PID:24571(db2agent (PRDDB) 0) TID:1 Appid:*LOCAL.db2inst.05DF64130501
oper system services sqlormdir Probe:100 Database: PRDDB
errno:
0xFFFFFFFF7FFF2D6C : 0x00000011 ....
PID:24571 TID:1 Node:000 Title: Path/Filename
/database/PRDDB/db2inst/NODE0000/SQL00001/load/DB200003.PID/DB200004.OID
COULD ANYONE TELL ME WHY THIS OCCURS AND HOW CAN I RESOLVE THIS AT MY DB
LEVEL
Thanks in Advance,
Mohammed Mohsin
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
DB2 & UDB email list listserv db2-l LazyDBA home page