Copyright © TIBCO Software Inc. All rights reserved.
Copyright © TIBCO Software Inc. All rights reserved.


Chapter 7 Cases : casenum_gaps

casenum_gaps
The casenum_gaps table holds the free case number gaps.
If the case number or the subcase number generated from the sequence table reaches the maximum case number, 4294967295, then the following cases cannot be started. This table is used to create more available case numbers by reusing previous blocks of case numbers, which are no longer exist. The free case numbers are available either because the case numbers have never been used or from the original cases that have been purged.
TIBCO iProcess Engine checks the casenum_gaps table to find out whether there are any free case numbers available for reuse before allocating a sequence from the end of the case numbers.
The CASENUM_FIND_GAPS stored procedure adds a list of free case number gaps to the casenum_gaps table, it scans a range of case numbers and create available blocks of free case numbers for reuse. See CASENUM_FIND_GAPS for more information.
This table is not populated by the system and it remains empty unless the CASENUM_FIND_GAPS stored procedure is running to populate it.
Structure
The casenum_gaps table has the following structure:
TABLE casenum_gaps(
casenum_min
bigint NOT NULL,
casenum_max bigint NOT NULL)
Primary Key
The following primary key is defined for this table.
Foreign Keys
None.
Triggers
None.
Indexes
None.
Table Activity
The casenum_gaps table contains one or more rows for each instance of each procedure definition on the system. Rows are added, updated, and deleted in the following situations.
running the CASENUM_FIND_GAPS stored procedure.
See Also
CASENUM_FIND_GAPS

Copyright © TIBCO Software Inc. All rights reserved.
Copyright © TIBCO Software Inc. All rights reserved.