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
Job Aborting due to APT_CombinedOperatorCOntroller Error
Moderators: chulett, rschirm, roy
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
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.
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.