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.
The casenum_gaps table has the following structure:
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.