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.
Note: This is only relevant if you have your LOB segments stored in basic files. Normally secured files are used. Execution interval of this database task fully depends on nature of the lob data used in the application. If there are large volume of lob data or large sized lob data, you can increase the execution frequency. But, it is highly recommended to execute this only in off peak hours. The reason for that is, when shrinking lob spaces of the tables, it acquires the locks of those tables and that may cause to hang all other active transactions for a long time. But, If you have regular lob data, you can schedule this database task to execute in once a month, in off peak hours. |
| 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. When number of restarts reaches to 'MAX_ATTEMPTS', it sends a notification to authorized person. Suggested value for MAX_ATTEMPTS is 5. |
| 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. |
| Cleanup Cofiguration Status Table |
Removes rows those are in given state and older than given days from configuration status table
Default value for LIST_OF_STATES_ is FINISHED, SKIPPED Default value for COMMIT_COUNT_ is 1000. Default value for SHRINK_LOBS_ is NO. Default value for SHRINK_SPACE_ is NO. Default value for KEEP_DAYS_OLD_LOBS_ is 5. |
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.