Hi,



OS : AIX 32 Bit

DB2 V8.2 Single Partition

All SMS Tablespace



As AIX 32 bit support maximum 1 TB for one file system and now file system is about to reach 1TB?

so what should I do??

we can not add container in sms tablespace...



Please suggest approch?



Regards

Pawan Kumar

Do you have only one tablespace?

Andy

no more than one tablespace but all are SMS

Look here:

DB2 Universal Database

Andy

but for this need a long down time?

Your only solution is to move some of the data to another file system. The quickest way I know is the db2relocatedb command. To use it you will have to do the following:

1) kick out the users and quiesce the instance (this will prevent anyone getting in while you perform the maintenance)
2) copy some of the tablespaces to a new file system. The amount of time this takes determines how long you will be down.
3) run the db2relocatedb command.
4) connect to the database and query some of the data you moved.
5) if all is working well, delete the tablespaces you copied from
6) unquiesce the instance and let users back in.

Before you start any of this you should determine which tablespaces you want to move and where. Then you setup the db2relocatedb config file.

Andy

My crystal ball telling me it will be longer if you do not do anything.

You can ask your admin to add more path/drives. Create new tbs on them and start moving your table to a new location. I am amazed that you only have one path for 1tb size db.

what about redirect of tablespaces?

will need much longer to restore, than using relocatedb.

one option you can use if you have enough disk space is to rediected restore the db, shut down the original db, ship logs to the new db and roll forward to end of logs and rename the new db to old db using relocatedb.

thanks to all... I try to do.