DB2
Execute the following procedure from the command line where DB2 has been installed:
To run Data Purge in DB2
1. Windows Only: db2cmd (skip this step if running on UNIX)
2. db2 connect to [dbname] user [username] using [password]
where:
[
dbname] is the DB2 database containing the Analysis database component and/or the Process Tracker database component.
[
username] [
password] are the credentials for accessing the DB2 database listed above and access to the schemas containing the Analysis and Process Tracker database components.
[
analysis or process tracker schema name] is the schema containing the Analysis and/or Process Tracker tables.
3. db2 set path [Analysis Schema or Process Tracker Schema], SYSTEM
where [analysis or process tracker schema name] is the schema containing the Analysis and/or Process Tracker tables.
4. db2 set current schema [Analysis Schema or Process Tracker Schema]
where [analysis or process tracker schema name] is the schema containing the Analysis and/or Process Tracker tables.
5. Initiate the purge:
Windows:
db2 call data_mgmt_purge_data()
UNIX:
db2 "call data_mgmt_purge_data()"
Important:
If the Analysis and Process Tracker database components are in separate schemas, the Data Purge must be executed in each schema separately.