Results 1 to 7 of 7
  1. #1
    Join Date
    Aug 2004
    Posts
    5

    Angry Unanswered: db2relocatedb problem

    Hi - I am having a problem with db2relocatedb from one server to another.

    OS - AIX 4.3
    Database - UDB 7.1

    Every night, we copied the containers to another server and run the db2relocatedb. It has been working fine, until I added an additional container to one of the exisitng tablespace. After I added the additional container to one of the tablespace, I am getting the following error:

    ERROR: Invalid path "/db2dat/topb/topp45/debti.f2

    Here is my the file that I am using. I didn't include all the cont_path, just the path that is giving me a problem.

    DB_NAME=TOPP
    DB_PATH=/db2dat/topp,/db2dat/topb
    INSTANCE=db2p,db2pb
    CONT_PATH=/db2dat/topp/topp45/debti.f2,/db2dat/topb/topb45/debti.f2

    Do I need to do anything special after I added an additional container to an existing tablespace to make the relocatedb work ?

    Thank you

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    On the target, define a new container using the same command as the source db ...

    Then, there will be an additional container on target also, which can be 'relocated' as usual ...

    Please share with us how you manage to solve the problem

    HTH

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

  3. #3
    Join Date
    Jan 2004
    Location
    Tallahassee, FL, USA
    Posts
    96
    Is debti.f2 , debti.f2 container names ?

    don't specify file name , try as below




    DB_NAME=TOPP
    DB_PATH=/db2dat/topp,/db2dat/topb
    INSTANCE=db2p,db2pb
    CONT_PATH=/db2dat/topp/topp45,/db2dat/topb/topb45


    Let me know , if any issues

    Thank You
    Lekharaju Ennam
    Certified Oracle8i & DB UDB DBA
    Florida A&M University

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Lekharaju .. As per the article in Dev Domain
    http://www-106.ibm.com/developerwork...m-0407schlamb/ :

    Although the tool can be used to change the location of a table space container, it cannot be used to change the number of containers or the size of them (for DMS table spaces). A redirected restore is the only way to accomplish this.

    There I think the method you suggested may not work

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

  5. #5
    Join Date
    Jan 2004
    Location
    Tallahassee, FL, USA
    Posts
    96
    CONT_PATH=/db2dat/topp/topp45,/db2dat/topb/topb45
    here is he changing path of containers, I think doesn't matter no of containers

    in source & target

    in source /db2dat/topp/topp45/cont1
    /db2dat/topp/topp45/cont2

    db2relocatedb will move both file to

    target /db2dat/topb/topb45/cont1
    /db2dat/topb/topb45/cont2
    Lekharaju Ennam
    Certified Oracle8i & DB UDB DBA
    Florida A&M University

  6. #6
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Lekharaju, To the best of my understanding, for SMS TS, CONT_PATH is a directory and for DMS, it is either a file or rawdevice as the case may be ...

    I believe db2relocatedb alters the contents of SQLSPCS.1 and SQLSPCS.2, which are the only source for db2 to know the container information

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

  7. #7
    Join Date
    Aug 2004
    Posts
    5
    Sathyaram, Thank you for your reply. These are new tablespaces, and I have already ask the system admin to added the additional filesystem on the target server. The filesystems on the source and the target OS looks the same.

    I even try to do a restore of the entire database with a backup from the source and then use the db2relocatedb after the restore. The restore work fine, but I am still getting the same error after running the db2relocatedb.

    I am at a lost right now. Any help would greatly be appreciate ?

Posting Permissions

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