You have to right a script that you should store using the Task Center.
The script can either add a new container or if you want to
extend/resize one, some or all the containers. Look at the alter
tablespace command.
Extending/resizing containers is preferable, gicen you have the
disk/file system space as you will generally get away from having to get
the rebalancer to launch, which happens wwhen you add a container.
Once you have the script, on the CC, select the tablespace you are
concerned with, RB click to get the drop down and choose Manage Storage.
This will lead you toset the rules for warnings and alarms on space
utilization and there you can choose to action the script you wrote.
HTH, Pierre.
Yasaswi Pulavarti wrote:
Hi Visu:
I understand everything you said, except what does, "and activate
action to run a script which add's containers". Are you saying that I
have to write a Perl, or Korn shell script and activate it? Or is
there an in build mechanism in the "Health Monitor" to take care of
this matter? Please explain.
Thanks,
Yasaswi
Vi*******@gmail.com (Visu) wrote in message news:<43**************************@posting.google. com>...
You could automate that by turning the alerts on (tablespace
utilization), and activate action to run a script which add's
containers.
It's self explaining if you look in health monitor. Hope the version
of the DB2 you use supports it.
GOODLUCK
Visu
ya*****@encfor.com (Yasaswi Pulavarti) wrote in message news:<aa**************************@posting.google. com>...
I have many DMS tablespaces which are filling up fast. Is there a way
to add, file containers automatically to those tablespaces? Or does
this require a perl or korn shell script to inspect the output of
"list tablespaces show detail" and use "alter tablespace .... " DDL?
Please help.
Thanks,
Yasaswi
--
Pierre Saint-Jacques - Reply to: sescons at attglobal dot net
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc.
