Open topic with navigation

TIBCO iProcess® Engine 11.9.1

# 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.

## See Also

REQID_SEQ_CACHE, WIS_INDEX_REFRESH

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO iProcess® Engine

Copyright © 1994-2024. Cloud Software Group, Inc. All Rights Reserved.