7 System Maintenance Tasks

You can run system processes to maintain and clean up all runtime artifacts, such as the Process tables, Staging tables or inbox/outbox folders. Often the tables and folders contain vast amounts of data, which you may no longer need. With the System Maintenance Tasks feature, you can purge standard tables and folder by scheduling system processes and executing them in the EPM Platform Job Scheduler.

Note:

All applications not assigned to a folder are purged when a single application is selected for a purge. The default application folder is generic, and the purge script focuses on the folder in which the selected application resides. In this case if you want to prevent an application from being purged, save it to an independent folder.

To facilitate the use of the Purge Scripts, Data Management provides the following:

• A set of custom scripts is shipped to the bin/system directory.

  The scripts include:

  • Partition Data Load Staging Tables

  • Delete Integration (DeleteIntegration.py)

  • Maintain Application FolderExport Setup Table Data (TableExport.py)

  • List Table Rowcount

  • Maintain Application Folder (MaintainApplication Folder.py)

  • Maintain Data Table by Location (MaintainFDMEEDatatables.py)

  • Maintain Data Table by Application (MaintainFDMEEDatatables.py)

  • Maintain Process Table (MaintainProcessTables.py)

  • Maintain Setup Table (MaintainSetupData.py)

  • Migrating Schedules to EPM Platform Job Scheduler

  • Purge All Imported Data (PurgeAllData.py)

  • Upgrade Custom Applications (UpgradeCustomApp.py)

  • Reallocate Tablespace

  • Reset Environment

• Scripts are registered as system scripts in script registration.

• Script are registered as part of installation with QUERYID = 0 and APPLICATIONID = 0.

• The script group "System" is created and system scripts are assigned to it.

• Script execution displays system scripts when the user has access irrespective of the target application in the POV.

• The ODI process executes the scripts from the bin/system directory instead of the data/scripts/custom directory.