Configuring a database for an instance with Configuration Tool

Edit online

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

Before you begin

To configure a DB2 database for a directory server instance, you must complete the following tasks:

Procedure

  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 advanced DB2 configuration settings, select Show advanced tablespace options.
      5. Specify the Tablespace container as File or Raw device .
        File
        Select this option if you want to create the table space container on a file system.
        Specify the Directory path for the table space container location. You can click Browse to select the directory.
        Specify the File name for the table space. The default file name is AUTOSPACE.
        Under Other properties, specify the Extendable size (Pages) of the table space in pages. The default value for the extension size is 8192 pages.
        Raw device
        Select this option if you want to create the table space container on a a raw 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 raw table space is created. In this case, the size of the database table space container is fixed and cannot be expanded.
        In the Device path field, enter the location of the raw device. On Windows™, the path must start with \\.\. For example, a path with device name can be: \\.\device_name. On AIX® and Linux™, the device path must be a valid path.
        Note: The default tablespace for IBM Security Verify Directory is automatic storage tablespace. From DB2, Version 10.1 Fix Pack 1 onwards the database managed spaces (DMS) table space type and system managed spaces (SMS) table space type is deprecated for permanent table spaces that are defined by the user.

        If you do not select Show advanced tablespace options, a DB2 database with the USERSPACE1 and LDAPSPACE table spaces is created by using automatic storage 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.

      6. 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 and Linux, the location must be a directory name, such as /home/ldapdb.
    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. Click Finish.
  6. To accept task completion, click OK.
  7. Verify the logs that are generated for the database configuration operation.
  8. To close the Configure database page, click Close.
  9. To close the Configuration Tool window, click File > Exit.
  10. To confirm your action, click Yes.

What to do next

After you configure a database, you must complete the following configurations for an instance: