ADSM-L

Re: [ADSM-L] DB Audit

2007-12-06 03:17:54
Subject: Re: [ADSM-L] DB Audit
From: Henrik Wahlstedt <SHWL AT STATOILHYDRO DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 6 Dec 2007 09:17:21 +0100
Hi,

Audit DB is a single threaded slow operation and there are no tricks
besides auditing parts of the DB like ex. Storage. Look at R Sims
Quickfacrs and search for "partial audits".


//Henrik

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Andy Huebner
Sent: den 6 december 2007 00:17
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] DB Audit

I am not sure there is an answer for this problem:

We are running a "test" audit before we upgrade our TSM server.  The
audit appears that it will take about 200 hours to complete.  Upgrading
the DB and starting TSM took 15 minutes total.

The software is AIX 5.3 running TSM 5.4.0.0.  The hardware is a p550
with 4GB RAM & DMX3 disks.  The DB is about 120GB on 14 raw volumes; the
log is on a file system.  There are about 240 million objects in the DB.

During the audit the CPU is running mostly in the 10-15% range,
sometimes spiking higher.  The disks are pushing less than 1MBps each.

Is there a trick to make the audit use the available hardware and run
faster?

Thanks,



This e-mail (including any attachments) is confidential and may be
legally privileged. If you are not an intended recipient or an
authorized representative of an intended recipient, you are prohibited
from using, copying or distributing the information in this e-mail or
its attachments. If you have received this e-mail in error, please
notify the sender immediately by return e-mail and delete all copies of
this message and any attachments.
Thank you.


-------------------------------------------------------------------
The information contained in this message may be CONFIDENTIAL and is
intended for the addressee only. Any unauthorised use, dissemination of the
information or copying of this message is prohibited. If you are not the
addressee, please notify the sender immediately by return e-mail and delete
this message.
Thank you.