Create Database Components, Database User, and Storage
If you selected create, do the following:
1. In the Action area, do one of the following:
To create individual database components, click
Component and select the database components.
To create all database components for products that have multiple database components, click
Product and select the products. If you want to see the list of database components for a product, click
Product, click
print in the
Action Type list, click
Execute, and then click the Results tab.
2. For version, select Latest.
3. If no database user and storage already exist from a previous create action, follow the steps below.
a. Select the check box labeled as follows:
RDBMS | Label |
DB2 | Create Tablespaces and Grant Permissions to OS User |
MySQL | Create Database and Database User |
Oracle or Tibero | 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 the necessary database administrator credentials. 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, Oracle, or Tibero | 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, Oracle, or Tibero, you can select the Use Custom Tablespace Names check box and specify custom tablespace names in the fields. Your products support all tablespace configurations deployed by users.
RDBMS | Entry and Notes |
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). |
Oracle or Tibero | The custom tablespace names will replace the defaults WEBMDATA and WEBMINDX. |