DB2 Extract Performance
Posted: Fri Sep 12, 2014 1:50 pm
Hello All,
I have a simple EXtract job from DB2 wherein we need to dump the entire table into a flat file.
Currently I am using DB2_Connector Stage (DB2 Connector --> Copy Stage with Forced Option =True --> Sequential File ) and am able to write around 23K records per second in the target Sequential File.
Is it is the maximum performance I can get in Datastage ?
I have some tables which has 65 Million records in them and they are taking 1 hour each to get extracted.
Our goal is to complete a table extract in 15- 20 minutes.
Is there any better way to do this ? Please suggest
I have a simple EXtract job from DB2 wherein we need to dump the entire table into a flat file.
Currently I am using DB2_Connector Stage (DB2 Connector --> Copy Stage with Forced Option =True --> Sequential File ) and am able to write around 23K records per second in the target Sequential File.
Is it is the maximum performance I can get in Datastage ?
I have some tables which has 65 Million records in them and they are taking 1 hour each to get extracted.
Our goal is to complete a table extract in 15- 20 minutes.
Is there any better way to do this ? Please suggest