Allows you to rapidly reclaim deleted dbkeys and locked space
from database pages.
1 – Description
Applications that specify the database attach attribute DBKEY
SCOPE IS ATTACH can accumulate locked space and locked dbkeys
within the database. If one user is connected to the database in
DBKEY SCOPE IS ATTACH mode, all users are forced to operate in
this mode, even if they are explicitly connected in TRANSACTION
mode. No dbkeys are reused until the ATTACH session disconnects.
The RMU Reclaim command allows database keys of deleted rows to
be rapidly reset in one or more storage areas. The RMU Reclaim
command reads and updates all pages in a storage area, and, where
possible, releases locked lines and locked free space so that
they are available for later allocation.
2 – Format
(B)0[mRMU/Reclaim root-file-spec
[4mCommand[m [4mQualifiers[m x [4mDefaults[m
x
/Area[=storage-area-list] x All storage areas
/[No]Log x /NoLog
3 – Parameters
3.1 – root-file-spec
Specifies the database that contains locked areas or keys to be
reclaimed. The default file extension is .rdb.
4 – Command Qualifiers
4.1 – Area
Area=storage-area-list
Lists the storage areas to be reclaimed. The default is all
storage areas.
4.2 – Log
Log
NoLog
Displays a log message as each storage area is reclaimed. The
default is Nolog.
5 – Usage Notes
o The RMU Reclaim command runs on-line and does not require
exclusive access. However, if there are any users connected
to the database in DBKEY SCOPE IS ATTACH mode, the RMU/RECLAIM
operation has greatly reduced effect. In order to release all
possible locked space, there should be no users attached to
the database in DBKEY SCOPE IS ATTACH mode.
o To allow database page locked space to be reclaimed, the
database session that controls the locked space must be
detached from the database. This can be accomplished by
having each attached session disconnect and reconnect to the
database.