Installation and Upgrade Guides › Directory Configuration Guide › IBM DB2 › How to Configure an IBM DB2 Database as a Data Store › Create a DB2 Database with SiteMinder Schema

Create a DB2 Database with SiteMinder Schema

You can create one or more SiteMinder schemas in a DB2 database.

To create SiteMinder schemas in a DB2 database

1. Navigate to dir_config_home\ibmdb2.
   • dir_config_home

     Specifies the Directory Configuration installation path.

2. Open the following file in a text editor and copy the contents of the entire file:
   • sm_db2_ps.sql

     Specifies the schema for a policy or key store in a DB2 database.

3. Paste the file contents into a query, and execute the query.

   The policy or key store schema is created in the DB2 database.

4. (Optional) Repeat steps two and three to create audit log, token store, session server, or sample users schema in the DB2 database:
   • sm_db2_logs.sql

     Specifies the schema for an audit log store in a DB2 database.

   • sm_db2_token.sql

     Specifies the schema for a token store in a DB2 database.

   • sm_db2_ss.sql

     Specifies the schema for a session server in a DB2 database.

   • smsampleusers_db2.sql

     Specifies the schema for sample users in a DB2 database and populates the database with the sample users.

   The corresponding SiteMinder schema is created in the DB2 database.

   Note: You can create multiple SiteMinder schemas in a single DB2 database or create each schema in a separate database, optionally creating the following stores:

   • policy store
   • key store
   • audit logging store
   • token store
   • session store
   • sample users store
5. Open the following XPS schema file in a text editor and copy the contents of the entire file:

   policy_server_home/xps/db/DB2.sql

   • policy_server_home

     Specifies the Policy Server installation path.

6. Paste the file contents into a query, and execute the query.

   The policy store schema is created for r12.0 SP2.