Software Delivery › Tasks › Optimization of Database Updates › How to Optimize Database Transactions › Configure Optimized Transaction Configuration Policies for IM

Configure Optimized Transaction Configuration Policies for IM

You can configure the optimized transaction policies for the Installation Manager. The configuration lets the Installation Manager update the database with few large transactions instead of multiple single transactions. The Installation Manager accepts the bulk message, processes each submessage included in the bulk message, and updates the database in one transaction. You must apply these policies to the domain manager.

To configure the optimized transaction configuration policy

1. Navigate to Control Panel, Configuration, Configuration Policy, policy name, DSM, Software Delivery, Manager.

   A list of configuration policies appears.

2. Double-click the following policies, and enter appropriate information in the Setting Properties dialog:

   Optimized Transaction: Enabled

   Specifies whether to use the optimized transaction on the Installation Manager to update the job status messages and the software records in bulk. When set to True, the Installation Manager processes and completes the database update of the job status messages and the software records in bulk. When set to False, the Installation Manager processes and completes the database update of each message individually. For optimizing database updates, set the value to True.

   Default: True

   Optimized Transaction: Minimum Lock Percent

   Specifies the minimum percentage of job container and job locks to acquire before the Installation Manager can process the job status messages in bulk. The policy is applicable only for the bulk database updates of the job status messages. While processing the job status messages in bulk, if the Installation Manager gets less than 100% of locks but more than the minimum percentage of locks, the Installation Manager processes all the messages for which it has received the locks, and sends the remaining messages back to the Installation Manager queue. However, if the Installation Manager does not get the minimum percentage of locks, it sends all the received job status messages back to the Installation Manager queue for update in the next try.

   Default: 50

   Limits: 1 to 100

   Note: We recommend that you change the value of the Minimum Lock Percent policy only when you see a message about the unavailability of sufficient locks in the Installation Manager log.

3. Click OK.

   The optimized transaction policies are configured.

More information:

How to Optimize Database Transactions

Configure Bulk Update Configuration Policies for SS