Re: DB size and expiration

2009-07-01 Thread Markus Engelhard
Dear Duane, we currently face the same problem, as we had to expand one of our databases beyond the limit we had set and cannot shrink it now. Short of taking the System offline for dump and load of the database, we are going to restore the database to another TSM instance and do the dump and load

Re: DB size and expiration

2009-07-01 Thread Huebner,Andy,FORT WORTH,IT
I am not sure shrinking the amount of disk space used by the DB will be worth the time. TSM will use the pages in the DB, even if they are not at the end. You will still have to add new disks at the same point in the future. Andy Huebner -Original Message- From: ADSM: Dist Stor Manage

Re: DB size and expiration

2009-07-01 Thread Shawn Drew
Provide a "q db f=d" output. Also, might want to do a "ESTimate DBREorgstats" for more information. But yes, most likely an unloaddb, loaddb is your only option (other than upgrading to 6.1, which is supposed to let you optimize while running) Regards, Shawn _

Re: DB size for recovery purposes

2007-12-12 Thread Ryan Miller
The answer is yes, the exact why however, will have to be answered by someone else. I believe it has to do with the DB design and TSM will only recognize the actual last recorded DB size, not the last utilized size. Ryan Miller Storage Solutions Engineer MSI Systems Integrators 2600 Westown Pa

Re: DB size for recovery purposes

2007-12-12 Thread Kelly Lipp
Yes. Just because is probably the best answer. It has to do with the way the db structure is laid out originally. If you were to reduce the database on the original system before you do the backup, then you could restore into a smaller database... Kelly J. Lipp VP Manufacturing & CTO STORServ

Re: DB size problem

2006-10-19 Thread Richard Sims
On Oct 19, 2006, at 4:17 AM, Szymon Kacprzak wrote: I have problem with DB size. Now it's 114 GB (with 18 Windows Server clients). My policy parameters are: Version Data Exist: Nolimit Version Data Deleted: Nolimit Retain Extra Ver.: 7 Retain Only Ver.: 7 Your backup retentions are tiny, so o

Re: DB size problem

2006-10-19 Thread Bos, Karel
Hi, You have to go into unloading and reloading the database. Regards, Karel -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Szymon Kacprzak Sent: donderdag 19 oktober 2006 10:18 To: ADSM-L@VM.MARIST.EDU Subject: DB size problem Wiadomosc prz

Re: DB size

2003-02-20 Thread Stapleton, Mark
From: William Rosette [mailto:[EMAIL PROTECTED]] > I currently have a 60GB TSM database mirrored for a total of > 120GB (also including Recovery logs 5 GB each 10GB total). I > have heard that this is big for 1 Server and would like to > ask if other TSMers split their Servers and what is the

Re: DB size

2003-02-20 Thread William Rosette
I currently have a 60GB TSM database mirrored for a total of 120GB (also including Recovery logs 5 GB each 10GB total). I have heard that this is big for 1 Server and would like to ask if other TSMers split their Servers and what is the rule of thumb. It took 8 hours to restore DB at DR vs the 4

Re: DB Size growth

2001-06-05 Thread Gill, Geoffrey L.
>> Recently we have gone through a Server Consolidation >> on 2 of our servers. >> During this consolidation effort I had noticed that >> our DB size has grown >> from a concerning value of 64.7% to an alarming >> 72.5% over a period of about >> 1 week. Have you taken into account your backup cop

Re: DB Size growth

2001-06-05 Thread Angela Hughes
It depends on how much data was on the old servers and that now appears on the consolidated server as well as how much capacity you have assigned for your db. My experience as a consultant in dealing with this issue is that there is either a lot of data on the new server or there isn't a lot of c