Eric Winters wrote: > Dear All, > > Cannot seem to find a way to delete db volumes in a lightly used TSM db. > > Environment is as follows; > > TSM Server 5.3 on Windows. > > q 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 > --------- -------- --------- --------- ------- > --------- --------- ----- ----- > 81,000 74,684 6,316 0 > 4,096 19,119,104 6,606,896 34.6 34.6 > > I have 8x10,000 MB dbvolumes - I'd like to reduce this to perhaps 4x10,000 > MB volumes. > When running "delete dbvolume" I get the following (expected) message > ANR2434E DELETE DBVOLUME: Insufficient space on other database volumes to > delete volume D:\path\to\dbvolume > ANS8001I Return code 7.
You max reduction is 0, so all of your 65.4% empty database space is consumed by database fragmentation. Unload/load is the only way to solve this (afaik). It's not that bad to do an unload/load if your database has lost a lot of weight or for some other reason you are sure you can permanently reduce the db. Some fragmentation is quite common, and in some cases you do have a decent excuse to defragment. Yours may be one. After you did the Load, you may be able to do a reduce db by the desired amount, and delete the volumes. > > Now I understand from Richard's excellent Quickfacts that db volumes can > become fragmented - and that the 'maximum extension' refers to contiguous > space at the end of the db - which needs to be large enough to accommodate > the data deleted from dbvolumes. To create a larger 'maximum extension' > I've defined additonal 20 GB of dbvolumes - but after deleting 2x10,000 db > volumes with data on them I find the 'maximum extension' has dropped by > exactly 20,000 - so I haven't actually reduced my total db size at all. I > had naively hoped that the effect of deleting db volumes and forcing that > data onto other volumes would have defragemented the data on that volume. > > So what are my alternatives? I really don't want to unload this db and I > doubt defragmentation be achieved via a db backup/restore. Is there a > better way? > > Thanks for your suggestions people. > > Regards, > > Eric Winters > Sydney > Australia -- Met vriendelijke groeten, Remco Post SARA - Reken- en Netwerkdiensten http://www.sara.nl High Performance Computing Tel. +31 20 592 3000 Fax. +31 20 668 3167 "I really didn't foresee the Internet. But then, neither did the computer industry. Not that that tells us very much of course - the computer industry didn't even foresee that the century was going to end." -- Douglas Adams
