Troubleshooting: Instance creation fails during database creation

A WebSphere Commerce instance creation fails while creating a database.

Problem

You see the following error in createdb.db2.log:
SQL0104N An unexpected token "db2inst1" was found following "USER". Expected
tokens may include: "USER". SQLSTATE=42601
/opt/WebSphere/CommerceServer70/bin/updateDB2Configuration.sh: line 88: db2set: command not found
/opt/WebSphere/CommerceServer70/bin/updateDB2Configuration.sh: line 89: db2set: command not found

Solution

  1. Delete .bash_profile from the home directory of the non-root user.
  2. Login in the non-root user again.
  3. Reattempt to create the instance.
Feature Pack 7 or laterNote: You can also encounter errors when you are running a process or utility if the input parameters that are used to establish a database connection are incorrect. To validate that a database connection can be established with the configured input parameters, use the database connection validation utility. For more information about running this utility, see Running the database connection validation utility.