Cisco Cisco Prime Service Catalog 10.0 Technical References
5-12
Cisco Prime Service Catalog 10.0 Configuration Guide
OL-31034-01
Chapter 5 System Administration
Performing Application Housekeeping
Requisition Purge
Overview
Service Catalog provides a transaction purge feature to delete transactions older than a chosen date or
that meet other user-specified criteria. This allows the application administrator to remove test
requisitions before deleting test users and sample services. The purge scripts may also be used for
housekeeping purposes to control the database size, for example, to delete older requisitions that no
longer need to be retained. However the purge scripts are not optimized for mass data deletion and should
be used with caution to avoid prolonged maintenance window.
that meet other user-specified criteria. This allows the application administrator to remove test
requisitions before deleting test users and sample services. The purge scripts may also be used for
housekeeping purposes to control the database size, for example, to delete older requisitions that no
longer need to be retained. However the purge scripts are not optimized for mass data deletion and should
be used with caution to avoid prolonged maintenance window.
Prerequisite software for the purge utility is a database client on the machine where the purge scripts are
to be executed. For Oracle, “sqlplus” has to be installed and configured to connect to the RequestCenter
database; for SQL Server, “osql” is required.
to be executed. For Oracle, “sqlplus” has to be installed and configured to connect to the RequestCenter
database; for SQL Server, “osql” is required.
Preparations
Step 1
Make a backup of the RequestCenter database before executing the purge scripts.
Step 2
Stop the Request Center and Service Link services while the purge scripts are executed.
Step 3
Locate the utility in:
<APP_HOME>\schema\util\purge
Step 4
If the machine where <APP_HOME> resides has the prerequisite database client software, then you can
execute the purge scripts from this machine. Otherwise, copy the entire purge folder to the machine
where the RequestCenter database is located, or to another machine that has the prerequisite database
client.
execute the purge scripts from this machine. Otherwise, copy the entire purge folder to the machine
where the RequestCenter database is located, or to another machine that has the prerequisite database
client.
Step 5
Verify that the purge folder contains the following files:
•
AddPurgeFilter.bat
•
AddPurgeFilter.sh
•
ClearAllPurgeFilter.bat
•
ClearAllPurgeFilter.sh
•
PurgeRequisitions.bat
•
PurgeRequisitions.sh
Step 6
Execute the .bat files if you are on Windows operating system, or the .sh files if you are on UNIX or
Linux operating system.
Linux operating system.
Caution
If you have applied any Service Catalog service packs, repeat Steps 3 and 4 above, to ensure that you
use the latest version of the purge scripts, as the scripts may be modified as part of the service packs.
use the latest version of the purge scripts, as the scripts may be modified as part of the service packs.
Using the Scripts
To define and execute the requisition purge: