Creating the DB2 database

For IBM® DB2®, you must create the database for IBM Security Access Manager for Enterprise Single Sign-On.

1. Click Start > All Programs > IBM DB2 > Profile instance name (default) > General Administration Tools > Control Center.
2. If the Control Center View dialog box is displayed, click Advanced.
3. Click OK.
4. In the Control Center tree pane, expand and select All Databases.
5. Right-click All Databases.
6. Select Create Database > Standard.
7. Enter the following DB2 configuration parameters:

   Database name

   Specify a name for the database. For example: imsdb.

   Default path

   Use the default value or specify an alternative path to store the database. For example: the default is c:\.

   Default buffer pool and table space page size

   Change the default value of 4K to 8K.

   Important: You must specify the buffer pool and page size as 8 K.

8. Click Next.
9. In the Specify where to store your data panel, accept the default values.
10. Click Next.
11. In the Specify the locale for this database panel, specify the following options:

    Country/Region

    Use the Default option.

    Territory

    Type US. Default is US.

    Code set

    Select UTF-8 code set.

    Important: You must specify a UTF-8 code set.

12. Click Next.
13. Review the summary of configuration parameters used to create the database.
14. Click Finish.
15. After the database is created, click Close.
16. Verify that the database is created successfully. In the Control Center tree pane, expand All Databases. The database you created for IBM Security Access Manager for Enterprise Single Sign-On is displayed.