Performance Enhancement
Posted: Thu Dec 13, 2007 5:54 am
Hi,
I have a small question on performance enhancement. Currently we are having design where source is text file , has transformer,lookup/joiner and then target as DB2.
But when we test our jobs with small amount of data (10000 rows) it works fine, when we do volume test with 10 Million record the job is giving aborting because of tmout 68 code.
DBA suggested us to split job into 2 and in first job have target as sequential file and in second job use db2 load to load from sequential file to target table.
I was just wondering will performance improve if we load sequential file and then use db2load to load data in db2 ??
Thanks in advance.
I have a small question on performance enhancement. Currently we are having design where source is text file , has transformer,lookup/joiner and then target as DB2.
But when we test our jobs with small amount of data (10000 rows) it works fine, when we do volume test with 10 Million record the job is giving aborting because of tmout 68 code.
DBA suggested us to split job into 2 and in first job have target as sequential file and in second job use db2 load to load from sequential file to target table.
I was just wondering will performance improve if we load sequential file and then use db2load to load data in db2 ??
Thanks in advance.