Abstract


Blueworx Voice Response V6.1 for AIX Fix Pack 10 added support for DB2 V10.1


Content


Updates in the BVR V6.1 FP10 included changes to allow support for DB2 V10.1 in addition to DB2 V9.5.


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


This document describes the requirements and installation steps to install DB2 V10.1 on a Blueworx Voice Response V6.1 system. If updating a single system image (SSI), see the section at the end of the document which highlights some important considerations.


Requirements:


  • Blueworx Voice Response Version 6.1 for AIX with FP10 installed
  • DB2 Version 10.1 system requirements are detailed at the following link: http://www.ibm.com/support/docview.wss?uid=swg27038033
  • DB2 Version 10.1 install media, downloadable from Passport Advantage using part number CI6TTML, or contact Blueworx support for download details.
  • DB2 Version 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 2 GB free space.
  6. Ensure that the /var filesystem has at least 512 MB free space.


Installation:


  1. Stop BVR:
    • Login as the Blueworx Voice Response user (dtuser by default)
    • Run the command: DT_shutdown
  2. Stop DB2:
    • Login as dtdb23in (may be easiest to "su - dtdb23in " when logged in as root)
    • Run the following commands:
      db2 force applications all
      db2stop force
      db2 terminate
    • Login as root
    • Run the command: /home/dtdb23in/sqllib/bin/db2fmcu -d
  3. Remove DB2 Version 9.5 symbolic links:
    • Login as root
    • Run the command: /opt/IBM/db2/V9.5/cfg/db2rmln
  4. Install DB2 Version 10.1 base code:
    • Login as root
    • cd into the wse directory of the DB2 Version 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 Version 9.5 and DB2 Version 10.1 are installed by running: /usr/local/bin/db2ls
  7. Update symbolic links to use DB2 Version 10.1:
    • Login as root
    • Run the command: /opt/IBM/db2/V10.1/cfg/db2ln
  8. Upgrade to DB2 Version 10.1 FP4:
    • Login as root
    • cd into the server directory of the DB2 Version 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


Upgrade:


  1. 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"
  2. Allow the DB2 instance to be upgraded:
    • Login as root
    • Run the command:
      mv /home/dtdb23in/sqllib/bin/db2gcf /home/dtdb23in/sqllib/bin/db2gcf.orig
  3. Update DB2 instance:
    • Ensure /home/dtdb23in has at least 450 MB free space.
    • Confirm that no db2 processes are running with the command:
      ps -ef | grep db2 | grep -v grep
    • If any processes are listed, refer back to the "Stop DB2" step in the "Installation" section above.
    • When DB2 is stopped, login as root
    • Run the command:
      /opt/IBM/db2/V10.1/instance/db2iupgrade -u dtdb23in dtdb23in
  4. Update DB2 database:
    • Login as dtdb23in
    • Run the following commands:
      db2start
      db2 UPGRADE DATABASE DTDBV230
    • Confirm upgrade with the command:
      db2 connect to DTDBV230
      You should see output similar to the following:
      Database Connection Information
      Database server = DB2/AIX64 10.1.4
      SQL authorization ID = DTUSER
      Local database alias = DTDBV230
    • Login as root
    • Setup links to DB2 Version 10.1 files with the command: /opt/IBM/db2/V10.1/cfg/db2ln
  5. 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"


Configure Blueworx Voice Response to use DB2 V10.1:


  1. Login as the Blueworx Voice Response user (dtuser by default) and do not start Blueworx Voice Response.
  2. cd into $SYS_DIR/db2.
  3. Run the command: cp db2level.1001 db2level.
  4. Login as root and reboot the server.
  5. When rebooted, login as the Blueworx Voice Response user (dtuser by default) and start Blueworx Voice Response.


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
  3. Run the command: ssirmclient
  4. Follow the directions above to upgrade DB2 to Version 10.1
  5. After successfully upgrading, add the client back into the cluster:
    • Run the command: ssimkclient servername
    • 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)