DB2EUG: UDB Downsize

[David Bargeron]

Dear List,   I need to resize downwards....   We (& the business !) over-estimated the sizing of a database (UDB 7.1 on NT 4.0); instead of being around 1 terabyte it will come to around 500gb, we would like to free up the extra 500gb SSA for other uses.   Our plan is to backup the existing database, resize the containers accordingly smaller with fewer disks per array and then do a redirected restore into the new containers. (The largest containers are for LOB data 6 disks per array + 1 for parity.)   Any comments would be greatly appreciated.   Thanks   Dave Bargeron LloydsTSB Bank United Kingdom