You can optionally configure a SIBus database
before installing Presence Server.
Before you begin
Before you begin, the following software
should be installed:
- IBM® DB2® Enterprise
Server Edition,
version 9.5 FixPak 1
- Log in to the DB2 server
as a database administrator.
- Create a directory that has write and
execute permission, for example DB_dir.
- Copy the installation .tar file, IBMPresenceServerDbPackage_7.0.tar, from
the installation medium to the new directory.
- Switch to the new directory.
- Unpack the installation .tar file
using the following command:
tar -xvf IBMPresenceServerDbPackage_7.0.tar
- Change (cd) to the following directory: was_root/installableApps/presence/scripts/dbScripts/SIBus.
- Verify that the following files exist in /SIBus:
- createDB2SIBus.sh
- dropDB2SIBusSchemas.sh
- Run the following command to ensure that
the database configuration script will run properly:
- chmod 755 createDB2SIBus.sh
- Issue the following command to create the
database:
./createDB2SIBus.sh db_name database_administrator_ID database_administrator_pw
where:- db_name is the name of the SIBus database,
for example PSSIBUS
- database_administrator_ID is the authorized
user for the database, for example db2inst
- database_administrator_pw is the password
for the authorized user
- Verify that the database was created properly
by typing the following command:
- db2 connect to db_name user database_administrator_ID
For example:db2 connect to PSSIBUS user db2inst
If the script ran properly, the following results display:Database Connection Information
Database server = DB2/LINUX 9.5.1
SQL authorization ID = database_administrator_ID
Local database alias = db_name
Results
Note: If errors occur when you run the database
preparation script, refer to the topic Troubleshooting the database
script.
What to do next
The required
DB2 database
tables will be created for you when you run the
Presence Server interactive
installation or silent installation.