While that may be true, in this instance, we deleted fully half or more
of the DB, and feel it would be good to do once.

Andy Carlson                                    |\      _,,,---,,_
Senior Technical Specialist               ZZZzz /,`.-'`'    -.  ;-;;,_
BJC Health Care                                |,4-  ) )-,_. ,\ (  `'-'
St. Louis, Missouri                           '---''(_/--'  `-'\_)
Cat Pics: http://andyc.dyndns.org/animal.html


On Fri, 17 Oct 2003, Remco Post wrote:

> On Friday, Oct 17, 2003, at 20:20 Europe/Amsterdam, Andy Carlson wrote:
>
> > I remember at one time, that online DB reorg was on the list of TSM
> > futures.  Is it still there?  Anyone have an idea about when it might
> > come out?  We badly need a reorg.  We split our TSM to two instances,
> > by
> > creating a new instance and doing full backups to it, and deleting the
> > old stuff out of the original instance, but the database shrunk
> > negligibly, so I think we need a reorg.  Again, but, we have Legato
> > Disk
> > Extender users who don't wish for us to be down for an extended period
> > doing a reorg.  Thanks  for any information.
> >
>
> database fragmentation is a fact of life. You learn to live with it. I
> once wrote a sql query that calculates the fragmentation of the db,
> iirc (Eric are you listening?). The upside is, that once you've scaled
> your system to operate properly with the more fragmented db, you never
> need to worry about downtime for a dbunload/dbload again....
>
> (yes my db is spread across 5 raid-1 volumes....)
>
> >
> > Andy Carlson                                    |\      _,,,---,,_
> > Senior Technical Specialist               ZZZzz /,`.-'`'    -.  ;-;;,_
> > BJC Health Care                                |,4-  ) )-,_. ,\ (  `'-'
> > St. Louis, Missouri                           '---''(_/--'  `-'\_)
> > Cat Pics: http://andyc.dyndns.org/animal.html
> >
> --
> Met vriendelijke groeten,
>
> Remco Post
>
> SARA - Reken- en Netwerkdiensten                      http://www.sara.nl
> High Performance Computing  Tel. +31 20 592 8008    Fax. +31 20 668 3167
>
> "I really didn't foresee the Internet. But then, neither did the
> computer
> industry. Not that that tells us very much of course - the computer
> industry
> didn't even foresee that the century was going to end." -- Douglas Adams
>