Configuring a database for an instance with Configuration Tool

Use Configuration Tool to configure a DB2 database for a directory server instance.

1. Start Configuration Tool for an instance. See Starting Configuration Tool.
2. From the task list in the left navigational pane, click Database tasks > Configure database.
3. In the Configure database page, select one of the following options:
   • To configure a database for an instance, complete the following steps:
     1. In the Database user name field, enter the system user ID who must own the database. The directory server instance uses this system user ID to connect to the database.
     2. In the Password field, enter the password for the database administrator.
     3. In the Database name field, enter the database name.
     4. If you want to set any of the following DB2 configuration settings, select Show advanced tablespace options.
        • You want the database to use the System Managed Storage (SMS) data storage for the DB2® table spaces. When SMS is used, the file system manager of the operating system allocates and manages the table space where DB2 tables are stored.
        • You want the database to use the Database Managed Storage (DMS) data storage for the DB2 table spaces. Also, you want to configure the database for the USERSPACE1 and LDAPSPACE table spaces, size, and location. When DMS is used, the table spaces are managed by the database manager. The database administrator decides which devices and files to use, and DB2 manages the space on those devices and files.
        If you do not select Show advanced tablespace options, a DB2 database with the USERSPACE1 and LDAPSPACE table spaces is created by using DMS with default sizes and locations. If you configure an instance with an existing database, Show advanced tablespace options is disabled when you enter the name of an existing database in the Database name field.
     5. Click Next.
   • To configure the database administrator password again, complete the following steps:
     1. Click Reset password.
     2. In the Password field, enter the password for the database administrator.
     3. In the Confirm password field, enter the password for the database administrator.
     4. Click Next.
4. If you create and configure a DB2 database, complete the following steps:
   1. In the Database install location field, enter the database location path. You can click Browse to specify a directory. On Windows, you must provide a disk drive location, such as C:. On AIX, Linux, and Solaris, the location must be a directory name, such as /home/ldapdb.
      Note: The minimum disk space that is required for a DMS database is 1 GB. For an SMS database, a minimum of 150 MB of disk space is required. These requirements are for an empty database. When you store data in the database, more disk space is required.
   2. To configure the directory server with database for online backup, complete the following steps:
      1. Select Configure for online backup.
      2. In the Database backup location field, enter the location where you want to store the backup image. You can click Browse to specify the location.
      Note: Do not exit Configuration Tool or cancel operation when the backup operation is running.
      When you configure the database for online backup after the database configuration is complete an initial, offline backup of the database is run. After the offline backup operation is complete, the administration server is restarted. You can also configure online backup for a directory server instance with the idscfgdb command. However, you cannot unconfigure online backup with the idscfgdb command and the -c parameter. If you configure online backup for an instance with Instance Administration Tool or Configuration Tool, you can unconfigure it with Configuration Tool or the idscfgdb command.
   3. In the Character-set option area, choose one of the following options to create a database type:
      Note: Create a universal DB2 database if you plan to store data in multiple languages in the directory server. A DB2 Universal Database is also most efficient because less data translation is needed. If you want to use language tags, the database must be a UTF-8 database. For more information about UTF-8, see UTF-8 support.
      • To create an UCS Transformation Format (UTF-8) database in which LDAP clients can store UTF-8 character data, click Create a universal DB2 database .
      • To create a database in the local code page, click Create a local codepage DB2 database.
   4. Click Next.
5. If you selected Show advanced tablespace options, you must complete the following steps:
   1. From the Select database tablespace type list, select a database type. The DMS database table space type is the default. If you select SMS database table space type, all other fields are disabled. DMS table space support is used only for the USERSPACE1 and LDAPSPACE table spaces. All other table spaces, such as catalog and temporary table spaces, are of type SMS.
   1. Under the USERSPACE1 tablespace details area, specify the following details:
      1. From the Tablespace container list, select the container type. If you want the USERSPACE1 table space location on the file system, select File. If the database table space container location is in a file system, a DMS cooked table space is created. You can specify the initial size for the table space and an extendable unit size, and the table space is automatically expanded when required. If you want to create the USERSPACE1 table space on a raw device, select Raw device. A raw device is a device where no file system is installed, such as a hard disk that does not contain a file system. If the database table space container location is in a raw device, a DMS raw table space is created. In this case, the size of the database table space container is fixed and cannot be expanded. If you select Raw device, specify the size along with the container location instead of accepting the default values.
      2. If you selected File in the Tablespace container list, specify the following details:
         1. In the Directory path field, specify the directory path where you want create the USERSPACE1 table space. You can click Browse to select the directory.
         2. In the File name field, enter the file name of the table space that you want to create, or accept the default file name, USPACE.
         3. In the Initial size field, enter the initial size for the USERSPACE1 table space in pages or accept the default value. For the File type table space container, the USERSPACE1 table space container is of auto-incremental type. You can provide the initial size in the Initial size field, and an extendable unit size in the Extendable size field. The default value for the initial size is 16 K pages, and the default extendable unit size is 8 K pages. The page size for the USERSPACE1 table space container is 4 KB per page.
      3. If you selected Raw device in the Tablespace container list, specify the following details:
         1. In the Device path field, enter the location of the raw device. On Windows, the path must start with \\.\. An example that shows the path with device name, \\.\device_name. On AIX®, Linux, and Solaris, the device path must be a valid path.
         2. In the Initial size field, enter the initial size for the USERSPACE1 table space or accept the default value. For the Raw Device type table space container, the size of the USERSPACE1 table space container is fixed. The default size is 16 K pages. For better results, specify the size you want.
   2. Under the LDAPSPACE tablespace details area, specify the following details:
      1. From the Tablespace container list, select the container type. If you want the LDAPSPACE table space location on a file system, select File. If you want to create the LDAPSPACE table space on a raw device, select Raw device. A raw device is a device where no file system is installed, such as a hard disk that does not contain a file system.
      2. If you selected File in the Tablespace container list, specify the following details:
         1. In the Directory path field, specify the directory path where you want create the LDAPSPACE table space. You can click Browse to select the directory.
         2. In the File name field, enter the file name of the table space that you want to create, or accept the default file name, ldapspace.
         3. In the Initial size field, enter the initial size for the LDAPSPACE table space in pages or accept the default value. For the File type table space container, the LDAPSPACE table space container is of auto-incremental type. You can provide the initial size in the Initial size field, and an extendable unit size in the Extendable size field. The default value for the initial size is 16 K pages, and the default extendable unit size is 8 K pages. The page size for the LDAPSPACE table space container is 32 KB per page.
      3. If you selected Raw device in the Tablespace container list, specify the following details:
         1. In the Device path field, enter the location of the raw device. On Windows, the path must start with \\.\. An example that shows the path with device name, \\.\device_name. On AIX, Linux, and Solaris, the device path must be a valid path.
         2. In the Initial size field, enter the initial size for the LDAPSPACE table space or accept the default value. For the Raw Device type table space container, the size of the LDAPSPACE table space container is fixed. The default size is 16 K pages. For better results, specify the size you want.
   3. If you selected File in one or both of the Tablespace container fields, specify the number of pages by which to expand the table space containers in the Extendable size field.
6. Click Finish.
7. To accept task completion, click OK.
8. Verify the logs that are generated for the database configuration operation.
9. To close the Configure database page, click Close.
10. To close the Configuration Tool window, click File > Exit.
11. To confirm your action, click Yes.