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 >
