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






DB2 & UDB email list listserv db2-l LazyDBA home page