environment details : db2 9.7.4 on linux OS

i need an urgent help regarding the alteration of the tablespace *userspace1*
the mount in which the user space is present is full and i would want to add an other container to it which is on a different mount point and which has morespace.
but i am unable to do the same

i tried to user the command
alter tablespace userspace1
add(file,'newcontainername',2000);

but this command works for the dms tablespaces but not on this sms.

plz help..!!!

im not 100% sure about mi answer but i think that you cannot add containers to a SMS tablespace, it has to be a DMS tablespace.

not possible
you have to create a new ts on a new location and move some tables to this ts
in non-dev/test environment it is always better to use dms also for maintenance reasons

so what would be the other option i could do immediately to the get application running,without dropping and recreating the table??

moving the tables means droping and recreating them right??

you could copy the table with load cursor to a new table and finally rename the tables
but be carefull that in the mean time no rows have been added/changed/..

you could try to reorg some tables using a tempspace to free some space lowing the HWM.

You can use the new "admin_move_table" IBM DB2 9.7 for Linux, UNIX and Windows Information Center to move your tables to another tablespace on-the-fly.
Maybe you must drop your FK contraints first and rebuild them aferwards.
Does that work on SMS tablespaces?????

High water mark in an SMS?

i just want to explain that he could free some space in the tbs.

Copy the SMS container to the new location and use db2relocatedb

Cannot be done online, though

Cheers
Sathyaram