Archive by Executing Shell Script

Complete the following steps to archive data from AAI_WF_PROCESS_ENGINE_ACT_QUE & AAI_WF_PROCESS_ENGINE_ACT_HIST table, by executing a Shell Script.

1. Login to the Server where OFSAAI installed.
2. Go to Bin directory
   cd $FIC_DB_HOME/bin
3. Execute wfEngineActDataArchive.sh as shown below.
   Syntax
   nohup ./wfEngineActDataArchive.sh INPUT1 INPUT2 INPUT3 INPUT4 <Date – YYYYMMDD> "<No. of records to be left from the latest N-order>"<table to be archived,QUE/HIS>" &
   Example:
   nohup ./wfEngineActDataArchive.sh INPUT1 INPUT2 INPUT3 INPUT4 20200115 "2,QUE" &

   Note:

   • The first 4 input entries (Input 1 to Input 4) are dummy inputs hence you can provide any value.
   • 5th parameter (Date -YYYYMMDD) is Date in the format of YYYYMMDD
   • 6th parameter (<table to be archived, QUE/HIS>) is to indicate which table has to be archived (QUE or HIST) & the number of records to be excluded from latest N_ORDER