CNUM_SEQ_CACHE
Sequence Numbering Configuration
Summary
This attribute defines the number of case numbers to be cached.
Applies To
This attribute can be set for the BG, SWBATCH, WIS, SPO, SSOLITE or ALL processes.
Default Value
The attribute is assigned the following default values when iProcess Engine is installed.
|
Machine ID |
Process |
Instance |
Value |
|
0 |
BG |
0 |
50 |
|
0 |
SWBATCH |
0 |
5 |
|
0 |
WIS |
0 |
50 |
|
0 |
SPO |
0 |
5 |
|
0 |
SSOLITE |
0 |
5 (Oracle) or 10 (SQL and DB2) |
Notes
Case number caching can provide a performance benefit when applied to the BG, WIS, RPC_POOL, and SWBATCH processes. It should not be used with other processes. For more information see Sequence Number Caching.
If you use case number caching, you should note that it is possible for a lower case number to be started after a higher case number.
For example, suppose that a WIS process has 50 case numbers (1 to 50) cached, and a user uses the SWUTIL CSTART command to start a case. The case will have case number 51 - the next available number obtained from the cnum_sequence table.
However, if a user then starts a case through the WIS, that case will have case number 1 - the next available number in the cached sequence.
Thus, the start date/time for case number 1 will be later than the start date/time for case number 51.