Aimee Fillmore wrote:

>added some disk, installed a bigger EMC unit. All of the details are
>below 88%, most of the masters are under 80%. All disk sits on the EMC.
>Our databases sit on their own volume set (35 volumes), all other data
>reside on another volume set. We were getting as much as 800 per hour.

>I think our biggest hit is during the day when the on-line processing
>is contending with the batch.  I'm wondering if there is some tweak
>within my workgroups that might help.  I'm not confident in my
>configuration of this, and haven't made many changes since the last
>sys admin left.

It is very difficult to isolate a batch process that is calling
dbput/update/delete
from interactive processes that also access that database. If the batch job
gets any CPU it will generate IOs and locks.

One tool/secret that I use is Glance/iX. If you don't have this HP product,
you can download a demo version that is good for 120 days. (see below)

Glance makes it easy to get Disc IO statistics. The 'D' command takes
you to the disc detail screen. The top section displays one line for each
disc drive. This line shows the logical device number, utilization for the
interval (%), Average Service Time, physical read rate, physical write
rate, and the current, average and maximum queue lengths.

Given that you have added discs and do regular capacity management,
you may have inadvertently moved  the IO to a smaller number of
discs. The disc IO statistics will show the spread of the IO and the queue
lengths that may be at the root of your problem.

Cordially,

Mike Hornsby
Co-founder/Chief Technical Officer
Beechglen Development Inc. (beechglen.com)
513-922-0509
[log in to unmask] <mailto:[log in to unmask]>



Patch Description: GlancePlus/iX Trial Demo Patch:
Path Name: /mpe-ix_patches/c.75.00/GLFMXD3C
Path Name: /mpe-ix_patches/c.70.00/GLFMXD3B
Path Name: /mpe-ix_patches/c.65.00/GLFMXD3A
Path Name: /mpe-ix_patches/c.60.00/GLFLXT3A

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *