iSeries QLIBLCKLVL Value detail
I am researching the optimum performance setting for Library Locking Level on our system. I have an 820, approximately 1500 users, 1tb of storage of which approx. 66% used. I have found articles and recommendations for both settings (do not lock and lock). My current setting is 1. Can anyone provide detail on what this setting actually does, and the pros and cons for each setting? Thank you in advance, Kim
[!-- / message --] Software/Hardware used:
iSeries OS400
ASKED:
March 31, 2010 2:43 PM
UPDATED:
April 3, 2010 12:42 AM
Answer Wiki:
Performance involves a trade-off. The <i>optimum performance setting</i> will depend on how much <b>you</b> are willing to trade.
Best performance will be with QLIBLCKLVL set to '0'. That trades a performance boost for some drop in security (as in anxiety level, mostly; but also some protection).
I'm not sure anyone can help you with "optimum". Without detailed knowledge of your system environment, no one knows. A setting of '0' performs better than a setting of '1'. That's about the limit of what an outsider can say.
Tom
To see all answers submitted to the Answer Wiki: View Answer History.
IMO, a big factor would be whether or not any development goes on in that system. A clean production environment shouldn’t have any code running that would “accidentally” delete or rename libraries. But developers…?
A second factor would simply be the degree of security desired. That’s first “security” more in the sense of an atmosphere of ‘secure’ comfort, rather than ‘secure’ lock-down. However, regulated agencies or industries and similar situations might choose the trade-off for some small added protection.
Note that IBM classifies QLIBLCKLVL as a performance setting. Establishment of locks always takes time.
Tom