Menu Path: System Administration Utilities Purge Data Utility
Purge and archive old data.
Use Purge Data Utility to purge old, unused records from the database. Records can also be optionally archived. This frees up space in the database and could help with performance-related issues. Purge history is maintained.
NOTE No users should be in the system when purging data. It is strongly recommended to run Purge Data Utility in your Test environment first so that you can check the size and the outcome/effect of the purge.
Note Before purging data, back up your database so you can create a historical database if necessary. You may also want to analyze the size of each table in your database to determine the data you want to purge.
To purge data:
Click the Lookup button to the right of the Record field, and select the data you want to purge.
Enter the date before which you want to purge data in the Purge Records Prior to field.
Enter a reason for the purge in the Purge Reason field.
If you want to save the purged data in a TXT file, select the Keep an Archive File check box, and enter the folder path and file name for the file in the Archive File field.
Click the Print Options tab, and select whether to process using Scheduling Assistant. If you select to process using Scheduling Assistant, select the schedule for the task.
Click the OK button in the ribbon. The Question dialog box appears, and asks you to confirm whether you want to purge data.
Click the Yes button. The purge is completed.
Button |
Description |
Exit |
Click this button to close the Purge Data Utility window. |
OK |
Click this button to purge data. |
Field or Button |
Description |
Click the Lookup button to select the record type to purge. Select one of the following options:
|
|
Enter a cut-off date for the purge, or click the drop-down arrow to select a date. |
|
Enter a description of the reason for the purge. |
|
Select this check box to keep purged data in one or more files for future reference. Purged data is saved in a text file in the location you enter in the Archive File field. This check box is disabled when purging credit card data. |
|
Enter a file name for the archive file(s) and the location on the appserver to save the file(s). This field is only enabled if you select the Keep an Archive File check box. Note One archive file is created for each table that contains the purged data. Multiple archive files are created if you purge data stored in multiple tables. Each table name is appended to the file name you enter. Example If you are purging mail, and you enter C:\Archive\MailPurge, the purged data is stored in C:\Archive\MailPurge mail. |
|
Select this check box to delete data from the wms-pick-hdr, wms-proc-order, wms-raw-data, wms-pick-trl, wms-pick-pkg, wms-pick-tag, wms-pick-charge, wms-pick-note, and wms-pick-remark tables. This check box is only available if you select WMS Imports for the Record field. |
|
Select this check box to delete data from the wms-pick-cancel and wms-raw-data tables. This check box is only available if you select WMS Imports for the Record field. |
|
Select this check box to delete data from the wms-receipt-count-create, wms-receipt-count-entry, wms-receipt-count-complete, and wms-raw-data tables. This check box is only available if you select WMS Imports for the Record field. |
|
Select this check box to delete data from the wms-receipt-hdr, wms-raw-data, wms-receipt-trl, and wms-receipt-charge tables. This check box is only available if you select WMS Imports for the Record field. |
|
Select this check box to delete data from the wms-mfg-cancel and wms-raw-data tables. This check box is only available if you select WMS Imports for the Record field. |
|
Select this check box to delete data from the wms-mfg-hdr, wms-raw-data, and wms-mfg-trl tables. This check box is only available if you select WMS Imports for the Record field. |
|
Select this check box to delete data from the wms-wo-hdr, wms-raw-data, wms-wo-cost, wms-wo-trl, and wms-wo-cost tables. This check box is only available if you select WMS Imports for the Record field. |
|
Select this check box to delete data from the wms-return-receipt-hdr and wms-raw-data tables. This check box is only available if you select WMS Imports for the Record field. |
|
Select this check box to delete data from the wms-inv-adj and wms-raw-data tables. This check box is only available if you select WMS Imports for the Record field. |
|
Select this check box to delete data from the wms-bin-move and wms-raw-data tables. This check box is only available if you select WMS Imports for the Record field. |
|
Select this check box to delete data from the wms-loc-trans and wms-raw-data tables. This check box is only available if you select WMS Imports for the Record field. |
|
Select this check box to delete data from the wms-qoh-comp and wms-raw-data tables. This check box is only available if you select WMS Imports for the Record field. |
|
Select this check box to delete data from the wms-status and wms-raw-data tables. This check box is only available if you select WMS Imports for the Record field. |
|
Select this check box to delete data from the wms-confirm and wms-raw-data tables. This check box is only available if you select WMS Imports for the Record field. |
|
Select this check box to delete data from the wms-pkg-confirm and wms-raw-data tables. This check box is only available if you select WMS Imports for the Record field. |
|
Select this check box to delete data from the wms-wo-inv-adj and wms-raw-data tables. This check box is only available if you select WMS Imports for the Record field. |
|
This field displays the date the selected record was last purged. |
|
This field displays the cut-off date for the last purge of the selected record. |
|
This field displays the user ID of the person that last purged the selected record. |
|
This field displays the reason of the last purge for the selected record. |
|
This field displays the file name of the last archive file. |
Field or Button |
Description |
The File radio button is selected to indicate you can only output purged records to an archive file. |
|
Select whether the data purge is run now or run by Scheduling Assistant. If you select the Schedule radio button, you can specify when the process occurs. These radio buttons are only enabled if the Disable Scheduling Assistant check box is cleared for your user ID in User Profile Maintenance. |
|
Time |
|
Date |
|
Task Occurs |
Select one of the following options:
These radio buttons are only enabled if you select the Schedule radio button. |
Frequency |
These radio buttons are only available if you select the Every radio button. |
Day of Week |
|
Repeat Every X Days |
|
Repeat On |
|
Repeat Every X Minutes |
|
Triggering Task Id |
|
Triggering Task Name |
|
Triggering Task Description |
|
Task Description |
|
Scheduling Assistant Queue |
Enter an active Scheduling Assistant queue for the task, or click the Lookup button to select a Scheduling Assistant queue. This defaults to the default queue for your user ID. This field is only enabled if you select the Schedule radio button, and you are assigned to a queue other than the Default queue. |
External Email |
|
Screen Alert |
|
Internal Email |