Statement | Meaning |
KEEP | Lock deallocated database keys |
REMOVE | The locked database keys are released for one-time reuse |
RESET | Free place search from the end of the occupied parts of the realm to the beginning |
REUSE | Deallocate database keys for reuse |
SET | Free place search from the beginning of the realm |
Table 23: BMODTT statements
These statements are explained below in combined formats that reflect their structure.
KEEP { DBKEY OF RECORD | OF RECORD }
{ rec-name-1[,rec-name-2]... | *ALL[ EXCEPT rec-name-1[,rec-name-2]...] }
KEEP
Deallocated database keys are locked and cannot be reused.
rec-name-1[,rec-name-2]...
List of affected record types.
*ALL
Affects all record types.
*ALL EXCEPT rec-name-1[,rec-name-2]...
Affects all record types in the database, except for those listed after EXCEPT.
REMOVE { DBKEY OF RECORD | OF RECORD }
{ rec-name-1[,rec-name-2]... | *ALL[ EXCEPT rec-name-1[,rec-name-2]...] }
REMOVE
The locked database keys are released for one-time reuse with the option of their reusability retained. The highest database key used for the specified record types is determined again and stored in the appropriate SIA.
Furthermore, the level at which a STORE statement or BINILOAD assigns database keys for the record types concerned is set ahead of the first free entry of the DBTT or on the entry with RSQ 1 if the latter is free. It is not possible to set the level separately without releasing the locked database keys.
rec-name-1[,rec-name-2]...
List of affected record types.
*ALL
Affects all record types.
*ALL EXCEPT rec-name-1[,rec-name-2]...
Affects all record types in the database, except for those listed after EXCEPT.
REUSE { DBKEY OF RECORD | OF RECORD }
{ rec-name-1[,rec-name-2]... | *ALL[ EXCEPT rec-name-1[,rec-name-2]...] }
REUSE
Deallocated database keys can always be reused. This is the default setting before using BMODTT.
rec-name-1[,rec-name-2]...
List of affected record types.
*ALL
Affects all record types.
*ALL EXCEPT rec-name-1[,rec-name-2]...
Affects all record types in the database, except for those listed after EXCEPT.
SET REUSE-FREE-SPACE OF REALM
{ realm-1[,realm-2]... | *ALL[ EXCEPT realm-1[,realm-2]...] }
SET
In the free place search, the search begins with the first page of the realm.
RESET REUSE-FREE-SPACE OF REALM
{ realm-1[,realm-2]... | *ALL[ EXCEPT realm-1[,realm-2]...] }
RESET
In the free place search, the search starts with the first free page which is not followed by any partially filled pages up to the end of the realm, but only pages which are still free or full.
This is the default setting before using the BMODTT utility routine.
realm-1[,realm-2],...
List of affected realms.
*ALL
Affects all realms of the database.
*ALL EXCEPT realm-1[,realm-2]...
Affects all realms of the database, except for those listed after EXCEPT.