DSXchange

Is it helpful to turn off the job monitor to increase performance and reduce overhead ?

Thanks in advance

Marginally. Maybe only negligibly. Depending on what you mean by "performance".

Performance in case of extracting data from Oracle by running user defined queries. We improved some performance by creating indexes on the source tables and we want to try some more options in different areas to enhance the performance.

So I was wondering if turning off the Job monitor could help.

I have no idea what you mean by "performance". How would you propose to measure it? (A quick search will tell you of my firmly held belief that rows/sec is an almost toally meaningless metric.)

My previous answer was that of an economist - the performance monitor requires some resources; if it's not running those resources are available for other processes. If nothing else is running, then those other processes can be DataStage processes. Supply and demand.

Samsuf, you have a partitioned DB..? Extracting in parallel...?