| |
|
If this is your first visit, be sure to check out the FAQ by clicking the link above.
You may have to register before you can post: click the register link above to proceed.
To start viewing messages, select the forum that you want to visit from the selection below.
|
 |
08-11-04, 15:17
|
|
Registered User
|
|
Join Date: Aug 2004
Posts: 5
|
|
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
|
|
08-11-04, 18:54
|
|
Super Moderator
|
|
Join Date: Aug 2001
Location: UK
Posts: 4,534
|
|
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.
|
|
08-12-04, 15:29
|
|
Registered User
|
|
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
|
|
08-12-04, 16:21
|
|
Super Moderator
|
|
Join Date: Aug 2001
Location: UK
Posts: 4,534
|
|
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.
|
|
08-12-04, 16:39
|
|
Registered User
|
|
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
|
|
08-12-04, 16:55
|
|
Super Moderator
|
|
Join Date: Aug 2001
Location: UK
Posts: 4,534
|
|
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.
|
|
08-16-04, 08:51
|
|
Registered User
|
|
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 ?
|
|
| Thread Tools |
Search this Thread |
|
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|
dBforums
>
db2relocatedb problem
