one of my job in the Daily job scheduling,SLA time is 1:20 mins.
Job design is like
DB2--->Transformer-->DB2(Target)
29th Apr 10 :Num of records processing :23 milions (Row/sec :1575 records from Transformer -->DB2(Target))
28th Apr 10:Num of records processing :23 milions (Row/sec :4780 recordsfrom Transformer -->DB2(Target))
but today this job taken morethan 4 hrs.
how can I improve the performance of this job.
Improve the job performance
Moderators: chulett, rschirm, roy
How can anyone help without any details? 
What kind of "load" is this? What are you doing with these 23M records on a daily basis? How many nodes? (etc,etc) Some improperly designed loads by their very nature will take longer and longer to run, hence the question.
What kind of "load" is this? What are you doing with these 23M records on a daily basis? How many nodes? (etc,etc) Some improperly designed loads by their very nature will take longer and longer to run, hence the question.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
shivajid2k
- Participant
- Posts: 19
- Joined: Mon Feb 14, 2005 11:34 pm
Re: Improve the job performance
What stage are you using? DB2 API or Enterprise?