Results 1 to 10 of 10
  1. #1
    Join Date
    Oct 2003
    Posts
    28

    Question Unanswered: Db2 Udb Unix Aix

    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

  2. #2
    Join Date
    Jul 2003
    Location
    Austin, TX, USA
    Posts
    278

    Logging Mode.

    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.
    HTH

    Nitin

    Ask the experienced rather than the learned

  3. #3
    Join Date
    Oct 2003
    Posts
    28

    Thumbs up Db2 Udb Unix Aix / Move Tablespace Dms

    Thanks for your reply

    ours databases are in online logging (logretain) mode

    Bye

    Sidnet

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  5. #5
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    I do not know about AIX, But for UDB LUW you can use db2relocatedb to move tablespaces.

    Andy

  6. #6
    Join Date
    Oct 2003
    Posts
    28

    Wink How to move DMS tablespace into a new path directory

    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

  7. #7
    Join Date
    Mar 2004
    Posts
    448
    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

  8. #8
    Join Date
    Oct 2003
    Posts
    28

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

    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 ...

  9. #9
    Join Date
    Jul 2003
    Location
    Austin, TX, USA
    Posts
    278

    Basic Function.

    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.
    HTH

    Nitin

    Ask the experienced rather than the learned

  10. #10
    Join Date
    Mar 2004
    Posts
    448
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •