Changing database name references
If the database name (IBM® Db2®) or identifier (Oracle) changes, you need to update references to the database.
For example, if you have upgraded from an old database server to a new one, migrated from a non-RAC to a RAC environment, or are moving from a shared database environment to a stand-alone environment, then you must change several references on the IBM OpenPages® with Watson™ application and reporting servers to point to the new database instance.
Note:
If you changed the database server hostname, see the following topics:
- If you are using IBM Db2, see How to Change the Hostname of an IBM DB2 Database Server for OpenPages.
- If you are using Oracle, see How to Change the Hostname of an Oracle Database Server for OpenPages.
To change database references, you must take the following actions:
- If you are using IBM Db2, re-create the catalog entry for the OpenPages database, and then test the connection. You can see examples of the syntax in the following technote: How to Change the Hostname of an IBM DB2 Database Server for OpenPages.
- If you are using Oracle, see Testing the connection to the OpenPages database from the Oracle database client
- Modifying the data source connection URL
- Modify database references in the application configuration files
- Modify database connection references for the reporting server
Before you begin
Make sure that you have the following information:
- Administrative access to the following machines
and application:
- OpenPages application server
- OpenPages Cognos server
- IBM Cognos Analytics application
- OpenPages system account user and password
- For Oracle database environments, the Oracle System Identifier (SID) of the new database instance.
- For IBM Db2 database environments, the database name.