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
- Delete .bash_profile from the home directory of the non-root user.
- Login in the non-root user again.
- Reattempt to create the instance.
Note: 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.