Does anyone know if it is recommended that you do a backup and restore to
clean up the database periodically as preventive maint., or is it only odne
if there is a problem/size constraint?

> -----Original Message-----
> From: Nathan King [SMTP:nathan.king AT USAA DOT COM]
> Sent: Wednesday, April 07, 1999 8:37 AM
> To:   ADSM-L AT VM.MARIST DOT EDU
> Subject:      Re: database reorg
>
> Khalid,
>
> There are known issues with expire inventory not working correctly in ADSM
> Severs prior to 3.1.2.13.
> The database bloat may be related to this problem.
>
> As far as a reorg, I'm not aware of any utils provided to do an actual
> reorg. However I've heard that the most efficent
> way of doing the next best thing is to backup your database and then do a
> restore db. This could remove
> some of the white space from the database.
>
> Nathan
>
>         -----Original Message-----
>         From:   Khalid Abdulqader [SMTP:abdukm0b AT ARAMCO.COM DOT SA]
>         Sent:   Wednesday, April 07, 1999 2:15 AM
>         To:     ADSM-L AT VM.MARIST DOT EDU
>         Subject:        Re: database reorg
>
>         We have the expireinterval sat to 1 hour. Server version is
> 3.1.1.0
> and we
>         are upgrading to 3.1.2.1. Are you suggesting that we should
> upgrade
> to
>         3.1.2.13 ?
>
>         -----Original Message-----
>         From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On
> Behalf
> Of
>         Trevor Foley
>         Sent: Wednesday, April 07, 1999 8:39 AM
>         To: ADSM-L AT VM.MARIST DOT EDU
>         Subject: Re: database reorg
>
>
>         Hi Khalid,
>
>         Before you go trying to reorg the database, I'd try to work out
> why
> the
>         database is growing. What version of the server are you running?
> There are
>         known problems with inventory expiration with 3.1.2.1 (I assume
> that
> you are
>         running inventory expiration regularly). If you are running
> 3.1.2.1,
> I'd
>         recommend upgrading to at least 3.1.2.13.
>
>
>         Trevor
>
>         -----Original Message-----
>         From: Khalid Abdulqader [mailto:abdukm0b AT ARAMCO.COM DOT SA]
>         Sent: Wednesday, April 07, 1999 2:24 PM
>         To: ADSM-L AT VM.MARIST DOT EDU
>         Subject: database reorg
>
>
>         ADSM data base is growing rapidly in our shop. I had to delete
> some
> old
>         backups (file spaces). I noticed only a minimal reduction in the
> database
>         utilization percentage. Does anybody know how to reorg the
> database
> and
>         reclaim the free space. Thanks
>
>
>         Khalid