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
