DB2 Connector Stage ( Bulk Load )

[sreddy]

Hi

I am using DB2 Connector as Target Stage.

Write Mode: Bulk Load.
Table action: Append
Record count: 2000
Auto commit mode: off
Array size: 2000
Load timeout: 90
Directory for named pipe(unixonly): /tmp
Copy loaded data: Use device or directory
Loaded data copy location: /dev/null
=================================
I am testing 529998887 records. It is running 46:56 minutes. Extract, transfer is good while loading the data in to target table job is aborted with below errors.
===================================
STG_TP_ATTRIB_PIVOT,0: An error occurred while loading the table. (CC_DB2APILoadRecordDataSetConsumer::complete, file CC_DB2APILoadRecordDataSetConsumer.cpp, line 1,814)

STG_TP_ATTRIB_PIVOT,0: The runLocally() of the operator failed.

STG_TP_ATTRIB_PIVOT,0: Input 0 consumed 529998887 records.

STG_TP_ATTRIB_PIVOT,0: Operator terminated abnormally: runLocally() did not return APT_StatusOk
node_node1: Player 2 terminated unexpectedly.

main_program: APT_PMsectionLeader(1, node1), player 2 - Unexpected termination by Unix signal 9(SIGKILL).

main_program: Step execution finished with status = FAILED.
=======================================
correct me where i done the mistake

[ArndW]

Have you asked your DBA to check the database logs to see if the cause came from within DB2? Also, monitor your disk space during the load, I always feel uncomfortable when I see "/tmp" and huge files since that is often mounted on the system partition which has very little space.

[sreddy]

Arndw

Sure, i will work with my DBA. Disc space as well.

[sreddy]

When i check the Bulkload output Message File.

I found below error. Is this error message belongs to datastage or DB2.

===============================

SQL3213I The indexing mode is "REBUILD".

SQL2044N An error occurred while accessing a message queue. Reason code:
"2".

SQL2044N An error occurred while accessing a message queue. Reason code:
"2".

[chulett]

DB2