Blueworx Voice Response reports "SQL1042C with SQLSTATE=58004" error

When logging in using the account that you use to run Blueworx Voice Response (the default is dtuser), the following error is returned:
SQL1042C with SQLSTATE=58004
The same DB2 error is also found in DTstatus.out. When an attempt is made to start DB2 with db2start, the same error is returned.

The problem is caused by an incorrect setup of the instance for dtdb23in during installation, or migration. As a result, the instance fails to start.

To resolve the problem, reset the instance with FencedID (the name of the user under which fenced user defined functions (UDFs) and fenced stored procedures will run.) To do this:

  1. Log in as root
  2. Type instance cd /opt/IBM/db2/V9.5/instance (or location where DB2 was installed )
  3. Type ./db2iupdt -u dtdb23in -e dtdb23in
  4. Log in as dtuser (or equivalent) or dtdb23in
  5. Start DB2 using db2start