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.
Author: Jack Vamvas
Leave a Reply