Re: How accurate are AIX disk reporting metrics with a SAN?
On Sep 11, 2:04*pm, Patrick Finnegan <finnegan.patr...@gmail.com>
> On Sep 10, 9:10*pm, Hajo Ehlers <serv...@metamodul.com> wrote:
> > > We are using JFS with no striping cos MWC is turned on but does MWC
> > > mean anything on a SAN?[/color][/color]
> > Back to the basics:
> > What are you trying to archive anyway. ?
> > Do you have any performance issues ?[/color]
> We have a DB2 database performance issue that is related to slow disk
> i/o times which could be caused by a technical issue with the SAN or
> simply by contention if for some reason the data is clustered on one
> small area of the san. *We have to prove that there is a problem
> before the Management Company who look after the san will allocate
> resources to look at the issue. *Working on the principle that we will
> get the best performance by allocating the data over as many disk as
> possible we were wondering whether the AIX system utilities would give
> us any worthwhile information about how the data is distributed on the
> san but it looks like they don't so we will have to escalate up the
> management chain.
> The disks in the SAN are raid 5 so the logical volume MWC setting is
> probably irrelevant.[/color]
Here are the DB2 I/O stats for writes to the logs and databases.
Looks pretty slow to me.
Log write time (sec.ns) = 33228.000000004
Number write log IOs = 14813312
(33228.000000004 * 1000 ) / 14813312 = 2.24 milliseconds per
Direct write requests = 336397
Direct write elapsed time (ms) = 3799167
3799167 / 336397 = 11.29 milliseconds per write.