Catalog the database and rename database

09 August,2011 by Tom Collins

Use the uncatalog \ catalog of a database to rename a database. An alternative to the db2relocatedb method.

If this is an option,uncatalog the db and then catalog it with a
new alias:

$ db2 create db mydb
$ db2 uncatalog db mydb
$ db2 catalog db mydb as a_new_name

The database name name remains the same . The name used with the CONNECT statement changes. The application can use the new alias to connect.

Related Posts

Rename a DB2 database

Author: Jack Vamvas(
Author: Rambler(


Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.


Post a comment on Catalog the database and rename database

Comments are moderated, and will not appear until the author has approved them. | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright