Abstract

Blueworx Voice Response V7 for AIX Fix Update level 7.0.0.9 added support for DB2 V11.1


Content

Updates in the Blueworx Voice Response Fix Update level 7.0.0.9 included changes to allow support for DB2 V11.1 in addition to DB2 V10.5.


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


This document describes the requirements and installation steps to install DB2 V11.1 on a Blueworx Voice Response V7 system.


Requirements:

  • Blueworx Voice Response V7 for AIX with Fix Update level 7.0.0.9 installed
  • db2_v111_bvr7.rsp DB2 response file supplied by Blueworx Support
  • DB2 V11.1 system requirements are detailed at the following link: http://www.ibm.com/support/docview.wss?uid=swg27038033
  • DB2 V11.1 install media, 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 11.1 installation using the db2prereqcheck command supplied on the installation media:
    • Login as the root user
    • cd into the wse directory of the DB2 11.1 installation media
    • Run the command: ./db2prereqcheck -i 
  3. Resolve any pre-requisite failures listed in the output related to Version "11.1.0.0"
  4. Ensure filesystem has sufficient free space
    • /tmp has at least 512M of free space
    • /opt has at least 3GB of free space


Installation

  1. Stop Blueworx Voice Response:
    • Login as the Blueworx Voice Response user (dtuser by default)
    • Run the command: DT_shutdown
  2. Update BVR DB2 database configuration to allow upgrade:
    • Login as dtdbbvr (may be easiest to "su - dtdbbvr" when logged in as root)
    • Run the following commands:
      db2 update database configuration for dtdbv230 using APPLHEAPSZ 256 AUTOMATIC
  3. Stop DB2:
    • Login as dtdbbvr (may be easiest to "su - dtdbbvr" when logged in as root)
    • Run the following commands:
      db2 force applications all
      db2stop force
      db2 terminate
    • Login as root
    • Run the command: /home/dtdbbvr/sqllib/bin/db2fmcu -d
  4. Stop DB2 administration server (DAS):
    • (Note this may not be running)
    • Login as dasusr1 (may be easiest to "su - dasusr1" when logged in as root)
    • Run the following command: db2admin stop
  5. Remove DB2 10.5 symbolic links:
    • Login as root
    • Run the command: /opt/IBM/db2/V10.5/cfg/db2rmln
  6. Install DB2 V11.1
    • Login as root
    • cd into the wse directory of the DB2 11.1 installation media
    • Run the command: ./db2setup -r db2_v111_bvr7.rsp
  7. Validate install by running: /opt/IBM/db2/V11.1/bin/db2val
  8. Confirm that both DB2 10.5 and DB2 11.1 are installed by running: /usr/local/bin/db2ls
  9. Update symbolic links to use DB2 11.1:
    • Login as root
    • Run the command: /opt/IBM/db2/V11.1/cfg/db2ln


Upgrade

  1. Confirm the DB2 license is valid and permanent:
    • Login as root
    • Run the command: /opt/IBM/db2/V11.1/adm/db2licm -l
    • Verify that the output contains the lines:
      License type: "CPU Option"
      Expiry date: "Permanent"
  2. Update DB2 instance:
    • Ensure /home/dtdbbvr 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/V11.1/instance/db2iupgrade dtdbbvr
  3. Update DB2 database:
    • Login as dtdbbvr
      (may be easiest to "su - dtdbbvr" when logged in as root)
    • 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 server = DB2/AIX64 11.1.0
      SQL authorization ID = DTDBBVR
      Local database alias = DTDBV230
  4. Confirm the upgrade:
    • Login as the BVR user (usually dtuser by default).
    • Run the command: /opt/IBM/db2/V11.1/bin/db2level
      Output similar to the following should be displayed:
      DB21085I This instance or install (instance name, where applicable: "dtdbbvr")
      uses "64" bits and DB2 code release "SQL11010" with level identifier
      "0201010F".
      Informational tokens are "DB2 v11.1.0.0", "s1606081100", "DYN1606081100AIX",
      and Fix Pack "0".
      Product is installed at "/opt/IBM/db2/V11.1"


Configure Blueworx Voice Response to use DB2 11.1:

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