reduction of a TSM database

[RMGBELGIUM]

Hi all,

I have a TSM database with an assigned capacity of 11124 Mb, but with a max pct utilised 0.3 % , so that's about 33 Mb's.I've taken a dbbackup , and restored it to a testserver.We would like to reduce the size of the database to about 100 Mb, I've tried the reduce db command ( even the smallest reduce db ), and I get "Insufficient database space would be available following a reduction by the requested amount.".Anyone experienced this problem before, or knows an answer for this one?

thx in advance

Regards,

RMGBelgium

 

[ProbablyDown]

Can you post the results of QUERY DB?

 

[RMGBELGIUM]

Available Assigned Maximum Maximum Page Total Used Pct Max.
Space Capacity Extension Reduction Size Usable Pages Util Pct
(MB) (MB) (MB) (MB) (bytes) Pages Util
--------- -------- --------- --------- ------- --------- --------- ----- -----
12,000 11,124 876 0 4,096 2,847,744 7,914 0.3 0.3


grtz

R.

 

[ProbablyDown]

The reduce db command will only reduce the database up to the Maximum Reduction size. According to your "q db", that is 0. I'll keep looking though. I wonder if you can recreate the DB a smaller size and import the old database? But I know for a fact you cannot use reduce db. I'll keep looking.

-pd

 

[RMGBELGIUM]

I've read sth about the "reclaim" command , but that's in Tivoli 5.3.We've ordered the 5.3 , and I'll give that a try.Thx for the help already, I'll post the results of the reclaim when I try it out

rgrds,

R.

 

[ProbablyDown]

By the looks of things you are probably going to have to do and export/import. Your DB may be heavily fragmented. I would test this on your test server....

 

[Yrrk]

Look up UNLOADDB in your administrator's reference guide. Read this and LOADDB thoroughly and execute. This should solve your problem.

It's towards the end of the guide under appendix A (TSM utilities).