Hi everybody ...

How to move a DMS tablespace from an Filesystem location to another ..

For exemple
Tablespace TOTO on /database/GBDE//NOD0000/SQL00001/tabspace move to /database/GBDE/NOD0000/SQL00001/tabspace2 ?

Thanks for your reply

Sidnet

Hi,

Can you tell us whether ur database is in online logging (logretain) or offline mode.

That would help us to give a proper answer.

Thanks for your reply

ours databases are in online logging (logretain) mode

Bye

Sidnet

If you have logretain mode active, you can backup and restore the tablespaces using a redirected restore to the new file location. See the Command Reference manual for details.

I do not know about AIX, But for UDB LUW you can use db2relocatedb to move tablespaces.

Andy

And what about REORG TABLE (can we re-direct into a new Pathdirectory (new FILESYSTEM MOUNTED )

And what about EXPORT / IMPORT utilities ???
Can we specifie in an IMPORT Command to re-direct into a new Pathdirectory (new FILESYSTEM MOUNTED ) ??

for exemple :

Tablespace TOTO on /database/GBDE/NOD0000/SQL00001/tabspace move to /database/GBDE/NOD0000/SQL00001/tabspace2 ?

Thanks for your reply

Sidnet

I think you can add new containers and drop the old containers.
Db2 will automatically do the rebalancing.
Reorg has no option of moving the tables to another tablespace.

regards

Mujeeb

Hi !!
Thanks for your fast reply !!!

Is it possible dropping containers in DB2 Versionning
Database server = DB2/6000 7.2.4 ????

Thank for your reply

Sidnet ...

Hi Sidnet.

It's possible to add/drop/redefine containers as they are basic administration functions which a dba would use during his course of work.

Like Marcus_A advised you to use the Command Reference manual for clarity, I would also suggest that you start reading the Admin guide or buy a DB2 Handbook which is easily available and I am sure they will be of great help to you in solving such doubts.

Most of the part of 7a are relevant to security. Also it replaces 7 fixpak.
fixpak 7 made a major change in database, moving from 8.x to 8.2.
I got this same advice from IBM back two years to wait and don't move
very fast on production environment under these circumstances.

regards

Mujeeb