IFS Data Synchronization (FNDRPL) has a set of Database Tasks which performs processing and cleanup jobs. Also there are two separate Batch Queues used to process data synchronization related background jobs.
The following database tasks are included in IFS Applications to perform processing and cleanup jobs in Data Synchronization.
| Task Name | Description |
|---|---|
| Restart Data Synchronization Messages | Restarts Failed Data Synchronization Messages in any Data Synchronization Queue. When number of restarts reaches to 'MAX_ATTEMPTS', it sends a notification to authorized person. Suggested value for MAX_ATTEMPTS is 5. |
| Cleanup Data Synchronization Message Queues | Removes
Application messages that are in given queues with given states older
than given number of seconds.
List of Queues can be given by separated from comma or semi colon as below. Example: REPL_IN,REPl_OUT or REPL_IN;REPL_OUT List of States can be given by Separated from comma or semi colon as below. Example: Finished,Waiting or Finished;Waiting or ANY Suggested number of seconds is 86400. COMMIT_COUNT indicates that it reads number of rows from the tables and store them internally in memory during processing to minimize the switch between PLSQL and SQL engines. Suggested value for this parameter is 10000. If needs to reclaim Lob space or table space from deleted Data Synchronization Messages, SHRINK_LOBS_ and SHRINK_SPACE parameters can be set to 'YES' or 'Y' |
| Reclaim Lob Space from deleted Data Synchronization Messages | Updates and delete lobs within a lob space can creates pockets of empty space that are individually are not large enough to be reused for new lobs. This types of empty spaces can result in much wasted space. This particular database task reclaim that types of wasted empty lob spaces. |
| Reorganize Data Synchronization Messages tables | Reorganizes the tables like FNDCN_APPLICATION_MESSAGE_TAB which contains large amount of records and especially after lot of rows have been deleted from such tables. |
| Cleanup Data Synchronization Buffer table and Lob Buffer table |
Removes
Processed records from REPL_BUFFER_TAB and REPL_LOB_BUFFER_TAB.
Records of REPL_LOB_BUFFER_TAB are removed when that are older than given days. Suggested number of KEEP_DAYS_OLD_LOBS is 6. Suggested value for COMMIT_COUNT is 10000. If needs to reclaim Lob space or table space from deleted Data Synchronization Messages, SHRINK_LOBS_ and SHRINK_SPACE parameters can be set to 'YES' or 'Y' |
| Send LOB Data | Process rows with state 'Released' from REPL_LOB_BUFFER_TAB to create application messages for sending LOBs . |
| Restart Data Synchronization LOB messages | Restarts Failed Lob messages in LOB OUT or IN queues. |
| Forward Data Synchronization Statistics | Inserts statistics of queues to statistic tables in Data Synchronization. Used by the administrator lobby. |
| Cleanup Data Synchronization Statistics Tables |
Removes rows from statistic tables that are older than given days.
Suggested value for DAYS_OLD_ is 5. Suggested value for COMMIT_COUNT is 10000. |
It is recommended to schedule above tasks to ensure optimal performance of IFS Applications.
These all Tasks except "Cleanup Data Synchronization Buffer table and Lob Buffer table" will be processed by the Batch Queue Data Synchronization Batch Queue.
Task "Cleanup Data Synchronization Buffer table and Lob Buffer table" will be processed by the Batch Queue Data Synchronization Processing.
IFS Data Synchronization provides two batch queues to process background jobs related to synchronization
Execution frequency of the background jobs can be configured using number of processes and Execution Plan. These are to be setup in accordance with the requirements.
More information on Batch Queue Configuration can be found here.