Issue in db2relocatedb [move tablespace cntainer to new volume ]

Toad for IBM DB2
1

I want to relocate tablespaces containers to a separate volume, I am using following procedure but unfortunately getting some error.

Method = db2relocatedb

  1. Configuration File
    $ cat relocatedb.cfg
    DB_NAME=FUNDAMO
    DB_PATH=/proddb
    INSTANCE=db2inst1
    STORAGE_PATH=/proddb/FUNDAMO/db2inst1/NODE0000/FUNDAMO/T0000005/C0000000.USR,/syslogs/FUNDAMO/db2inst1/NODE0000/FUNDAMO/T0000005/C0000000.USR

  2. Steps

  3. shutdown database

  4. move container to new volume

  5. $ db2relocatedb -f relocatedb.cfg

DBT1006N The file/device “/syslogs/FUNDAMO/db2inst1/NODE0000/FUNDAMO/T0000005/C0000000.USR/db2inst1” could not be opened.

Following is the releven information.

$ db2 list active databases

** Active Databases**

Database name = FUNDAMO
Applications connected currently = 0
Database path = /proddb/db2inst1/NODE0000/SQL00001/

$ db2 list tablespace containers for 5

Tablespace Containers for Tablespace 5

** Container ID = 0**
** Name = /proddb/FUNDAMO/db2inst1/NODE0000/FUNDAMO/T0000005/C0000000.USR**
** Type = File**

** Tablespace ID = 5**
** Name = ALFPF**
** Type = Database managed space**
** Contents = All permanent data. Regular table space.**
** State = 0x4000**
** Detailed explanation:**
** Offline**

2

I would suggest to make sure that you are specifying paths in your STORAGE_PATH variable and not files.

I also recommend that you review the information about the db2relocatedb command and config file contents at:

pic.dhe.ibm.com/…/r0004500.html

Hope this helps

3

Hi Jeff,

I have applied recommended changes in
configuration file but still facing following error. Please advice.

$ db2relocatedb -f relocatedb.cfg

DBT1006N The file/device “/syslogs/FUNDAMO/db2inst1/NODE0000/FUNDAMO/T0000005/*/db2inst1AT”
could not be opened.

Configuration File

$ cat relocatedb.cfg

DB_NAME=FUNDAMO

DB_PATH=/proddb

INSTANCE=db2inst1

NODENUM=0

STORAGE_PATH=/proddb/FUNDAMO/db2inst1/NODE0000/FUNDAMO/T0000005/,/syslogs/FUNDAMO/db2inst1/NODE0000/FUNDAMO/T0000005/

Regards

Abul Farhan

923002354346

From:
“Jeff Podlasek”
bounce-Jeff_Podlasek@toadworld.com

To:
ibmdb2@toadworld.com,

Date:
31-08-2013 00:08

Subject:
RE: [Toad World

  • IBM DB2 Discussion Forum] Issue in db2relocatedb [move tablespace cntainer
    to new volume ]

RE:
Issue in db2relocatedb [move tablespace cntainer to new volume ]

Reply by Jeff Podlasek
I would suggest to make sure that you are
specifying paths in your STORAGE_PATH variable and not files.

I also ecommend that you review the information
about the db2relocatedb command and config file contents at:

pic.dhe.ibm.com/…/r0004500.html

Hope this helps

To reply, please reply-all to
this email.

Stop
receiving emails
on this subject.

Or Unsubscribe
from IBM DB2 notifications
altogether.

Toad World - IBM DB2 Discussion Forum

Flag
this post as spam/abuse.

4

Are you sure your path is valid with an asterisk in it?

Just to prove that the paths are valid, I suggest you open a command line and cd into those paths.

5

These are great, thanks