Abstract

Blueworx Voice Response V7 for AIX Fix Update level 7.0.0.20 added support for DB2 V11.5


Content

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


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


Requirements:


Preparation

  1. Back up the system using mksysb or similar.
  2. Verify the system is ready for the DB2 11.5 installation using the db2prereqcheck command supplied on the installation media:
    • Login as the root user
    • cd into the server_* directory of the DB2 11.5 installation media
    • Run the command: ./db2prereqcheck -i 
  3. Resolve any pre-requisite failures listed in the output related to Version "11.5.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 or 11.1 symbolic links:
    • Login as root
    • Run the command: /opt/IBM/db2/V10.5/cfg/db2rmln
      or
      /opt/IBM/db2/V11.1/cfg/db2rmln

  6. Install DB2 V11.5
    • Login as root
    • cd into the wse directory of the DB2 11.5 installation media
    • Run the command: ./db2setup -r db2_v115_bvr7.rsp
  7. Validate install by running: /opt/IBM/db2/V11.5/bin/db2val
  8. Confirm that both DB2 10.5 and DB2 11.5 are installed by running: /usr/local/bin/db2ls
  9. Update symbolic links to use DB2 11.5:
    • Login as root
    • Run the command: /opt/IBM/db2/V11.5/cfg/db2ln


Upgrade

  1. Confirm the DB2 license is valid and permanent:
    • Login as root
    • Run the command: /opt/IBM/db2/V11.5/adm/db2licm -l
    • Verify that the output contains the lines:
      License type: "CPU Option"
      Expiry date: "Permanent"
      or License type "Community" if using the Community Edition.
  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.5/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 Connection Information

 Database server        = DB2/AIX64 11.5.0.0
 SQL authorization ID   = DTUSER
 Local database alias   = DTDBV230

  4. Confirm the upgrade:
    • Login as the BVR user (usually dtuser by default).
    • Run the command: /opt/IBM/db2/V11.5/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 "SQL11050" with level identifier
"0601010F".
Informational tokens are "DB2 v11.5.0.0", "s1906101300", "DYN1906101300AIX",
and Fix Pack "0".
Product is installed at "/opt/IBM/db2/V11.5".


Configure Blueworx Voice Response to use DB2 11.5:

  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.1105 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.