Creating and Configuring a DB2 Database on Unix
This section describes how to create and configure the
portal database on DB2.
You must do
the following before you create and configure your DB2 database.
- ALI, Collaboration, and
Directory must share the same DB2 database.
- Have your DB2 DBA examine
and, if necessary, customize the SQL scripts before you use them.
Each SQL file contains comments that describe what customization might
be necessary.
Note: The DB2 SQL scripts use a hard-coded schema name, ALUI. If the schema name is changed in the scripts, you
must use Configuration Manager to update schema name setting for Portal,
Automation Service, ALI API Service, and Directory.
- Copy SQL scripts
from the AquaLogic Interaction install directory to your DB2 server.
The ALI installer creates the scripts in the following directories:
- For scripts pertaining to the main portal application, install_dir/ptportal/6.5/sql/db2
- For scripts pertaining to AquaLogic Directory, install_dir/ptportal/6.5/sql/db2
- Use the DB2
command line processor to run the portal SQL scripts against your
DB2 database.
The scripts must be run in this order:
- create_alui_schema.sql
- grant_alui_user.sql
- create_alui_tablespace_unix.sql
- create_tables_db2.sql
- load_seed_info_db2.sql
Run create_alui_schema.sql, grant_alui_user.sql, and create_alui_tablespace_unix.sql as an operating system user with DBADMIN privileges. All other scripts
may be run by a DBADMIN user or the ALI user.
Note: Comments in
the header of each SQL file contain recommended syntax for the DB2
command line processor.
- Run the run_stored_procs.sh shell script.
- Use the DB2
command line processor to run the postinst_db2.sql script.
- If you have
configured DB2 to skip automatic statistics collection, run statistics_build.sql.
- Use the DB2 command line processor to run the Directory
SQL scripts against your DB2 database.
The scripts must be run in this order:
- create_tables.sql
- create_functions.sql
- map_alidb_65.sql