I have a 4-partition Data Warehouse on AIX 5.3 in which one tablespace
is approaching it's size limit ( 16k pagesize ).
The tablespace is defined across all partitions.
As a solution, I'd like to add another partition and I'd like to know if
my reasoning is correct.

I first make the required entries in the /etc/services file and modify
the db2nodes.cfg for the new partition

db2 " alter nodegroup NGRP_ODS_AWP add nodes (4) like node 3 "

Where is db2 going to create the containers 'like node 3' ? Does it
use the same path as node3 except for the NODE000X element ?
I'm assuming I should create the new filesystem NODE0004 before issuing
the command. Will the containers be the same size as NODE0003 ?

After this command completes I assume I must issue the redistribute
nodegroup command to balance the data across the partitions.

db2 "redistribute database partition group NGRP_ODS_AWP add
dbpartitionnum 4"

While this command is running is everything locked or can users access
the system ?

Thanks for any comments or suggestions


DB2 & UDB email list listserv db2-l LazyDBA home page