ADSM-L

Re: DSMSERV DUMPDB , LOADDB and AUDITDB

2002-06-18 14:58:54
Subject: Re: DSMSERV DUMPDB , LOADDB and AUDITDB
From: Andrew Carlson <andyc AT ANDYC.CARENET DOT ORG>
Date: Tue, 18 Jun 2002 13:54:52 -0500
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.
>
> ==============================================================================
>
<Prev in Thread] Current Thread [Next in Thread>