Question & Answer
Question
Can one use the ‘useTimeOutLocking’ HotSku parameter in a scenario showing an occurrence of Inventory Lock contention?
Answer
The Performance Management Guide documents that one can
configure the HotSku parameter ‘yfs.hotsku.useTimeOutLocking=Y’ if
the application processes a high volume of large orders (more than 50 order
lines per order).
In this scenario, the Inventory Lock
Contention is very high and one may see blocking issues on YFS_INVENTORY_ITEM
table.
There are also incidents where
orders take too long to process. This may be due to the complexity of the
process involved. This scenario can result in higher time taken for the order
processing eventually leading to Inventory Lock Contention.
As far as possible, one should avoid longer order processing
time. In the eventuality, that longer order processing times are unavoidable,
one can use the HotSku parameter ‘yfs.hotsku.useTimeOutLocking’.
Set this parameter to ‘Y’ to avoid the situation of blocking locks
as a workaround. One needs to have also enabled the ‘HotSku’
feature in their environment.
Since the
process has to be analyzed to verify whether the additional time for the order
processing can be reduced, it is recommended that turning-on the
‘yfs.hotsku.useTimeOutLocking=Y’ HotSku be done only after
receiving suggestions from Sterling Commerce Support to implement the
same.
The complete set of parameters that
one needs to configure for longer order processing is as below:
yfs.hotsku.useHotSKUFeature=Y
yfs.hotsku.useTimeOutLocking=Y
yfs.hotsku.numberOfAbnormalLocksForSwitchToHotSKU=3
yfs.hotsku.windowTimeInMinutes=5.0
yfs.hotsku.numRequestsInTrackingWindowToKeepAsHotSku=5
Please also refer Performance Management Guide v7.11 for
more details on these parameters.
[{"Product":{"code":"SS6PEW","label":"IBM Sterling Order Management"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Historical Number
FAQ3803
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21518315