Updating the Blueworx Voice Response database

If you migrated to Blueworx Voice Response Version 6.1 from Blueworx Voice Response Version 4.2 you need to copy (migrate) the Blueworx Voice Response data from the old DB2 Version 8.1 database to the new DB2 Version 9.5 format as follows:

Start

1. Log on to the DB2 server as dtdb23in.
2. Type the following command to invoke the editor and press Enter:

   vi /home/dtdb23in/sqllib/db2nodes.cfg

   • If the file already contains data, ensure that the hostname used is the DB2 machine service IP label.
   • If the file has no content, or is new, add the following text:

     0   <DB2 service IP label>   0

   To save the db2nodes.cfg file you may have to use the:w! command instead of simply :w.
3. Type the following commands, pressing Enter after each one:
   1. chmod 444 /home/dtdb23in/sqllib/db2nodes.cfg
   2. db2 force applications all
   3. db2 terminate
   4. db2stop
   Wait until all DB2 processes have stopped (you can check this using the ps –ef | grep db2 command). The db2fmcd process will continue to run, but this does not cause any problems. If DB2 does fail to stop, use the command db2stop force.
4. Log on as root.
5. Type the following command and press Enter:

   /usr/lpp/dirTalk/tools/DTdatabase –m

If an error message is generated, take the following action:

1. Retry the command

   /usr/lpp/dirTalk/tools/DTdatabase -m  

   This should now complete without any errors.
2. Enter the following commands, pressing Enter after each one:
   1. su - dtdb23in
   2. db2set DB2COMM=TCPIP
   3. db2 "update dbm cfg using DIAGLEVEL 3"
   4. exit

Next step: Go to Setting ownership of the DTTAs.