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