To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Where is the missing 38GB?
On Dec 5, 2008, at 16:55 , Phillip Burgess wrote:
From my experience, TSM is not capable of re-using the space once it
becomes fragmented.
TSM will reuse empty pages, it will not reuse empty space in a
partially used page
:45 PM
Please respond to
ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU
To
ADSM-L@VM.MARIST.EDU
cc
Subject
Re: [ADSM-L] Where is the missing 38GB?
.
The missing 38GB is just simply gone. Wave it goodbye. Disks are cheap -
find something more expensive to worry about.
You will get it back
is the missing 38GB?
.
The missing 38GB is just simply gone. Wave it goodbye. Disks are cheap -
find something more expensive to worry about.
You will get it back, though, if you ever refill this database with
data. But wait, you say, won't the new data be fragmented too? Sure,
just like it would
@VM.MARIST.EDU
To
ADSM-L@VM.MARIST.EDU
cc
Subject
Re: [ADSM-L] Where is the missing 38GB?
From my experience, TSM is not capable of re-using the space once it
becomes fragmented.
I have worked on servers with 150GB databases reduced down to 50%
utilization after several large filespace
%, no option
left other than to export or reload the database
Phil
From: Roger Deschner [mailto:[EMAIL PROTECTED]
Sent: Thu 04/12/2008 22:41
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Where is the missing 38GB?
.
The missing 38GB is just simply gone. Wave
.
The missing 38GB is just simply gone. Wave it goodbye. Disks are cheap -
find something more expensive to worry about.
You will get it back, though, if you ever refill this database with
data. But wait, you say, won't the new data be fragmented too? Sure,
just like it would be if you started
On Dec 4, 2008, at 23:41 , Roger Deschner wrote:
.
The missing 38GB is just simply gone. Wave it goodbye. Disks are
cheap -
find something more expensive to worry about.
ok, I'll have to disagree here. an empty db (and this one is) should
not have 100% fragmentation. And like my test server,
.
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Zoltan Forray/AC/VCU
Sent: Wednesday, December 03, 2008 3:09 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: Where is the missing 38GB?
9:08:28 AM TSMTEST : q db f=d
Available Space (MB): 56,336
I have a test TSM server (5.5.1) which is producing some strange DB
statistics.
**
*** --- Q DB F=D
**
Available Space (MB): 56,336
Assigned Capacity (MB): 53,264
On 02/12, Zoltan Forray/AC/VCU wrote:
I have a test TSM server (5.5.1) which is producing some strange DB
statistics.
**
*** --- Q DB F=D
**
Available Space (MB): 56,336
respond to
ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU
To
ADSM-L@VM.MARIST.EDU
cc
Subject
Re: [ADSM-L] Where is the missing 38GB?
On 02/12, Zoltan Forray/AC/VCU wrote:
I have a test TSM server (5.5.1) which is producing some strange DB
statistics
/VCU
Sent: Tuesday, December 02, 2008 9:44 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: Where is the missing 38GB?
12/2/2008 12:41:46 PM ANR0984I Process 1 for ESTIMATE DBREORG started in
the BACKGROUND at 12:41:46 PM.
12/2/2008 12:41:46 PM ANR1782W ESTIMATE DBREORG process 1 started -
server
performance
: [ADSM-L] Where is the missing 38GB?
The dreaded DSMSERV DUMPDB and DSMSERV LOADDB (not recommended)
DSMSERV LOADDB (Reload the database)
Use this command to reload a Tivoli Storage Manager database in optimal
order.
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL
12:58 PM
Please respond to
ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU
To
ADSM-L@VM.MARIST.EDU
cc
Subject
Re: [ADSM-L] Where is the missing 38GB?
I'm waiting for the firestorm of comments following this suggestions.
(Sitting back, waiting for fireworks.)
-Original Message-
From
I would try doing a full DB backup. Can you send q dbv output too?
[RC]
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Zoltan Forray/AC/VCU
Sent: Tuesday, December 02, 2008 9:20 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Where is the missing
-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Where is the missing 38GB?
Or better yet, I could just reformat everything, since this is a test
system.
I just want to know why..
Yeah, yeah, I realize V6.1 with DB2 will fix all DB
issues.;
Schneider, Jim [EMAIL
: Dist Stor Manager ADSM-L@VM.MARIST.EDU
To
ADSM-L@VM.MARIST.EDU
cc
Subject
Re: [ADSM-L] Where is the missing 38GB?
I would try doing a full DB backup. Can you send q dbv output too?
[RC]
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Zoltan
: Dist Stor Manager ADSM-L@VM.MARIST.EDU
12/02/2008 01:21 PM
Please respond to
ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU
To
ADSM-L@VM.MARIST.EDU
cc
Subject
Re: [ADSM-L] Where is the missing 38GB?
If you have a habit of deleting filespaces on this test box, that would
explain it.
You'd
, December 02, 2008 1:04 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Where is the missing 38GB?
No change...
12/2/2008 1:53:43 PM ANR2017I Administrator ZFORRAY issued command: BACKUP
DB dev=FILEDEVCLASS typ=Full scr=Yes
12/2/2008 1:54:49 PM ANR0984I Process 2 for DATABASE BACKUP
,IT [EMAIL PROTECTED]
Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU
12/02/2008 02:51 PM
Please respond to
ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU
To
ADSM-L@VM.MARIST.EDU
cc
Subject
Re: [ADSM-L] Where is the missing 38GB?
That is kind of interesting, of the 15,694 used DB pages, you
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf
Of Zoltan Forray/AC/VCU
This is a test server, previously decommission from use about 9-months
ago. I unloaded/reloaded the previous production DB to a new server.
Then
I went through and deleted everything.
Don't keep us in
@VM.MARIST.EDU
12/02/2008 03:13 PM
Please respond to
ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU
To
ADSM-L@VM.MARIST.EDU
cc
Subject
Re: [ADSM-L] Where is the missing 38GB?
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf
Of Zoltan Forray/AC/VCU
This is a test server
Too bad the database seems to be defective; otherwise you could use
the DELete DBVolume technique (see IBM Technote 1208572) to
progressively shift the db data around, with an added volume to get
things started.
Richard Sims
: Dist Stor Manager ADSM-L@VM.MARIST.EDU
To
ADSM-L@VM.MARIST.EDU
cc
Subject
Re: [ADSM-L] Where is the missing 38GB?
Too bad the database seems to be defective; otherwise you could use
the DELete DBVolume technique (see IBM Technote 1208572) to
progressively shift the db data around
On Dec 2, 2008, at 3:55 PM, Zoltan Forray/AC/VCU wrote:
I think I have tried that, before. I will play around some.
I thought for sure you would have some secret, hidden, magical auditdb
parm to fix this, Richard ;--))
Recall in the movie Labyrinth, there was a Bog of Eternal Stench. One
Ok, this is an almost empty database with a lot of fragmentation.
I'd say, from what I read in the thread, that an unload/load at this
point will remove a lot of fragmentation, even though the estimate
says nill.
The other option is to run an export server, reformat everything, and
then import
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Where is the missing 38GB?
Ok, this is an almost empty database with a lot of fragmentation.
I'd say, from what I read in the thread, that an unload/load at this
point will remove a lot of fragmentation, even though the estimate says
nill.
The other
27 matches
Mail list logo
