Purging Orders Within a Given Time Period and Matching Order Type

Use this feature of the purge utility to clean up your database by removing old or irrelevant orders within any given period of time and having a particular order type.

Procedure

  1. Go to the command prompt.
  2. Change the directory to ${AF_HOME}/bin.
  3. Open the purgeorder.properties file using any text editor to edit the purge input parameters.
  4. Type 1 as your choice of operation.
  5. Type the START_DATE in the <MM-DD-YYYY'T'HH:MM:SS> format. For example, if the start date is March 21 2014 and time is 9:30 am then the format is: 
    START_DATE=03-21-2014T09:30:00
  6. Type the END_DATE in the <MM-DD-YYYY'T'HH:MM:SS> format. For example, if the start date is March 21 2014 and time is 6:30 pm then the format is: 
    END_DATE=03-21-2014T18:30:00
    Note: END_DATE must be greater than START_DATE.
  7. Type the ORDER_TYPE. For example, COMPLETE. 
    ORDER_TYPE=COMPLETE
    Note: You must specify valid order type. For example, either COMPLETE or CANCELLED. Invalid order type can result in execution error.
  8. Type the ARCHIVE. For example, false. 
    ARCHIVE=false
  9. Save the file.
  10. Execute the purgeorderservice.sh shell script.