Re: TSM Database Reorg

2006-08-31 Thread Jurjen Oskam
On Wed, Aug 30, 2006 at 03:32:44PM -0500, Whitlock, Brett wrote: [TSM database reorganization] recommended. Problem is there is another dba up there, who has some TSM experience, who says she used to do it painlessly. Anyone want to weigh in? Again: *why* did the DBA reorg the

Re: TSM Database Reorg

2006-08-31 Thread Terry McColgan
, 2006 2:46 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: TSM Database Reorg On Wed, Aug 30, 2006 at 03:32:44PM -0500, Whitlock, Brett wrote: [TSM database reorganization] recommended. Problem is there is another dba up there, who has some TSM experience, who says she used to do it painlessly

Re: TSM Database Reorg

2006-08-31 Thread John Bremer
[TSM database reorganization] recommended. Problem is there is another dba up there, who has some TSM experience, who says she used to do it painlessly. Anyone want to weigh in? Been running TSM (ADSM) more than 10 years, more than 20 TSM servers, DB sizes from 6 GB to 250 GB and

Re: TSM Database Reorg

2006-08-31 Thread Jonathan Siegle
John Bremer said the following on 8/31/06 10:35 AM: [TSM database reorganization] recommended. Problem is there is another dba up there, who has some TSM experience, who says she used to do it painlessly. Anyone want to weigh in? Been running TSM (ADSM) more than 10 years, more

Re: TSM Database Reorg

2006-08-31 Thread fred johanson
How long did it take? At 10:52 AM 8/31/2006 -0400, you wrote: John Bremer said the following on 8/31/06 10:35 AM: [TSM database reorganization] recommended. Problem is there is another dba up there, who has some TSM experience, who says she used to do it painlessly. Anyone want to

Re: TSM Database Reorg

2006-08-31 Thread jsiegle
It took 4 days to finish. fred johanson wrote: How long did it take? At 10:52 AM 8/31/2006 -0400, you wrote: John Bremer said the following on 8/31/06 10:35 AM: [TSM database reorganization] recommended. Problem is there is another dba up there, who has some TSM experience, who

Re: TSM Database Reorg

2006-08-31 Thread Remco Post
Whitlock, Brett wrote: 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? Ok, db reorg is absolutely useless. Just don't, it's not worth the effort,

Re: TSM Database Reorg

2006-08-31 Thread David Longo
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-4305 PH 321.434.5536 Pager 321.634.8230 Fax:321.434.5509 [EMAIL PROTECTED]

Re: TSM Database Reorg

2006-08-31 Thread jsiegle
David Longo wrote: How big is that DB? This thing really works still? tsm: DATAKEEP.CAC.PSU.EDUq db Available Assigned Maximum MaximumPage Total Used Pct Max. Space Capacity Extension ReductionSizeUsable Pages Util Pct (MB) (MB) (MB)

Re: TSM Database Reorg

2006-08-31 Thread Gerald
. This was seven years ago but it worked. Terry McColgan -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Jurjen Oskam Sent: Thursday, August 31, 2006 2:46 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: TSM Database Reorg On Wed, Aug 30, 2006 at 03:32:44PM -0500

TSM Database Reorg

2006-08-30 Thread Whitlock, Brett
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?

Re: TSM Database Reorg

2006-08-30 Thread Jurjen Oskam
On Wed, Aug 30, 2006 at 03:12:51PM -0500, Whitlock, Brett wrote: 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? The general consensus here is that it almost always

Re: TSM Database Reorg

2006-08-30 Thread Maurizio Teruzzi
Hello guys, I will be great if this is possible... on current TSM DB model Ciao Maurizio Jurjen Oskam wrote: On Wed, Aug 30, 2006 at 03:12:51PM -0500, Whitlock, Brett wrote: I have a dba who is recommending I do a regularly scheduled database reorg (ie weekly). Anyone doing this? Can you

Re: TSM Database Reorg

2006-08-30 Thread Whitlock, Brett
-Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Jurjen Oskam Sent: Wednesday, August 30, 2006 3:21 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TSM Database Reorg On Wed, Aug 30, 2006 at 03:12:51PM -0500, Whitlock, Brett wrote: I have a dba

Re: TSM Database Reorg

2006-08-30 Thread Whitlock, Brett
I forgot to say that we are running 5.3.3 on Windows. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Maurizio Teruzzi Sent: Wednesday, August 30, 2006 3:32 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TSM Database Reorg Hello guys, I