Dave
This is the only way to do it today without exporting and reloading your
data. Note that the redirected restore will require enough space to go to
the current high water mark for each tablespace so you should double check
how much space you need beforehand.
Regards,
_____________________________________________
Dale M. McInnis IBM Toronto Lab
Senior Technical Manager, DB2 UDB Backup, Data Protection and Recovery
Email: [EMAIL PROTECTED]
Phone: (416) 448-2397, Fax: (416) 448-4414, T/L: 778-2397
|--------+-------------------------------->
| | "David Bargeron" |
| | <David.Bargeron@btinte|
| | rnet.com> |
| | Sent by: |
| | [EMAIL PROTECTED]|
| | a.best.com |
| | |
| | |
| | 05/30/2001 01:39 PM |
| | Please respond to |
| | db2eug |
| | |
|--------+-------------------------------->
>-----------------------------------------------------------------------------------------------------------|
|
|
| To: [EMAIL PROTECTED]
|
| cc:
|
| Subject: DB2EUG: UDB Downsize
|
|
|
|
|
>-----------------------------------------------------------------------------------------------------------|
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
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
