Configuration for Hot SKU feature

Hot SKU is a feature that increases performance by lowering lock contention on the YFS_INVENTORY_ITEM table. The Hot SKU feature is enabled by default for the IBM® Sterling Order Management System on cloud. The following Hot SKU configurations are set with default values in the yfs.properties_inv_ext.in file.


    yfs.hotsku.useHotSKUFeature=Y
    yfs.hotsku.assumeUnavailableOnLockTimeout=N
    yfs.hotsku.highRequestQuantityMultiplier=5
    yfs.hotsku.qtyMultiplier=10
    yfs.hotsku.numRequestsInTrackingWindowToKeepAsHotSku=1
    yfs.hotsku.numberOfAbnormalLocksForSwitchToHotSKU=2
    yfs.hotsku.registerAvailabilityOnLockTimeout=N
    yfs.hotsku.secondsToClassifyAsAbnormalTime=0.10
    yfs.hotsku.useTimeOutLocking=Y
    yfs.hotsku.windowTimeInMinutes=600
    yfs.hotsku.maxItemMapSizeInMemory=10000
    yfs.hotsku.showExtraMessagesAsInfo=N
    yfs.hotsku.lockItemOnInventoryChanges=N
    yfs.hotsku.lockOnlyOnLowAvailability=Y
    yfs.hotsku.useGranularLockingForItem=Y

The Hot SKU configurations ensure that the hot items can have their supplies and demands inserted in the *_ADDNL tables.

Tip: The Hot SKU properties are database enabled. You can override the value of these properties by using the Property Management user interface. For more information, see Managing properties in the database using the System Management Administrator.

To disable the feature, set yfs.hotsku.useHotSKUFeature=N.