Delete SiteMinder Data in ODBC Databases

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

sm_oracle_ps_delete.sql: Removes the CA SiteMinder® policy store and data from an Oracle database.
sm_oracle_logs_delete.sql: If the database was created using sm_oracle_logs.sql, removes CA SiteMinder® logs stored in an Oracle database
sm_oracle_ss_delete.sql: Removes the CA SiteMinder® session store tables and data from an Oracle database.
sm_mssql_ps_delete.sql: Removes the CA SiteMinder® policy store and data from an SQL database.
sm_mssql_logs_delete.sql: If the database was created using sm_mssql_logs.sql, removes CA SiteMinder® logs stored in an SQL database
sm_mssql_ss_delete.sql: Removes the CA SiteMinder® session store tables and data from a SQL database.
sm_db2_ps_delete.sql: Removes the CA SiteMinder® policy store and data from a DB2 database.
sm_db2_logs_delete.sql: If the database was created using sm_db2_logs.sql, removes CA SiteMinder® logs stored in a DB2 database
sm_db2_ss_delete.sql: Removes the CA SiteMinder® session store 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.