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
- 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: