Windows stand-alone: Set up DB2 manually

If you have configured the database automatically by running ConfigEngine, 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 ConfigEngine.

For example, assigning custom table spaces is an optional task that is not covered by the automated ConfigEngine task.

• Windows stand-alone: Create DB2 database schemas
  To create database schemas, we 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.
• Windows stand-alone: Grant 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. We can create a copy of the SQL scripts and edit this copy to manually grant permissions to configuration and runtime database users.
• Windows stand-alone: Assign custom DB2 table spaces
  The repository of WebSphere Portal consists of many tables and indicecreated 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: Windows stand-alone: Set up DB2 automatically or manually