How LOADPLUS updates MAXASSIGNEDVAL when loading identity columns
LOADPLUS updates the value of the MAXASSIGNEDVAL field of SYSIBM.SYSSEQUENCES based on the values that you are loading.
Generated values
When generating your identity column values, LOADPLUS always updates the MAXASSIGNEDVAL field, regardless of the value of the UPDATEMAXA command option or UPDMAXA installation option. LOADPLUS updates this field at the time that it reserves each cache and updates it with the last value in the cache that it is reserving.
Input file values
When loading your identity column values from an input file, LOADPLUS updates MAXASSIGNEDVAL only if you specify YES for the UPDATEMAXA command option or the UPDMAXA installation option. As the following table describes, the value with which LOADPLUS updates the input file field depends on the identity column values loaded.
LOADPLUS resets the cache when updating the MAXASSIGNEDVAL field.
Loaded identity column values | LOADPLUS action on MAXASSIGNEDVAL |
|---|---|
The maximum loaded identity column value is:
| LOADPLUS updates MAXASSIGNEDVAL with the maximum loaded identity column value. |
The maximum loaded identity column value is less than the value of MAXASSIGNEDVAL for positive INCREMENT values, or greater than MAXASSIGNEDVAL for negative INCREMENT values. | LOADPLUS does not update MAXASSIGNEDVAL. |
The maximum loaded identity column value is not within the range that is defined on the identity column, but the minimum loaded identity column value is within this range. | If the increment is a positive value, LOADPLUS updates MAXASSIGNEDVAL with the highest value in the range defined on the identity column. If INCREMENT is a negative value, LOADPLUS updates MAXASSIGNEDVAL with the lowest value in the range defined on the identity column. |
The maximum and minimum loaded identity column values are not within the range that is defined on the identity column. | LOADPLUS does not update MAXASSIGNEDVAL. |