Data Synchronization Batch Jobs¶
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.
- Database tasks
- Batch Queues
Database Tasks¶
The following database tasks are included in IFS Cloud 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. |
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 Cloud.
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.
Batch Queues¶
IFS Data Synchronization provides two batch queues to process background jobs related to synchronization
- Data Synchronization Processing - This batch queue is used to process background jobs related to processing buffer/cleanup of buffers/password synchronization in data synchronization framework.
- Data Synchronization Batch Queue - This is used to process background jobs related to support tasks in data synchronization framework such as connect message cleanup, connect message restart routines, shrinking LOB space, etc.
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.