Installing only the OpenPages applications by using Docker

Applies to: On premises

If you already have an IBM® Db2® instance, you can restore the OpenPages® and Cognos® databases to your Db2 instance, and then install the OpenPages applications by using Docker.

Procedure

  1. Load the OpenPages Docker containers.
    1. On Microsoft Windows operating systems, ensure that the HOSTNAME variable is set on both Docker instances.

      In a PowerShell terminal, run the following command:

      echo $env:HOSTNAME

      If the value is not set, you can set it in the terminal window or to the .env file that you use in step 4 below.

    2. On all operating systems, on the Docker instance where you want to run the application containers, copy the following downloaded files to the directory:
      • op<version>.tar.gz
      • app.env
      • dc-app-db2.yml
    3. On all operating systems, in a terminal window, go to the directory where you copied the files, and run the following command:

      docker load -i op<version>.tar.gz

      The command can take some time to run because it loads all of the software and the database content.

  2. Create a backup of the OpenPages and Cognos databases from the Docker container.
    1. Run the following command to create a backup of the OpenPages database to a /tmp directory: 
      docker run --rm -v /tmp:/tmp ip-op-grc-docker-virtual.artifactory.swg-devops.com/op/opdbdata_db2:<opversion> sh -c 'cp /home/db2inst1/backup/*.gz /tmp/'
    2. Run the following command to create a backup of the Cognos database to a /tmp directory: 
      docker run --rm -v /tmp:/tmp ip-op-grc-docker-virtual.artifactory.swg-devops.com/op/opreportdbdata_db2:<opversion> sh -c 'cp /home/db2inst1/backup/*.gz /tmp/'
  3. Restore the databases to your Db2 instance.
    1. Copy the two *.gz files to the computer where Db2 is installed.
    2. Run the following command to restore the databases:

      db2 restore database <database alias> from <backup directory>

      You must run the command for the OpenPages database and the Cognos database. Ensure that the Db2 database instance that you restore the OpenPages database to has Oracle compatibility enabled.

  4. Start the OpenPages application servers.
    1. On the computer where you copied the downloaded files, rename app.env to .env.
    2. Open the .env file in a text editor.
    3. Change the OPDB_* values to the database connection parameters for the OpenPages database.
    4. Change the OPREPORTDB_* values to the database connection parameters for the Cognos database.
    5. Ensure that the OPVER variable value in the .env file matches the version of OpenPages that you are installing.
    6. Save and close the file.
    7. Run the following command:

      docker compose -f dc-app-db2.yml up -d

    Starting the application can take some time. Wait at least 10 minutes before you can access the application.

    After the application starts, you can access it at https://<hostname_for_application_server>:10111/

    <hostname_for_application_server> is the computer where you installed the application server container.

    For information about the log in credentials, see the cheatsheet_deployment_info.txt text file that is provided with the installation files.

    Note: The Cognos data source sign-on credentials are not updated by the container startup. You must manually update the sign-on credentials after the Cognos server starts. For more information, see Modifying a sign-on in the Cognos documentation.