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
>
|