Creating a database for the Sametime System Console

Before installing the IBM® Sametime® System Console on AIX®, Linux™ or Windows™, create a database to store its data.

Procedure

On the DB2® server, log in as the DB2 administrator.
Open a command window and navigate to the folder where you extracted the SametimeSystemConsole installation package.
In the extracted installation package, locate the createSCDb.bat (Windows) or createSCDb.sh (AIX or Linux) file in the SametimeSystemConsole/DatabaseScripts/SystemConsole directory, and copy the file to the DB2 server.
Navigate to the DatabaseScripts\SystemConsole folder.
Create the database by running one of the following commands:
- AIX or Linux
```
./createSCDb.sh STSC DB2_Admin
```
- Windows
```
createSCDb.bat STSC DB2_Admin
```
where:
- STSC is the name of the database. When naming DB2 objects, follow the rules for your operating system.
- DB2_Admin is the DB2 administrator account (an account with database administration authority)
After you enter the command, the window remains blank for several minutes. Do not close the window. Wait until you see confirmation that the database has been created and the command has finished. The following confirmation messages display on Microsoft™ Windows and Linux platforms:
```
DISCONNECT STSC
DB20000I The SQL DISCONNECT command completed successfully.
QUIT
DB20000I The QUIT command completed successfully.
```
Start the DB2 command window by running the following command:
- AIX or Linux: db2
- Windows: db2cmd
Verify that the new database was created by entering the following command:
db2 connect to STSC
where STSC represents the name of the database you created. Verify that you can connect to the database.
A successful connection looks similar to this:
```
Database Connection Information
Database Server = DB2/NT64 10.0.1
SQL authorization ID = ADMINIST...
Local database alias = STSC
```
Close the command window.

What to do next

If corporate policy prevents the DB2 application user ID from having administrator rights to the DB2 server, see Setting up the Sametime System Console database manually for instructions on creating tables in the new database before you install the Sametime System Console.