Re: Shrink ITSM-DB

On Wed, Jan 05, 2005 at 11:48:25AM -0500, Richard Sims wrote:
> On Jan 5, 2005, at 10:54 AM, Hans-Dieter Kutz wrote:
>
> >Hey out there,
> >is there any other possibility than unloading the TSM-DB to "shrink"
> >the dbvol?
>
> Reorganizing the TSM database is a complex kludge which utilizes a
> utility classified as a Salvage utility, and subjects your server to
> considerable downtime. The process may also uncover dormant problems in
> your database which can result in further complexities, time, and
> possible data jeopardy.
>
> How about posting the big picture of what you are overall trying to
> achieve? We can collectively advise better where overall goals are
> defined.
>
>     Richard Sims
OK. Lets Picture it:
<snip>
TSM: Storage Management Server for AIX-RS/6000 - Version 5, Release 1, Level 8.0

# query db

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
--------- -------- --------- --------- ------- --------- --------- ----- -----
    7.900    4.100     3.800       292   4.096 1.049.600   973.857  92,8  92,8

# query log

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
--------- -------- --------- --------- ------- --------- --------- ----- -----
    3.952    3.952         0     3.832   4.096 1.011.200    29.496   2,9   2,9

# q logvol f=d
Volume Name (Copy 1): /usr/tivoli/tsm/server/log/log1.dsm
         Copy Status: Sync'd
Volume Name (Copy 2): /usr/tivoli/tsm/server/logcopy/log1copy.dsm
         Copy Status: Sync'd
Volume Name (Copy 3):
         Copy Status: Undefined
Available Space (MB): 3.952
Allocated Space (MB): 3.952
     Free Space (MB): 0

I want to shrink the db (92,8% Util). So would do the following steps:
1. Backup DB (3494/3590 Drives)
2. Backup DB to filesystem (already defined devclass for that)
3. Backup devconfig and volhist
4. dsmserv unloaddb devclass=DBBACK-DC
5. dsmserv loadformat 1 FILE:"/tsmexport/bin/logvol.txt" 1 
FILE:"/tsmexport/bin/d
6. dsmserv LOADDB DEVclass=DBBACK-DC 
VOLumenames="/tsmexport/vol1","/tsmexport/vol2",...

Then my knowledge stops.
Do I have to restore the devconfig and the volhist? If so, how?
Are there any other important things that are not mentioned?
<snip>

Cheers,
ku

--
Princess Leia:
        I'll be back.