Optimize 10.5 | webMethods Optimize Documentation | Administering webMethods Optimize | For Database Administrators | Purging Data from Optimize Database Components | Using Data Purge | Running Data Purge | DB2
 
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.