Results 1 to 8 of 8
  1. #1
    Join Date
    Feb 2004
    Location
    Copenhagen
    Posts
    220

    Red face Unanswered: Moving system tablespaces

    Hi guys - AIX 5.2. DB2 8.1.4

    I really need to move my syscatspace, userspace and tempspace.

    They're all located on /saswork/ in separate folders. (I was young and stupid)

    Can I move them by adding a new container and reorganising, and then
    remove the old containers? - or is there a special script/db2 function to take
    care of the problem.

    I sincerely hope that I won't have to do a redirected restore.

    Cheers
    Kristian K. Hansen
    Project Supervisor
    National Board of Health

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Have a look at db2relocatedb command ...

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Feb 2004
    Location
    Copenhagen
    Posts
    220

    Talking Nodenumber

    Thanks a lot Sathyaram,

    Great tool - one thing remains:

    DB_NAME=oldName,newName
    | DB_PATH=oldPath,newPath
    | INSTANCE=oldInst,newInst
    | NODENUM=nodeNumber
    | LOG_DIR=oldDirPath,newDirPath
    | CONT_PATH=oldContPath1,newContPath1
    | CONT_PATH=oldContPath2,newContPath2

    What do I specify for Nodenumber??, my db is cataloged as indirect
    and is not attached to any node (that I know of)

    Thank You!!
    Kristian K. Hansen
    Project Supervisor
    National Board of Health

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    NODENUM is only when you are using DPF ... (I assume you are not using DPF) Otherwise you don't need it ...
    Only DBNAME,DBPATH and INSTANCE are mandatory parms

    HTH

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  5. #5
    Join Date
    Mar 2004
    Posts
    6

    Question

    Hi:
    I want to move a database from one instance to another instance.
    Documentation says that I need to: Move the files in the directory /dbpath/FromInstance to |/dbpath/ToInstance.

    What files are they refering? Are they are refering to directory SQL0000X where x is database number?

    Can you give more details on how it can be done on AIX, ver 8.1


    [Great tool - one thing remains:

    DB_NAME=oldName,newName
    | DB_PATH=oldPath,newPath
    | INSTANCE=oldInst,newInst
    | NODENUM=nodeNumber
    | LOG_DIR=oldDirPath,newDirPath
    | CONT_PATH=oldContPath1,newContPath1
    | CONT_PATH=oldContPath2,newContPath2

    What do I specify for Nodenumber??, my db is cataloged as indirect
    and is not attached to any node (that I know of)

    Thank You!![/QUOTE]

  6. #6
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    I think you are right ... copy the SQL0000X directory to the new path ...

    Node number is optional (only valid for DPF) , so need not worry ...

    HTH

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  7. #7
    Join Date
    Feb 2002
    Posts
    96
    This utility looks great.

    Can we use this to spread the tablespace containers?
    eg, move
    from "/data/e1/prd'100000"
    to "/data/e1/prd'20000,/data/e2/prd'20000,/data/e3/prd'20000,/data/e4/prd'20000,/data/e5/prd'20000"

    Thanks in advance
    Prakash

  8. #8
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    AFAIK, it is not possible ...
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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