Is it helpful to turn off the job monitor to increase performance and reduce overhead ?
Thanks in advance
Job Monitoring
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 397
- Joined: Wed Apr 12, 2006 2:28 pm
- Location: Tennesse
Job Monitoring
hi sam here
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 397
- Joined: Wed Apr 12, 2006 2:28 pm
- Location: Tennesse
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.
So I was wondering if turning off the Job monitor could help.
hi sam here
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.