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.
![Confused :?](./images/smilies/icon_confused.gif)
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
-
- 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?