IBM Support

How to change the Database Name using db2relocatedb command?

Troubleshooting


Problem

How to change the database name using db2relocatedb command? db2relocatedb allows for the renaming of databases and switching the instance that a database belongs to

Resolving The Problem

Steps to rename the database:

    - Move the files from the old database to the new database name(Prerequisite for V10.1 and above versions)
    - Create the configuration file(relocate.cfg) with DB_NAME/DB_PATH/INSTANCE/NODENUM.
    - Alter any automatic storage paths to match the new database name.
    - Run the db2relocatedb command to change the database name.

Procedure:

    db2 list db directory:
     Database 1 entry:
     Database alias                       = PRODDB
     Database name                        = PRODDB
     Local database directory             = /home/db2v10
     Database release level               = f.00
     Comment                              =
     Directory entry type                 = Indirect
     Catalog database partition number    = 0
     Alternate server hostname            =
     Alternate server port number         =

Example:

- Moving the files from the old database to the new database name:

    mv /home/db2v10/db2v10/NODE0000/PRODDB /home/db2v10/db2v10/NODE0000/TESTDB

Note: This step is not required for DB2 9.7 and lower versions.

- Create the configuration file(in this example relocate.cfg was used but any file name can be used), and log the following entries to change the name of the database. In this example, we are changing the database name from PRODDB to TESTDB

    DB_NAME=PRODDB, TESTDB
    DB_PATH=/home/db2v10
    INSTANCE=db2v10
    NODENUM=0

- Once the configuration file is created, you must alter any automatic storage paths to match the new database name:

    rename /home/db2v10/db2v10/PRODDB /home/db2v10/db2v10/TESTDB

- Run the following db2relocatedb command to change the database name:

    db2relocatedb -f relocate.cfg
    Files and control structures were changed successfully.
    Database was catalogued successfully.
    DBT1000I  The tool completed successfully.

- Checking the change and connection:

    db2 list db directory:
     Database 1 entry:
     Database alias                       = TESTDB
     Database name                        = TESTDB
     Local database directory             = /home/db2v10
     Database release level               = f.00
     Comment                              =
     Directory entry type                 = Indirect
     Catalog database partition number    = 0
     Alternate server hostname            =
     Alternate server port number         =

    db2 connect to testdb
     Database Connection Information
     Database server        = DB2/LINUXX8664 10.1.2
     SQL authorization ID   = DB2V10
     Local database alias   = TESTDB

Related Information

[{"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Database Objects\/Config - Database","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.7;9.5;10.1;10.5","Edition":"Advanced Enterprise Server;Advanced Workgroup Server;Enterprise Server;Workgroup Server","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21673630