Enable Seq cache explicitly in pureScale database for Maximo
zachzhang 270003DPUQ Visits (3178)
In a large scaled Maximo environment, some of us would use IBM DB2 pureScale database. As the more nodes you have, the more contentions there are on every kind of resources. Normally, Maximo is using Sequence object inside database to avoid the locking issues that are associated with other more heavier approaches In a standard database, Maximo usually cache some sequence values in memory to improve response time.
While in a DB2 pureScale environment, if both CACHE and ORDER are specified, the specification of ORDER overrides the specification of CACHE and instead NO CACHE will be in effect. So for most of sequences in Maxi
"ALTER SEQUENCE XXXX_SEQ CACHE 100 NO ORDER"