My DS jobs in production are running very low. Very slow in the sense 1 row/sec also touched. It is fluctuating between 1- 10 rows/sec..
I dont feel there is a problem in Jobs. Can anyone suggest what to be done. Right now they are running like that.
1 Row/Sec- 10 row/sec
Moderators: chulett, rschirm, roy
1 Row/Sec- 10 row/sec
Aim high
-
- Charter Member
- Posts: 560
- Joined: Wed Jul 13, 2005 5:36 am
- Location: Ohio
-
- Charter Member
- Posts: 560
- Joined: Wed Jul 13, 2005 5:36 am
- Location: Ohio
You said this is happening in production. Was the same experienced in development or even system test environments?
What are the after sqls? If they are deletes, and the table size is huge, then that might be taking a long time. And during the execution of after sqls.
What are the after sqls? If they are deletes, and the table size is huge, then that might be taking a long time. And during the execution of after sqls.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Have you done the following stepsnkln@you wrote:Most of the Jobs having
Ora 9I -> Transformer -> Ora 9i.
Both target and source databases are Oracle. There will be some after sqls in the job. Datastage used is 7.0
1.Checked for arraysize and Transaction size
2. Analysed the tables on database
3. Check for the Edit--> Job Properties--> Performance--> Enabling Inter Process row buffer
4. Try to introduce Parallelism in your job( on the database side) by
ALTER TABLE <tablename> Parallel 4
5. Check whether the tables are properly indexed