Identity Director Setup and Sync Tool

This is not the latest version of Identity Director documentation.
View available documentation.

IBM DB2

Use the node Setup > Datastore to manage the Datastore connection settings of the Setup and Sync Tool.

Supported databases IBM DB2 databases

• IBM DB2 11.1
• IBM DB2 10.5
• IBM DB2 10.1
• IBM DB2 9.7

Prerequisites

Database

• An existing database and database user.
• The database user must be able to access a table space with a page size of at least 8k.
• The database must be created with the “Code Set” UTF-8 instead of the default IBM-1252.

Setup and Sync Tool and Management Portal

• IBM DB2 OLEDB provider (x64/x86)

Configuration

You can't create a Datastore on IBM DB2 with the Datastore Wizard: you manually need to create a database on the database server and then connect to it from the Setup and Sync Tool:

1. Create a local user on the DB2 Server, for example: IIDLU. This account is used to connect to the Datastore.
2. Manually create a database on the DB2 Server, for example: IID.
3. Create a table space for the user IIDLU in the IID database. Specify a buffer pool of at least 8KB.
4. Create a schema in the IID database, for example: identitydirector.
5. Add the user you created in step 1 to the database IID.
6. Assign the applicable authorities, and add the schema and table space you created in steps 3 and 4 to this user. Make sure you assign the proper privileges.

You can configure IBM DB2 database servers to listen on a different port than the default one.

This Datastore type will be deprecated in a next release of Identity Director

See also

• Specify alternative ports for Microsoft SQL Server and IBM DB2