Installation and Upgrade Guides › Policy Server Installation Guide › Configuring SiteMinder Data Stores in a Relational Database › Relational Databases as a Policy or Key Store › IBM DB2 Schema Files

IBM DB2 Schema Files

The following SQL Server schema files are provided in the siteminder_home\db\tier2\DB2 directory.

siteminder_home

Specifies the Policy Server installation path.

sm_db2_ps.sql

Creates the schema for a policy store and key store.

Note: If you are storing keys in a different database, this schema file creates the schema for the key store data.

sm_db2_logs.sql

Creates the schema for SiteMinder audit logs.

sm_db2_ss.sql

Creates the schema for a SiteMinder session store.

smsampleusers_db2.sql

Creates the schema for a SiteMinder sample users database and populates the database with sample users.

The following IBM DB2 schema file is provided in the siteminder_home\xps\db directory.

DB2.sql

Creates the XPS schema for a policy store.

MySQL Schema Files

The following SQL Server schema files are provided in the siteminder_home\db\tier2\MySQL directory.

siteminder_home

Specifies the Policy Server installation path.

sm_mysql_ps.sql

Creates the schema for a policy store and key store.

Note: If you are storing keys in a different database, this schema file creates the schema for the key store data.

sm_mysql_logs.sql

Creates the schema for the audit logs.

sm_mysql_ss.sql

Creates the schema for a session store.

smsampleusers_mysql.sql

Creates the schema for a sample users database and populates the database with sample users.

The following MySQL schema file is in the siteminder_home\xps\db directory.

MySQL.sql

Creates the XPS schema for a policy store.

SQL Server Schema Files

The following SQL Server schema files are provided in the siteminder_home\db\SQL directory:

siteminder_home

Specifies the Policy Server installation path.

sm_mssql_ps.sql

Creates the schema for a policy store and key store.

Note: If you are storing keys in a different database, this schema file creates the schema for the key store data.

sm_mssql_logs.sql

Creates the schema for the audit logs.

sm_mssql_ss.sql

Creates the schema for a session store.

Note: If you do not plan on storing Unicode characters in the session store, use this file.

sm_mssql_ss.sql.unicode

Creates the schema for the SiteMinder session store.

Note: If you plan on storing Unicode characters in the session store, use this file.

smsampleusers_sqlserver.sql

Creates the schema for the SiteMinder sample users database and populates the database with sample users.

The following SQL Server schema file is provided in siteminder_home\xps\db:

SQLServer.sql

Creates the XPS schema for a policy store.

Oracle Schema Files

The following Oracle schema files are in the siteminder_home\db\SQL directory.

siteminder_home

Specifies the Policy Server installation path.

sm_oracle_ps.sql

Creates the schema for a policy store and key store.

Note: If you are storing keys in a different database, this schema file creates the schema for the key store data.

sm_oracle_logs.sql

Creates the schema for the audit logs.

sm_oracle_ss.sql

Creates the schema for a session store.

smsampleusers_oracle.sql

Creates the schema for a sample users database and populates the database with sample users.

The following Oracle schema file is provided in the policy_server_home\xps\db directory.

Oracle.sql

Creates the XPS schema for a policy store.