Error when creating Sametime System Console DB2 database on AIX 7.1 LPAR

When the db2admin user creates a Sametime® System Console DB2® database on an AIX® 7.1 LPAR, using the command script ./createSCDb.sh an error occurs.

Error message and problem

#./createSCDb.sh STSC db2admin
Processing...

./createSCDb.sh[62]: db2: not found

Database creation failed
#

There is an error in the following line in the script createSCDb.sh. The message indicates that the DB2 command is not found.

"db2 create database $1 using codeset UTF-8 territory US"

This message indicates that DB2 has started:

# /home/db2inst2/sqllib/adm/db2start
01/10/2014 10:23:41 0 0 SQL1026N The database manager is already active.
SQL1026N The database manager is already active.

Solution

Run the script as the user db2instX, the instance-owning user for the DB2 instance that was specified during DB2 installation in the field Set User information for the instance owner. In this example, db2inst2 is specified as instance-owning user during DB2 setup:
./createSCDb.sh STSC db2inst2
These messages display:
```
$Processing...
DB20000I The CREATE DATABASE command completed successfully.
```
Messages similar to this display:
```
Database Connection Information

Database server = DB2/AIX64 10.1.0
SQL authorization ID = DB2INST2
Local database alias = STSC
```