Search String: Display: Description: Sort:

Results:

References: [ +subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*TSM\s+Database\s+Reorg\s*$/: 15 ]

Total 15 documents matching your query.

1. TSM Database Reorg (score: 1)
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?
/usr/local/webapp/mharc-adsm.org/html/ADSM-L/2006-08/msg00463.html (11,334 bytes)

2. Re: TSM Database Reorg (score: 1)
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
/usr/local/webapp/mharc-adsm.org/html/ADSM-L/2006-08/msg00464.html (11,611 bytes)

3. Re: TSM Database Reorg (score: 1)
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
/usr/local/webapp/mharc-adsm.org/html/ADSM-L/2006-08/msg00465.html (12,443 bytes)

4. Re: TSM Database Reorg (score: 1)
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
/usr/local/webapp/mharc-adsm.org/html/ADSM-L/2006-08/msg00466.html (12,518 bytes)

5. Re: TSM Database Reorg (score: 1)
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
/usr/local/webapp/mharc-adsm.org/html/ADSM-L/2006-08/msg00467.html (12,656 bytes)

6. Re: TSM Database Reorg (score: 1)
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
/usr/local/webapp/mharc-adsm.org/html/ADSM-L/2006-08/msg00469.html (12,331 bytes)

7. Re: TSM Database Reorg (score: 1)
Author: Terry McColgan <tmccolgan AT OCT DOT CA>
Date: Thu, 31 Aug 2006 08:26:19 -0400
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:
/usr/local/webapp/mharc-adsm.org/html/ADSM-L/2006-08/msg00472.html (12,418 bytes)

8. Re: TSM Database Reorg (score: 1)
Author: John Bremer <jbremer AT LANL DOT GOV>
Date: Thu, 31 Aug 2006 08:35:49 -0600
[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
/usr/local/webapp/mharc-adsm.org/html/ADSM-L/2006-08/msg00473.html (12,070 bytes)

9. Re: TSM Database Reorg (score: 1)
Author: Jonathan Siegle <jsiegle AT PSU DOT EDU>
Date: Thu, 31 Aug 2006 10:52:53 -0400
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
/usr/local/webapp/mharc-adsm.org/html/ADSM-L/2006-08/msg00474.html (12,690 bytes)

10. Re: TSM Database Reorg (score: 1)
Author: fred johanson <fred AT UCHICAGO DOT EDU>
Date: Thu, 31 Aug 2006 10:29:34 -0500
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
/usr/local/webapp/mharc-adsm.org/html/ADSM-L/2006-08/msg00476.html (13,056 bytes)

11. Re: TSM Database Reorg (score: 1)
Author: jsiegle <jsiegle AT PSU DOT EDU>
Date: Thu, 31 Aug 2006 11:43:41 -0400
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
/usr/local/webapp/mharc-adsm.org/html/ADSM-L/2006-08/msg00477.html (13,233 bytes)

12. Re: TSM Database Reorg (score: 1)
Author: Remco Post <r.post AT SARA DOT NL>
Date: Thu, 31 Aug 2006 18:13:55 +0200
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
/usr/local/webapp/mharc-adsm.org/html/ADSM-L/2006-08/msg00478.html (13,130 bytes)

13. Re: TSM Database Reorg (score: 1)
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-
/usr/local/webapp/mharc-adsm.org/html/ADSM-L/2006-08/msg00481.html (13,440 bytes)

14. Re: TSM Database Reorg (score: 1)
Author: jsiegle <jsiegle AT PSU DOT EDU>
Date: Thu, 31 Aug 2006 13:23:20 -0400
Available Assigned Maximum Maximum Page Total Used Pct Max. Space Capacity Extension Reduction Size Usable Pages Util Pct (MB) (MB) (MB) (MB) (bytes) Pages Util -- -- -- -- -- -- -- -- -- 479,940 398
/usr/local/webapp/mharc-adsm.org/html/ADSM-L/2006-08/msg00482.html (14,943 bytes)

15. Re: TSM Database Reorg (score: 1)
Author: Gerald <gwichman AT GMAIL DOT COM>
Date: Thu, 31 Aug 2006 13:51:58 -0700
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
/usr/local/webapp/mharc-adsm.org/html/ADSM-L/2006-08/msg00487.html (12,626 bytes)


This search system is powered by Namazu