Search dba-db2.com
*Use the Comments section for questions
Daily & Exclusive Content
Recent Posts
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
Author: Jack Vamvas(http://www.dba-db2.com)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
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.
dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright
Posted by: |