Consolidate additional inventory agent

This agent consolidates the quantity in the demand and supply additional records back into the base YFS_INVENTORY_DEMAND or YFS_INVENTORY_SUPPLY tables. The additional demand and supply records are deleted after the quantities are consolidated. If you enable the Hot SKU feature, you must run the Consolidate Additional Inventory agent.

Typically, you should configure this agent to run continuously with one thread. You need not aggressively schedule this agent. If you do, the agent consolidates a small number of additional records. At the same time, you do not want to run for long periods without this agent. If you do, you could accumulate a large number of inventory additional records, which can slow down inventory queries.

If you are using the Db2® database server, you need to set the parameter DB2_SKIPINSERTED to ON and mark the YFS_INVENTORY_SUPPLY_ADDNL and YFS_INVENTORY_DEMAND_ADDNL tables as volatile. These settings reduce lock contention. For more information, see the following sections:

Note: The Hot SKU feature is enabled by default. If Optimistic Lock Avoidance (OLA) is also enabled, the Consolidate additional inventory agent need not be run. If the Optimistic Lock Avoidance (OLA) is disabled, then the agent must be run.