Optimize 10.11 | webMethods Optimize Documentation | Administering webMethods Optimize | For Database Administrators | Purging Data from Optimize Database Components | Using Data Purge | Running Data Purge | Resetting Referential Constraints if Data Purge Fails on DB2
 
Resetting Referential Constraints if Data Purge Fails on DB2
If the Data Purge fails or is canceled by the user, there is a chance the referential constraints were not re-enabled. Use the following command sequence to enable them.
*To reset referential constraints
1. (Windows Only:) db2cmd (Skip this step if running on UNIX.)
2. db2 connect to[dbname] user [username] using [password]
3. db2 set path[Analysis Schema or Process Tracker Schema], SYSTEM
4. db2 set current schema [Analysis Schema or Process Tracker Schema]
5. Initiate the purge:
*Windows:
db2 call db_mgmt_modify_dependant_fk_constraints_all ('ENFORCED')
*UNIX:
db2 "call db_mgmt_modify_dependant_fk_constraints_all ('ENFORCED')"