Backing up the OpenPages database during a migration to 9.2.x (Db2)

Applies to: On premises

Create a backup of the OpenPages® database.

Before you begin

If Db2® Text Search is enabled in your source environment, drop the text search indexes and disable Db2 Text Search before you back up the database.

About this task

Use the utilities that are provided with IBM® Db2 to back up the database.

Note: You can back up the database by using other methods. For example, you can use a combination of full and incremental backups. If you want to use an alternative method, it is critical that you have the necessary skills available within your organization to complete all aspects of the backup and restore activity.

For information about developing a database backup and restore strategy, see Backup overview in the Db2 documentation.

For more information about the commands that are used in this procedure, see the IBM Db2 documentation.

Procedure

  1. Make sure that no OpenPages processes are running, such as object reset jobs.
  2. Shut down all OpenPages components: application servers (admin and non-admin), reporting servers (active and standby), and the search server.
    For more information, see Starting and stopping servers.
  3. Open a command or shell window and connect to the OpenPages database as the database instance owner.

    For Windows users only, you must use the db2cmd command in the Command Prompt window to initialize the Db2 command line processor (CLP).

  4. Go to the sqllib directory.
  5. Force any applications from the database.
    Run the following command:
    db2 force application all
  6. Deactivate the database.
    Run the following command:
    db2 deactivate database <db_name>
  7. Create a directory in which to store the backup.
  8. Do an offline backup by using the db2 backup command. 
    db2 backup database <db_name> to <backup_directory>
    Example: 
    db2 backup database opx to /home/db2inst1/backup
  9. Copy the backup file to the instance owner account on the target OpenPages database server.

What to do next

If you created a separate database for Cognos, back up the Cognos database.