Previous Topic: How to Configure an IBM DB2 Database as a Data Store

Next Topic: Configure a DB2 Data Source for SiteMinder

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.
  2. Open the following file in a text editor and copy the contents of the entire file:
  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:

    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:

  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

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

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


Copyright © 2010 CA. All rights reserved. Email CA about this topic