Database Purges
Plant Applications provides a Unified Manufacturing Database (UMDB) that combines a Workflow (SOA) database with a Plant Applications database.
Purging data reduces the amount of used space in the database. It does not reduce the size of the database. For instructions to reduce the size of the database, consult SQL Server documentation.
Purging the database is a two-step process involving the Plant Applications and SOA purge utilities. Contact Support at https://digitalsupport.ge.com/ for more information.
- Perform online purges to Plant Applications databases before upgrading.
- For sites using only the Plant Applications data model, you can perform cursor purges to trim the database as an interim solution.
- For sites incorporating both the Plant Applications and S95 data models, do not purge the Plant Applications database. Doing so orphans data in the SOA environment, and can introduce other issues.
You can use the Plant Applications Purge Utilities to conduct database purges online or offline. When creating an online purge plan, you should perform an initial database purge based on your site’s desired retention limit. For more information, see KB14802 on https://digitalsupport.ge.com/.