Tom,

None that I know of.  I agree that it is frustrating.  We have various
sized ADSM DBs with anywhere from 60MB to 10GB.  A recent auditdb
fix=yes done on a 370MB database (residing in 2GB worth of disk) took
over 24 hours and FAILED!  Ouch!  Even sybase DBCC's work faster than
the auditdb (the solution in that instance was to restore a previous
good db backup and run audit vols on the disk pools - not a pretty
picture and we lost some backups).

Perhaps there are some undocumented "SQL" update commands allowing us to
fix the relational integrity of the internal tables....

David
dmhendri AT fedex DOT com


Kauffman, Tom wrote:
>
> I've just had the 'opportunity' to run an auditdb with fix=yes to correct an
> internal inconsistency (I had an off-site volume got to 'pending' but
> couldn't change access from 'of' to anything else, because there were still
> references to it). The process took 11 hours. This is about the longes
> outage I can afford, and I can do it at most once a week.
>
> What other tools are available for ADSM database maintenance? We're about to
> add significantly to the size of the database, and I don't feel comfortable
> going forward with an un-maintainable database.
>
> TIA
>
> Tom Kauffman
> Sr. Technical Analyst
> NIBCO, Inc