×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Coworker used SQL Performance Monitor Wizard from IBM Navigator.
Three boxes were checked:
Job name (and job name was supplied)
Job user (and job user was supplied)
Statements that access these objects (and one view in one schema was
supplied).
Basically running this may double already significant run times of certain
batch jobs.
Job User Number Start End Duration
ERPCSTROL1 DARREN 626786 15:20:18 16:04:45 00:44:27
With SQL monitor running
ERPCSTROL1 DARREN 626550 14:52:26 15:12:39 00:20:13
Without
ERPCSTROL1 DARREN 624719 10:46:49 11:12:47 00:25:58
Without? (disk addition and rebalancing also)
ERPCSTROL1 DARREN 624563 10:20:31 10:42:08 00:21:37
With?
ERPCSTROL1 DARREN 623692 08:24:58 09:09:16 00:44:18
With?
ERPCSTROL1 DARREN 623423 07:59:43 08:19:43 00:20:00
Without?
The disk balancing was I added another storage space to this guest lpar
and told it to 'add and balance'. Hosting lpar is all SSD. Add and
balance really didn't take too awful long but disks jumped up to 50+% busy
on this guest.
Rob Berendt
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
