Hi Jerry,
The simple answer is that you can't do it without doing a database dump
and load. That's the bad news. The goods news is that with a database
with so little in it, the dump and load shouldn't take very long. I was
faced with having to do this to reduce a 12GB database to 8GB, but in
the time I thought about, the database usage grew so much that I decided
to leave it at 12 GB.
Trevor
-----Original Message-----
From: Jerry Lawson [SMTP:jlawson AT THEHARTFORD DOT COM]
Sent: Tuesday, 10 March 1998 2:56
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Data Base Reduction assistance required.... :-(
Date: March 9, 1998 Time: 9:40 AM
From: Jerry Lawson
The Hartford Insurance Group
(860) 547-2960 jlawson AT thehartford DOT com
------------------------------------------------------------------------
-----
-----
Another fine mess I've gotten myself into......
Another fine mess I've gotten myself into......
As an oldtimer on this list, I know this question has come up
before, but I
can't remember exactly when, so I thought I'd ask it again -
which means I
have to plead guilty to not paying good attention the first time
it was
asked. But based on what I do remember, this is perhaps the
most ridiculous
example of this problem that's been posted......
I am trying to reduce my DB, but it will not reduce past a
point, even though
the $%#@ thing is EMPTY! :-(
Here's what I did/have done.....
I needed to run a stress test of ADSM, so I borrowed an extra
3380 volume and
added a DB file out there. I started with a 96MB file that was
12% full,
then added an additional 1248 MB. All was well. I ran my
stress test. (For
the record, I defined a new Policy domain, added a new client,
and ran the
backups).
The test completed successfully. I then deleted the file spaces
that I had
backed up for the test, then deleted the client itself. I tried
to reduce
the DB, but it told me that I could only reduce 1176 MB. Since
I also was
doing a couple of other odds and ends at the same time, I
thought - must be
something else I did that wrote something out to the new DB vol.
So, I
cleaned up what I could, but that didn't help - I can't reduce
any further.
I then went after it with a club - I exported all of the defined
users, and
then deleted all of their associated file spaces, and when that
was done,
deleted their node definitions. Still I can not get the DB to
reduce
further.
I then went and deleted all of the policy domains associated
with the nodes,
(but I did leave "Standard"). Still can't reduce.
I then stopped and thought about it for a minute - what is using
the DB
space? Ah ha - it must be the activity log information. So I
changed the
log to 0 days retention. ADSM stopped logging, but didn't clean
up after
itself - it left all of the old log out there! This was last
Friday, so I
reset the log retention to 1 day, and left for the weekend -
assuming that
the normal expiration would clean everything up.
Alas - this was not to be - I came in this morning, and found
that I did
indeed have only 1 days worth of activity log, but I still can't
reduce th
elog any further. So, I sat back and tried to think of what
else was holding
the space ------ ah yes - must be some tape volume entries. So,
I went in
and did a delete volhist today command and cleaned this out.
But no success
here either - I still cannot reclaim any more space.
Here are the stats:
Current: Original
Available Space 1340 96
Assigned Capacity 164 96
Max extension 1176 0
Max reduction 0 0
Currently, utilization (and MAX utilization) is 0.5 % - only 222
pages out of
approximately 42K pages in the DB. The Q DB output also says
that I have
changed .87MB since the last backup, which is 100% of my DB!
By now you have to know my question - if I am using so little of
my DB, why
can't I reduce it any further? What can I do to get back to
96MB (short of
deleting the DB and doing disaster recovery)?
The guy who loaned me the DASD wants it back :-(((
BTW - Is it Monday?
------------------------------------------------------------------------
-----
-----
Jerry
Jerry
Insanity is doing the same thing over and over..and expecting
the results to
be different - Anon.
|