Run the SQL scripts to create the database tables for your
IBM Process Center or IBM Process Server configuration.
Before you begin
You have performed all of the steps required for your configuration
and have selected not to run the database scripts to initialize the
databases during the configuration. You have also created the database
that you want to create the Process Center or Process Server database
tables in. For information about creating the database, see Creating
databases
Procedure
To run the Process Center or Process Server SQL scripts
that were produced when you completed your configuration follow the
steps below:
Note: The Process Server does not support schema. You
must login as the user and then execute the SQL file.
- Go to the directory that holds the SQL scripts for creating
the database tables.
By default, SQL scripts are output
to
profile_root/dbscripts/ProcessServer/DB_product at
profile creation time. For example,
profile_root/dbscripts/ProcessServer/DB2
- Run the following command as a root user or administrator.
configProcessServerDB.sh createDB
configProcessServerDB.bat createDB
Note: The createDB parameter is used to create
a local database. Skip this parameter if you have already created
the required database. The createDB parameter is
not applicable for an Oracle database and must be excluded from the
command.
- For an SQL database, create the tables for Process Center
or Process Server.
From the directory
navigated to in step 1, run createTable_ProcessServer.sql on
the database you configured for the Process Center or Process Server
(BPMDB).
Make sure all SQL statements succeed without any errors.
- For an SQL database, create the table procedures for Process
Center or Process Server.
From the directory navigated
to in step 1, run createProcedure_ProcessServer.sql on
the database you configured for the Process Center or Process Server
(BPMDB).
Make sure all SQL statements succeed without any errors.
- Reset the connection.
Results
You have created the database tables for your Process Center
or Process Server configuration and have completed the database configuration.
What to do next
You can now load the database with system information and
start the servers or clusters on your Process Center or Process Server
configuration.