DSXchange

Hi All,

i have this simple job where i'm just trying to insert or update a DB2 table from the Dataset using DB2 API stage.
Also i have set the Run Time Column propogation ON
I have defined only key columns in the COlumns tab of the Dataset and checked the run time column propogation

i have set the Update Action to be
Insert New or Update Existing Rows
and array size to 1

but i'm getting the following fatal error : i had also set the APT_DUMP_SCORE to true

Set $APT_DISABLE_COMBINATION (should be close) to True and rerun so we know where the error is really coming from.

Can you set the APT_DISABLE_COMBINATION to true and run again

Sorry i thought i had posted the error as well..

well i have set the APT_DUMP_SCORE to TRUE and this is what i am getting

main_program: This step has 1 dataset:
ds0: {/DataStage/data/DEV/SCD/ISS_INSERTS.ds
[pp] eSame->eCollectAny
op0[1p] (parallel APT_CombinedOperatorController:Data_Set_0)}
It has 1 operator:
op0[1p] {(parallel APT_CombinedOperatorController:
(Data_Set_0)
(DB2_UDB_API_4)
) on nodes (
node1[op0,p0]
)}
It runs 1 process on 1 node.

APT_CombinedOperatorController,0: Failure during execution of operator logic.

APT_CombinedOperatorController,0: Fatal Error: Fatal: Error occurred during link open processing.

node_node1: Player 1 terminated unexpectedly.

main_program: Unexpected exit status 1

main_program: Step execution finished with status = FAILED.

Any help is highly appreciated

This is what i am getting after setting the $APT_DISABLE_COMBINATION to true

main_program: This step has 2 datasets:
ds0: {/DataStage/data/DEV/SCD/ISS_INSERTS.ds
[pp] eSame->eCollectAny
op0[1p] (parallel Data_Set_0)}
ds1: {op0[1p] (parallel Data_Set_0)
[pp] eSame->eCollectAny
op1[1p] (parallel DB2_UDB_API_4)}
It has 2 operators:
op0[1p] {(parallel Data_Set_0)
on nodes (
node1[op0,p0]
)}
op1[1p] {(parallel DB2_UDB_API_4)
on nodes (
node1[op1,p0]
)}
It runs 2 processes on 1 node.

DB2_UDB_API_4,0: Failure during execution of operator logic.

DB2_UDB_API_4,0: Input 0 consumed 0 records.

DB2_UDB_API_4,0: Fatal Error: Fatal: Error occurred during link open processing.

node_node1: Player 2 terminated unexpectedly.

main_program: Unexpected exit status 1

Data_Set_0,0: Failure during execution of operator logic.

Data_Set_0,0: Input 0 consumed 3448 records.

Data_Set_0,0: Output 0 produced 3448 records.

Data_Set_0,0: Fatal Error: Unable to allocate communication resources

node_node1: Player 1 terminated unexpectedly.

main_program: Unexpected exit status 1

main_program: Step execution finished with status = FAILED.

No Answer for this..........Incomplete post will make the new user disoppoint

If you replace your DB2 output stage with a dataset, does your error persist? Does your DB2 stage have a reject link (because the score indicates 2 operators)?