DB2 API stage
Posted: Mon Feb 07, 2011 3:15 pm
Is there any downside in runing load using DB2 API stage in parallel Execution mode? The target DB2 is on mainframe.
At the very least, nothing prevents from setting it to run in parallel. And according to DataStage framework, the stage that can be set to run in parallel will initiate process for every node. I did not check it because so far I have no target and no data. I am just considering if my jobs should be built that way. Any additional information on the topic will help. I know that similar thing can be done with ODBC stage, but API stage have better controls.mavrick21 wrote:I doubt if DB2 API stage can execute in parallel. As far as I know only DB2 Enterprise stage can execute in parallel. Please check the documentation.
Did you get a chance to look at the Score? As far as I know for few stages even if you set it for parallel execution, DataStage would execute it sequentially. This can been verified by looking at the Score.At the very least, nothing prevents from setting it to run in parallel. And according to DataStage framework, the stage that can be set to run in parallel will initiate process for every node.