Re: Online DB Reorg
2003-10-17 15:07:45
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
|
|
|