Hello all,

Could anyone tell me if there a quick and easy way to rename a DB2 8.1 db
(on AIX) or do I have to backup and restore?

I'm sure this has been asked before but nothing came up when I
searched.

Thanks,
Noel.

Have a look at db2relocatedb command ...

There is an option to rename a database

Cheers
Sathyaram

Brilliant Sathyaram, thanks for the info!

Noel,

You could uncatalog and then catalog your database with a different name.

eg for the db test created on the /db2dbs file system

uncatalog db test;
catalog db test on /db2dbs;