Abstract

Blueworx Voice Response V6.1 for AIX PTF level 6.1.0.529 added support for DB2 V11.1.


Content

Updates in the Blueworx Voice Response PTF level 6.1.0.529 included changes to allow support for DB2 V11.1 in addition to DB2 V9.5 and V10.1.


Note: Although DB2 version V10.1 is going out of service in September 2017, support will continue as a bundled product within Blueworx Voice Response V6.1. Any problems encountered with Blueworx Voice Response's use of DB2 V10.1 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 V11.1 on a Blueworx Voice Response V6.1 system.


Requirements


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 dtdb23in (may be easiest to "su - dtdb23in" when logged in as root)
    • Run the following commands:
      db2start 
      db2 update database configuration for dtdbv230 using APPLHEAPSZ 256 AUTOMATIC
      db2 update database configuration for dtdbv230 using PCKCACHESZ 3160 AUTOMATIC
  3. 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
  4. Remove DB2 10.1 symbolic links:
    • Login as root
    • Run the command: /opt/IBM/db2/V10.1/cfg/db2rmln
  5. Install DB2 11.1
    • Login as root
    • cd into the wse directory of the DB2 11.1 installation media
    • Run the command: ./db2setup -r db2_v111_bvr61.rsp
  6. Validate install by running: /opt/IBM/db2/V11.1/bin/db2val
  7. Confirm that both DB2 10.1 and DB2 11.1 are installed by running: /usr/local/bin/db2ls
  8. 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/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/V11.1/instance/db2iupgrade dtdb23in
  3. Update DB2 database:
    • Login as dtdb23in
      (may be easiest to "su - dtdb23in" 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  = DTDB23IN
       Local database alias  = DTDBV230
  4. Confirm the upgrade:
    • Login as the BVR user (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: "dtdb23in")
      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 BVR to use DB2 11.1

  1. Login as the Blueworx Voice Response user (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.