Problem

When logging in as WVRuser (default is 'dtuser'), error "SQL1042C with SQLSTATE=58004" is returned. 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.


Cause

During installation, or migration, the setup of the instance for dtdb23in was done incorrectly. As a result, the instance fails to start.


Resolving the problem

Reset the instance with FencedID by:

  1. Log in as root
  2. Change directory to the DB2 instance directory:
    cd /usr/opt/db2_08_01/instance
  3. Enter the DB2 update instance command:
    ./db2iupdt -u dtdb23in -e dtdb23in
  4. Log in as dtuser or dtdb23in and start DB2 by entering:
    db2start