Performance tuning of Job
Posted: Fri Feb 13, 2015 2:44 pm
All, Have a question on performance tuning.
We have a job design like,
FTP PLUG IN -- TRANSFORMER--DB2 CONNECTOR.
It is almost 14 million record refresh everyday and taking almost 22 minutes to run. In log, it says, FTP Plug in "Logging delayed metadata" and finishes the job in 22 minutes. partitioning is AUTO and data is not sorted anywhere.
Any tips how to do an performance tuning. Job is running on 4 node configuration file and output table has one column as Primary key.
Source is delimited file which is in unix server.
Thanks,
We have a job design like,
FTP PLUG IN -- TRANSFORMER--DB2 CONNECTOR.
It is almost 14 million record refresh everyday and taking almost 22 minutes to run. In log, it says, FTP Plug in "Logging delayed metadata" and finishes the job in 22 minutes. partitioning is AUTO and data is not sorted anywhere.
Any tips how to do an performance tuning. Job is running on 4 node configuration file and output table has one column as Primary key.
Source is delimited file which is in unix server.
Thanks,