Author: "Whitlock, Brett" <brett.whitlock AT COUNTRYFINANCIAL DOT COM>
Date: Wed, 30 Aug 2006 15:12:51 -0500
Greetings list! I have a dba who is recommending I do a regularly scheduled database reorg (ie weekly). Anyone doing this? Can you share the good, the bad, and the ugly about doing this?
Author: Jurjen Oskam <jurjen AT STUPENDOUS DOT ORG>
Date: Wed, 30 Aug 2006 22:20:37 +0200
The general consensus here is that it almost always isn't worth doing. What reasons does the DBA provide for his recommendation? Regards, -- Jurjen Oskam
Author: Maurizio Teruzzi <maurizio.teruzzi AT FREESURF DOT CH>
Date: Wed, 30 Aug 2006 22:31:56 +0200
Hello guys, I will be great if this is possible... on current TSM DB model Ciao Maurizio I have a dba who is recommending I do a regularly scheduled database reorg (ie weekly). Anyone doing this? Can
Author: "Whitlock, Brett" <brett.whitlock AT COUNTRYFINANCIAL DOT COM>
Date: Wed, 30 Aug 2006 15:32:44 -0500
He's a dba, he can't help himself! He see's a database, he reorg's the database. I know from reading this list that a db reorg isn't often recommended. Problem is there is another dba up there, who h
Author: "Whitlock, Brett" <brett.whitlock AT COUNTRYFINANCIAL DOT COM>
Date: Wed, 30 Aug 2006 15:35:17 -0500
I forgot to say that we are running 5.3.3 on Windows. Hello guys, I will be great if this is possible... on current TSM DB model Ciao Maurizio -- Cordiali saluti Maurizio Teruzzi http://www.teruzzi.c
Author: Jurjen Oskam <jurjen AT STUPENDOUS DOT ORG>
Date: Thu, 31 Aug 2006 08:45:45 +0200
[TSM database reorganization] Again: *why* did the DBA reorg the database? The fact she used to do it frequently is not really relevant. In our case, I could run EXPIRE INVENTORY three times a day ra
Actually, the "paging space needs to be 2 times as large as your RAM"-argument was to get PhotoShop to run. This was seven years ago but it worked. Terry McColgan [TSM database reorganization] Again:
[TSM database reorganization] Been running TSM (ADSM) more than 10 years, more than 20 TSM servers, DB sizes from 6 GB to 250 GB and have yet to "reorg" ( ... shudder) one of them. John
John Bremer said the following on 8/31/06 10:35 AM: [TSM database reorganization] TSM weigh Been running TSM (ADSM) more than 10 years, more than 20 TSM servers, DB sizes from 6 GB to 250 GB and have
How long did it take? TSM weigh Been running TSM (ADSM) more than 10 years, more than 20 TSM servers, DB sizes from 6 GB to 250 GB and have yet to "reorg" ( ... shudder) one of them. John Did a resto
It took 4 days to finish. TSM weigh Been running TSM (ADSM) more than 10 years, more than 20 TSM servers, DB sizes from 6 GB to 250 GB and have yet to "reorg" ( ... shudder) one of them. John Did a r
Ok, db reorg is absolutely useless. Just don't, it's not worth the effort, it'll take you off-line for days and there is absolutely no reason to do it. Now, if you feel you db is getting to slow you
Author: David Longo <David.Longo AT HEALTH-FIRST DOT ORG>
Date: Thu, 31 Aug 2006 13:04:17 -0400
How big is that DB? This thing really works still? And 95% used! How long does expiration take, etc, etc.? David B. Longo System Administrator Health First, Inc. 3300 Fiske Blvd. Rockledge, FL 32955-
Actually I believe it's so in the event of a system crash, the contents of memory can be dumped to swap space for debug/analysis. Terry McColgan [TSM database reorganization] Again: *why* did the DBA