![]() |
Database creation involves specifying values for the following:
Default values are available for all these parameters and you can accept these defaults and start creating the database. You can specify your own values while creating the database. |
![]() |
This task explains the procedure to create an empty CES Database: |
![]() |
|
![]() |
The first window in the database creation process is Database NLS Setup window. This table describes the fields:
|
![]() |
The second step in the database creation process is specifying the registry variables. This table describes the variables:
Note:Default values are available for all the registry variables.
|
![]() |
The database manager configuration parameters
All these parameters are independent of any single database stored under
that instance of the database manager. The default values for these parameters are displayed. Modifying a Value
Adding a new parameter
|
![]() |
The next step in the database creation process is
specifying the database level configuration parameters. You can define
several parameters that are used to specify the amount of resources
allocated to the database and improve the database performance or increase
capacity. You can modify these parameters based on the type of activity in a
database. The default values for these parameters are displayed. Modifying a value
Adding a new parameter
|
![]() |
The next step in the database creation process is defining the Buffer Pool. The purpose of the Buffer Pool is to improve system performance. Buffer Pool is the amount of main memory that should be allocated to cache table and index data pages as they are read from disk.
You can:
|
![]() |
The next step in the database creation process is specifying the DB2 System Tablespaces. In this window, you can setup the values for the following DB2 System Tablespaces:
You can:
The fields given in the table are not configurable for SYSCATSPACE, USERSPACE1 and TEMPSPACE1 tablespaces:
Click Next to proceed with the database creation process. |