Rename a database

Planning Analytics on Cloud users can rename databases by using Planning Analytics Administration.

The rename process affects the database in the following ways:

  • The database name is changed in the user interface.
  • The database directory in the prod directory is renamed with the new name.

    If the directory rename cannot succeed, the whole process is canceled, any actions are reverted, and an error message is presented to the user.

  • The database name in the Planning Analytics Workspace configuration is updated to match the new name.
  • Any ACL files provided by customers are updated in the product repository if it includes the folder that was renamed.

Before you begin

You must open a support request to rename a Cognos Controller Financial Analytics Publisher (FAP) databases. You cannot rename a FAP databases using Planning Analytics Administration.

About this task

A database must be stopped before you can rename it. Plan your renaming for a time when you can stop the database if necessary.

When you specify the new database name, follow the same rules regarding special characters, character lengths, and other restrictions that are documented in the topic Create a database.

Procedure

  1. Log in to Planning Analytics Workspace as a member with the Administrator role.
  2. Click the Administration tile.
  3. Click the Databases tile.
  4. Click the database that you want to rename on the Databases pane.
  5. On the database details pane, check the database status. If the status is Started, click Stop.

    The database must be stopped before it can be renamed. It might take a few minutes to stop the database. When the process is complete, the database icon changes to stopped Stopped database icon.

  6. Click Edit link on the database details pane.
  7. Enter a new name for the database, then click the Save .

    The rename process might take several minutes to complete. When it's finished, the new database name is displayed on the Databases pane.

What to do next

Any existing content, such as rules or processes, that references the database name must be updated to refer to the new database name.