"Luc Le Blanc" <ll******@cam.org> wrote in message
news:40***************@cam.org...
Under UDB 7.2 for OS/2, how can I determine the % of used space in a DMS
container (preferably via the CLP interface, so I can script the command
with REXX)? At what level should I go about adding a containter to the
userspace?
You can't determine the amount of free space in a container -- you can only
see this information at the tablespace level.
As DB2 allocates space in containers on a round-robin basis, and assuming
your workload is uniform, then %free on the tablespace will mean that
roughly each containers will have the same %free.
The threshold at which to add a new container depends on how critical your
application is and how quickly space is being added.
--
Matt Emmerton