Linux clustered server: Setting up DB2 manually

As an alternative to automatically setting up the database, you can manually configure the DB2® database. If you have configured your database automatically by running the ConfigEngine task, you do not need to run manual tasks for granting privileges or creating table spaces, but you may decide to perform additional manual configuration for items that are not provided to you when you automatically when you run the ConfigEngine task. For example, assigning custom table spaces is an optional task that is not covered by the automated ConfigEngine task.

Linux clustered server: Creating DB2 database schemas
To create database schemas, you can create a copy of the template SQL scripts and edit this copy to manually create the database schemas. The template SQL scripts should be used as a guide for creating executable scripts and contain invalid SQL syntax.
Linux clustered server: Granting privileges to DB2 database users
Configuration and runtime database users are granted a different set of privileges, depending on whether these users are schema owners or not. You can create a copy of the SQL scripts and edit this copy to manually grant permissions to configuration and runtime database users.
Linux clustered server: Assigning custom DB2 table spaces
The repository of WebSphere® Portal consists of many tables and indices that are created in default table spaces. When using an existing set of table spaces for the objects of the repository, specify this when executing the database transfer to the target database system.

Parent topic: Linux clustered server: Setting up DB2 automatically or manually