Updating to DB2 10.1 on a new installation of Blueworx Voice Response 6.1 for AIX Print

Modified on: Mon, 17 Feb, 2020 at 3:53 PM



Abstract


Updating Blueworx Voice Response (BVR) 6.1 for AIX to use DB2 10.1


Content


Updates in the BVR 6.1 for AIX fixpack 10 included changes to allow support for DB2 10.1 in addition to DB2 9.5.


Note: Although DB2 version 9.5 is going out of service in 2015, support will continue as a bundled product within BVR 6.1 for AIX. Any problems encountered with Blueworx Voice Response's use of DB2 9.5 will be covered under Blueworx Voice Response service agreements throughout the life of Blueworx Voice Response 6.1.


This document describes the requirements and installation steps to install DB2 10.1 on a new installation of BVR 6.1 for AIX. If updating a single system image (SSI), see the section at the end of the document which highlights some important considerations.


This document only covers the scenario where BVR 6.1 for AIX is installed on a clean machine and voice data and applications have not been installed yet. It does not cover the scenario where a BVR 6.1 for AIX system has been fully configured and the existing applications need to migrated to DB 10.1. For that scenario see this document:



Requirements:


  • Blueworx Voice Response 6.1 for AIX with fixpack 10 or later installed but not configured
  • DB2 10.1 system requirements are detailed at the following link: http://www.ibm.com/support/docview.wss?uid=swg27038033
  • DB2 10.1 install media, downloadable from Passport Advantage using part number CI6TTML, or contact Blueworx support for download details.
  • DB2 10.1 FP4. Customers should contact Blueworx support for download details.

Preparation:


  1. Back up the system using mksysb or similar.
  2. Verify the system is ready for the DB2 10.1 installation using the db2prereqcheck command supplied on the installation media:
    • Login as the root user
    • cd into the wse directory of the DB2 10.1 installation media
    • Run the command: ./db2prereqcheck -i -l
  3. Resolve any pre-requisite failures listed in the output. Note that any pre-requisite results for uDAPL can be safely ignored when using DB2 with Blueworx Voice Response.
  4. Ensure that the /opt filesystem has at least 4 GB free space.
  5. Ensure that the /tmp filesystem has at least 512 MB free space.

Instructions:


  1. Follow the normal BVR installation and PTF update instructions up to this point and reboot the system:
    Restarting AIX
    Do NOT create the database using the DTdatabase -r command at this time
  2. Stop DB2:
    • Login as root
    • su - dtdb23in
    • Run the following DB2 commands:
      db2 force applications all
      db2 terminate
      db2stop force
    • Exit back to root
    • Run the command:
      /home/dtdb23in/sqllib/bin/db2fmcu -d
  3. Remove DB2 9.5 symbolic links:
    • Login as root
    • Run the command:
      /opt/IBM/db2/V9.5/cfg/db2rmln
  4. Install DB2 10.1 base code:
    • Login as root
    • cd into the wse directory of the DB2 10.1 installation media
    • Run the command:
      ./db2_install -p wse -f NOTSAMP -n -b /opt/IBM/db2/V10.1
      Note: Ignore the message stating that support for the db2_install command is deprecated.
  5. Validate install by running:
    /opt/IBM/db2/V10.1/bin/db2val
  6. Confirm that both DB2 9.5 and DB2 10.1 are installed by running:
    /usr/local/bin/db2ls
  7. Update symbolic links to use DB2 10.1:
    • Login as root
    • Run the command:
      /opt/IBM/db2/V10.1/cfg/db2ln
  8. Upgrade to DB2 10.1 FP4:
    • Login as root
    • cd into the server directory of the DB2 10.1 FP4 installation media
    • Run the command:
      ./installFixPack -b /opt/IBM/db2/V10.1 -l /tmp/db2upgrade.log
      Type no when asked "Do you want to choose a different installation directory for the fix pack?"
    • Confirm that the fix pack is installed by running:
      /usr/local/bin/db2ls
  9. Confirm the DB2 license is valid and permanent:
    • Login as root
    • Run the command:
      /opt/IBM/db2/V10.1/adm/db2licm -l
    • Verify that the output contains the lines:
      License type: "Restricted"
      Expiry date: "Permanent"
  10. Create the BVR database instance
    • Login as root
    • Run the command:
      /opt/IBM/db2/V10.1/instance/db2icrt -u dtdb23in dtdb23in
  11. Confirm the upgrade
    • Login as the Blueworx Voice Response user (dtuser by default)
    • Run the command:
      /opt/IBM/db2/V10.1/bin/db2level
      Output similar to the following should be displayed:
      DB21085I This instance or install (instance name, where applicable:
      "dtdb23in") uses "64" bits and DB2 code release "SQL10014" with level identifier "0205010E".
      Informational tokens are "DB2 v10.1.0.4", "s140509", "IP23577", and Fix Pack "4".
      Product is installed at "/opt/IBM/db2/V10.1"
  12. Configure Blueworx Voice Response to use DB2 10.1:
    • cd into $SYS_DIR/db2
    • Run the command:
      cp db2level.1001 db2level
  13. Restart the server
    • Login as root
    • Run the command:
      shutdown -Fr
  14. Complete the BVR installation

Single System Image (SSI) considerations:


  • All clients within an SSI cluster must be upgraded before the servers.
  • It is possible to run an SSI cluster with a mixture of DB2 9.5 and DB2 10.1 clients to allow a staged upgrade.
  • It is not possible to run an SSI cluster with a mixture of DB2 9.5 and DB2 10.1 servers. As a result, after the clients have been upgraded, all active servers should be upgraded at the same time.

Single System Image (SSI) Client upgrade steps:


  1. Ensure that BVR is stopped
    • Login as the Blueworx Voice Response user (dtuser by default)
    • Run the command:
      DT_shutdown
  2. Remove the client from the SSI cluster
    • Run the command:
      ssirmclient
  3. Follow the directions above to upgrade DB2 to 10.1
  4. Add the client back into the cluster
    • Run the command:
      ssimkclient servername
  5. Start BVR on the client

Single System Image (SSI) Server upgrade steps:


  1. Ensure that BVR is stopped
    • Login as the Blueworx Voice Response user (dtuser by default)
    • Run the command:
      DT_shutdown
  2. Remove the server from the SSI cluster (Note: there is no need to run any of the NFS mount commands)
  3. Follow the directions above to upgrade DB2 to 10.1
  4. Recreate the server
  5. Add the clients to the server


Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.