Delete SiteMinder Data in ODBC Databases

SiteMinder provides SQL scripts that delete the SiteMinder schema from ODBC databases. The following list describes each SQL script:

sm_oracle_ps_delete.sql
Removes the SiteMinder 6.x policy store and data from an Oracle database.
sm_oracle_logs_delete.sql
Removes SiteMinder 6.x logs stored in an Oracle database if the database was created using sm_oracle_logs.sql.
sm_oracle_ss_delete.sql
Removes the SiteMinder 6.x Session Server tables and data from an Oracle database.
sm_mssql_ps_delete.sql
Removes the SiteMinder 6.x policy store and data from an SQL database.
sm_mssql_logs_delete.sql
Removes SiteMinder 6.x logs stored in an SQL database if the database was created using sm_mssql_logs.sql.
sm_mssql_ss_delete.sql
Removes the SiteMinder 6.x Session Server tables and data from a SQL database.
sm_db2_ps_delete.sql
Removes the SiteMinder 6.x policy store and data from a DB2 database.
sm_db2_logs_delete.sql
Removes SiteMinder 6.x logs stored in a DB2 database if the database was created using sm_db2_logs.sql.
sm_db2_ss_delete.sql
Removes the SiteMinder 6.x Session Server tables and data from a DB2 database.

The ODBC database SQL scripts are in the following location:

(Windows) siteminder_home\db
- siteminder_home
  Specifies the Policy Server installation path.
(UNIX) siteminder_home/db
- siteminder_home
  Specifies the Policy Server installation path.

Delete the database objects by running the appropriate SQL script using DB2, SQL Plus for Oracle, or SQL Server Query Analyzer.

Note: For more information about running SQL scripts, see your database documentation.