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.