Results 1 to 4 of 4
  1. #1
    Join Date
    May 2004
    Posts
    8

    Question Unanswered: How to rename a database?

    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.

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Have a look at db2relocatedb command ...

    There is an option to rename a database

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    May 2004
    Posts
    8

    Smile

    Brilliant Sathyaram, thanks for the info!

  4. #4
    Join Date
    Jun 2002
    Posts
    7

    How about an Alias

    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;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •