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

Follow these steps:

1. Log in to the Policy Server host system.
2. Navigate to siteminder_home\db\tier2\DB2.

   siteminder_home

   Specifies the Policy Server installation path.

3. 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.

4. Paste the file contents into a query and execute the query.

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

5. (Optional) Repeat steps two and three to create the audit log, 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_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 schema to a single DB2 database or create each schema in a separate database, optionally creating the following stores:

   • policy store
   • key store
   • audit logging store
   • session store
   • sample users store
6. Copy the following XPS schema file to the DB2 host system:

   siteminder_home\xps\db\tier2\db2\DB2.sql

7. Open a command prompt and run the following command:

   db2 -td@ [-v] -f path\DB2.sql
   

   path

   Specifies the path to the DB2 schema file.

   The policy store schema is created.