Configuration 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

To create SOA Security Manager schema in a DB2 database

1. Navigate to path\ibmdb2.

   path

   Specifies the path to the schema files extracted from the tier 2 directory zip.

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 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 SOA Security Manager schema is created in the DB2 database.

   Note: You can create multiple SOA Security Manager 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
5. Copy the following XPS schema file to the DB2 host system:

   path\xps\db\DB2.sql

   path

   Specifies the path to the schema files extracted from the tier 2 directory zip.

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