Configuring a database for an instance with the command-line utility

Use the command-line utility, idscfgdb, 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:

Do not set the DB2COMM environment variable when you configure a database.
Stop the directory server. See Starting or stopping a directory server and an administration server with command-line utilities.
A system user ID must exist to own the DB2 database instance. For more information about system user ID requirements, see Users and groups that are associated with a directory server instance.

You can run the idscfgdb command to complete the following operations:

Creates and configures database to a directory server instance. Creates local loopback settings, if they do not exist.
Adds information about the database to the ibmslapd.conf file of the directory server instance

You can specify whether to create the database as a local code page database or as a UTF-8 database, which is the default.

Log in as directory server instance owner.
Access the command prompt.
Change the current working directory to the sbin subdirectory in the IBM® Security Verify Directory installation location.
To configure a DB2 database to a directory server instance with the following values, run the following command:
- Instance name: ldapdb
- Database name: ldapdb
- DB2 database administrator ID: ldapdb
- DB2 database administrator password: ldapdb123
- Database location: /home/ldapdb
```
idscfgdb -I ldapdb -a ldapdb -w ldapdb123 -t ldapdb
-l /home/ldapdb
```
On Windows™, specify the disk drive name for database location. For more information about the idscfgdb command, see Command Reference.
The command configures a database with automatic storage table spaces with default sizes. 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.

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