I did not HAVE to do the audit - mine was consistent. I only started it
in case we have to do it when I do production. I wanted to see how long
it would take. It's possible I then did the loaddb again, I don't
remember right now. I did the unload/load a couple of times with
various combinations of disk, which made little difference in the time.
Andy Carlson |\ _,,,---,,_
Senior Technical Specialist ZZZzz /,`.-'`' -. ;-;;,_
BJC Health Care |,4- ) )-,_. ,\ ( `'-'
St. Louis, Missouri '---''(_/--' `-'\_)
Cat Pics: http://andyc.dyndns.org/animal.html
On Tue, 18 Jun 2002, Ramnarayan, Sean A [EDS] wrote:
> Hi Andy
>
> How did you manage to start your server if you cancelled the Audit process.
>
> Thks
> Sean
>
> -----Original Message-----
> From: Andrew Carlson [mailto:andyc AT ANDYC.CARENET DOT ORG]
> Sent: Tuesday, June 18, 2002 3:25 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: DSMSERV DUMPDB , LOADDB and AUDITDB
>
>
> I did this on a test server, with a full production database. The
> unload took 16 hours, the load took 7 hours. I started the audit, and
> it appeared that it would run 92 hours!!!!. I did not let it finish, so
> I do not know how long it would have actually run.
>
>
> Andy Carlson |\ _,,,---,,_
> Senior Technical Specialist ZZZzz /,`.-'`' -. ;-;;,_
> BJC Health Care |,4- ) )-,_. ,\ ( `'-'
> St. Louis, Missouri '---''(_/--' `-'\_)
> Cat Pics: http://andyc.dyndns.org/animal.html
>
>
> On Tue, 18 Jun 2002, Ramnarayan, Sean A [EDS] wrote:
>
> > Hi
> >
> > I need to do a DUMPDB , LOADDB and AUDITDB of our TSM database.
> > I have currently done the DUMPDB and LOADDB and this process took about 13
> > Hours to complete.
> >
> > Total db before DUMPDB : 23 GB
> > Total db after Dumpdb and Loaddb : 12 GB
> >
> > After the Loaddb was completed it requesting to have an AUDITDB done before
> > bringing up the
> > TSM server.
> >
> > I would like to know how long it would take to do AUDITDB with a fix=yes
> > and detail=no after the database has
> > been reduced by nearly half the size ?
> >
> > Has anyone done this before or is there another way of doing the above as
> > our database is in an inconsistent state?
> >
> > We are running our TSM server on AIX 4.3.3 and the server is attached to
> > the SP (WinterHawk2 Wide Node).
> > The storage is attached to the Shark.
> >
> >
> > Thks
> >
> > Sean Ramnarayan
> > TSM/UNIX Administrator
> > EDS ( South Africa)
> >
> >
> >
> >
> >
> > "MMS <caltex.com>" made the following
> > annotations on 06/18/2002 11:29:09 AM
> > ------------------------------------------------------------------------------
> > DISCLAIMER
> > This message may contain confidential information that is legally
> > privileged and is intended only for the use of the parties to whom it is
> > addressed. If you are not an intended recipient, you are hereby notified
> > that any disclosure, copying, distribution or use of any information in
> > this message is strictly prohibited. If you have received this message in
> > error, please notify the sender immediately and delete the message. Thank
> > you.
> >
> > ==============================================================================
> >
>
>
> "MMS <caltex.com>" made the following
> annotations on 06/18/2002 04:59:56 PM
> ------------------------------------------------------------------------------
> DISCLAIMER
> This message may contain confidential information that is legally privileged
> and is intended only for the use of the parties to whom it is addressed. If
> you are not an intended recipient, you are hereby notified that any
> disclosure, copying, distribution or use of any information in this message
> is strictly prohibited. If you have received this message in error, please
> notify the sender immediately and delete the message. Thank you.
>
> ==============================================================================
>
|