Installation and Upgrade Guides › Directory Configuration Guide › IBM DB2 › How to Configure a Data Store in an IBM DB2 Database › Step 1: Create a DB2 Database With SiteMinder Schema

Step 1: Create a DB2 Database With SiteMinder Schema

SiteMinder provides schema files to create schemas for storing policies, keys, logs, session data, and sample users. The following schema files are provided with this .zip file:

sm_db2_ps.sql

Creates the SiteMinder policy store or key store (if you are storing keys in a different database) in a DB2 database.

Note: When configuring a DB2 database as a policy store, you must create a tablespace with the 32-KB page size and a system temporary tablespace with the 32-KB page size for the user associated with the database.

sm_db2_logs.sql

Creates the schema for SiteMinder audit logs in a DB2 database.

sm_db2_ss.sql

Creates the schema for the Session Server in a DB2 database.

smsampleusers_db2.sql

(Optional) Creates the schema for SiteMinder sample users in a DB2 database and populates the database with sample users. For example, if you look in the script, you can see a sample user named GeorgeC with a password of siteminder.

Create the database objects by running the appropriate SQL script using IBM DB2.

To delete these database objects, refer to "Deleting SiteMinder Data in ODBC Databases" in the Policy Server Installation Guide.

You can store SiteMinder data in a single DB2 database or run each script on its own to create a separate:

• policy store
• key store
• logging database
• session store
• sample users database

Note: For information about running SQL scripts, refer to the DB2 database documentation.