G.6 Operating System-Level Tuning

The operating system level performance tuning is related to Semaphores and shared memory settings.

• Semaphores: Linux Semaphore settings must be set to optimal under the SEMMSL configuration value.
• Shared Memory: ALM Engine consumes shared memory during any ALM process execution hence it is crucial to check the availability of current shared memory and tune it accordingly. Shared memory kernel parameters must be set to optimal. The configuration file (ofsrm.ini).

Sometimes users may observe an out of shared memory error reported in ALM Engine log files during process execution. In such cases, one needs to verify and update shared memory size by updating the SharedMemory parameter that can be found in the ofsrm.ini file which is located in $FIC_DB_HOME/conf. The default value of this parameter is 16500 (KB).

• Database-Level Tuning
  Database Level performance tuning describes a group of activities used to optimize and standardize the performance of a database. This can be improved using the following options:
• Recommendations for Performance Improvement
  While configuring an ALM process users can choose to output detailed cash flows (either all or partial). This data is stored in the FSI_O_PROCESS_CASH_FLOWS table. When a process is re-run either for the same as of the date or for a different date, existing data for that process is first deleted before new calculations begin. When the volume of data is high this can take time thereby impacting overall performance. The following recommendations will help improve this.