Re: Unload/LoadDB question

2004-01-06 Thread Stapleton, Mark
Run help define devclass and look for FILE. -- Mark Stapleton ([EMAIL PROTECTED]) -Original Message- From: Helen Tam [mailto:[EMAIL PROTECTED] Sent: Tue 1/6/2004 11:20 To: [EMAIL PROTECTED] Cc: Subject: Re: Unload/LoadDB question

Re: Unload/LoadDB question

2004-01-06 Thread French, Michael
hael French Savvis Communications IDS01 Santa Clara, CA (408)450-7812 -- desk (408)239-9913 -- mobile -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Helen Tam Sent: Tuesday, January 06, 2004 9:21 AM To: [EMAIL PROTECTED] Subject: Re: Unload/LoadD

Re: Unload/LoadDB question

2004-01-06 Thread Helen Tam
unload/load to a file-based device class. A tape dump will take *way* too long. -- Mark Stapleton ([EMAIL PROTECTED]) -Original Message- From: French, Michael [mailto:[EMAIL PROTECTED] Sent: Mon 1/5/2004 22:33 To: [EMAIL PROTECTED] Cc: Subject:Re: Unload/LoadDB question This was

Re: Unload/LoadDB question

2004-01-06 Thread Hart, Charles
arles -Original Message- From: Stapleton, Mark [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 9:14 AM To: [EMAIL PROTECTED] Subject: Re: Unload/LoadDB question Our experience has been that deleting old dbvols does not clean up the db like an unloaddb/loaddb does. By all means

Re: Unload/LoadDB question

2004-01-06 Thread Stapleton, Mark
, Michael [mailto:[EMAIL PROTECTED] Sent: Mon 1/5/2004 22:33 To: [EMAIL PROTECTED] Cc: Subject:Re: Unload/LoadDB question This was actually the first thing I tried. The DB was originally 177GB and 20% utilized. I reduced the DB by 50GB and then deleted volumes and mirrors. I tried to

Re: Unload/LoadDB question

2004-01-06 Thread Hart, Charles
ED] Subject: Re: Unload/LoadDB question This was actually the first thing I tried. The DB was originally 177GB and 20% utilized. I reduced the DB by 50GB and then deleted volumes and mirrors. I tried to shrink it again by another 35-40GB's, but it complained saying that it could not be reduce

Re: Unload/LoadDB question

2004-01-05 Thread French, Michael
1 38.0 8 2 -Original Message- From: ADSM: Dist Stor Manager on behalf of David Longo Sent: Mon 1/5/2004 8:02 PM To: [EMAIL PROTECTED] Cc: Subject:Re: Unload/LoadDB question Another way to do it is live. If your utilization is that low AND you hav

Re: Unload/LoadDB question

2004-01-05 Thread David Longo
Another way to do it is live. If your utilization is that low AND you have the DB spread over many volumes, say 10GB in size. Then do a "reduce DB 1", takes generally less than a minute. Then delete one of the dbvols that is that size. (delete it's mirrors first). Any data on the volume is

Unload/LoadDB question

2004-01-05 Thread French, Michael
System Info: Solaris 8 Sun E4500 w/ 4 processors & 4GB RAM TSM 5.1.8.1 TSM DB 119GB (37.1% utilized) I tried shrinking the DB down to 85GB and at 100GB, ran into the "your outta SQL table space" message. Guess it's time for an unloaddb/loaddb. Any ideas at all how long I can expect t

Re: Unload/Loaddb Question: what happens after a little time pass es

2002-05-29 Thread Scott, Brian
e: 248-265-4596 (8-365) * mailto:[EMAIL PROTECTED] -Original Message- From: Andrew Carlson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 7:31 AM To: [EMAIL PROTECTED] Subject: Unload/Loaddb Question: what happens after a little time passes I asked this before, but did not see an

Antwort: Unload/Loaddb Question: what happens after a little time passes

2002-05-28 Thread Gerhard Wolkerstorfer
EMAIL PROTECTED] An: [EMAIL PROTECTED] Kopie: (Blindkopie: Gerhard Wolkerstorfer/DEBIS/EDVG/AT) Thema:Unload/Loaddb Question: what happens after a little time passes I asked this before, but did not see an answer. I did a test unload/load on my test server, and saw a 44% reduction i

AW: Unload/Loaddb Question: what happens after a little time pass es

2002-05-28 Thread Rupp Thomas (Illwerke)
Hello from Austria, we saw a 30% reduction and much better EXPIRE INVENTORY performance. Size has increased by about 15% in 4 months and performance dropped a bit. I've got the impression that a reorg run once a year will be OK for us. Kind regards Thomas Rupp Vorarlberger Illwerke AG MAIL: [E

Unload/Loaddb Question: what happens after a little time passes

2002-05-28 Thread Andrew Carlson
I asked this before, but did not see an answer. I did a test unload/load on my test server, and saw a 44% reduction in the database. My selects ran with blazing speed, even on a much smaller box than the production box. What I wanted to know, from people that have seen significant reductions, ho