You must configure a content indirection
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
- Switch to the following directory: was_root/installableApps/presence/scripts/dbScripts/presence.
- Verify that the following files exist in /presence:
- ConfigDB2.sh
- RunConfigContentIndirectionDB2.sh
- CreateContentIndirectionDB2Tables.ddl
- Run the following commands to ensure
that the database configuration scripts will run properly:
- chmod 755 ConfigDB2.sh
- chmod 755 RunConfigContentIndirectionDB2.sh
- Edit the database preparation script, RunConfigContentIndirectionDB2.sh,
for your environment:
- Open RunConfigContentIndirectionDB2.sh using
a text editor.
- Locate the line that begins with the following text:
- #Update command line parameters here.
- Update values for each parameter listed.
Parameter |
Description |
Default value |
DBSERVER |
Fully qualified name of the database server Should match the Linux hostname command
value if you are running the script directly on the database server
|
<hostname> |
DBPORT |
Number for the listening port on the database server |
50000 |
DBNAME |
Name of the database |
PSDB |
DBALIAS |
Alias by which the database is known |
PSDB |
DBLOCALE |
Territory code that identifies your DB2 locale,
for example US or JP |
US |
DBINSTANCE |
Name of the database instance |
db2inst |
DBINSTANCPW |
Password for the database instance |
<pw> |
DBUSER |
User ID for the authorized user (the ID with which you are
logged in) |
db2inst |
DBUSERPW |
Password for the authorized user |
<pw> |
DBDIR |
Directory in which the database files are to be created (should
be a directory with write permission) |
/home/db2inst |
DBCREATE |
Boolean value specifying whether the database should be recreated |
TRUE |
- Run the RunConfigContentIndirectionDB2.sh script.
- Verify that the database tables were created
properly by typing the following command, where database_alias is
the alias you provided in the RunConfigContentIndirectionDB2.sh script:
- db2 connect to database_alias user database_administrator_ID
Where:
- database_alias represents the database alias
you assigned in step 7
- database_administrator_ID represents the administrator
user ID
For example:db2 connect to PSICDB 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 = database_alias
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.