Create Database Components, Database User, and Storage

If you selected create in the Action Type list, do the following In the Action area:

1. Select the database components to create. You can use any of the options below.

Click Component and select one or more database components to create. You can select All to create all database components.

Click Product and select one or more products whose database components to create. You can see the list of database components for a product by clicking Product, clicking print in the Action Type list, clicking Execute, and then clicking the Results tab.

3. If you need to also create the database user and storage, follow the steps below.

RDBMS	Label
DB2	Create Tablespaces and Grant Permissions to OS User
MySQL	Create Database and Database User
Oracle	Create Tablespaces and Database User
SQL Server	Create Database and Database User

For DB2 on Linux systems, tablespaces are created for each DB2 database. If you are creating database components in more than one DB2 database, either the tablespace directory or the tablespace names must be unique for each DB2 database.

b. In the Admin ID field, identify the database user or operating system user that has database administrator credentials to create the database user and storage. Supply the password for the user in the Admin Password field.

c. The next field and your entry depend on your RDBMS.

RDBMS	Field and Entry
DB2 or Oracle	In the Tablespace Directory field, identify the directory in which to create the tablespaces.
MySQL or SQL Server	In the Database field, specify the database to create.

4. For DB2 or Oracle, you can select the Use Custom Tablespace Names check box and specify custom tablespace names in the fields.

For DB2, the custom tablespace names will replace the defaults WEBMDATA, WEBMINDX, and WEBMBLOB. You can also specify a custom name to use for the buffer pool for your products (WEBMBUFF by default).

Note:

Your products support all tablespace configurations deployed by users.

For Oracle, the custom tablespace names will replace the defaults WEBMDATA and WEBMINDX.