1 Row/Sec- 10 row/sec

nkln@you · Post by **nkln@you** » Mon Aug 21, 2006 9:13 am

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.

Krazykoolrohit · Post by **Krazykoolrohit** » Mon Aug 21, 2006 9:18 am

can you please provide us with job flow? which stages you using. databases if any?

nkln@you · Post by **nkln@you** » Mon Aug 21, 2006 9:28 am

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

Krazykoolrohit · Post by **Krazykoolrohit** » Mon Aug 21, 2006 9:36 am

add a sequential file in between

Ora 9I -> Transformer -> sequential file -> Ora 9i.

which stage are you using to load into oracle?

DSguru2B · Post by **DSguru2B** » Mon Aug 21, 2006 1:41 pm

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.

dprasanth · Post by **dprasanth** » Tue Aug 22, 2006 5:52 am

nkln@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

Have you done the following steps
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