Restricted_Access
NoRestricted_Access
Allows a single process to load data and enables some
optimizations available only when restricted access is in use.
The default is Norestricted_Access.
If you are loading a table from an RMU Unload file which contains
LIST OF BYTE VARYING data, the Restricted_Access qualifier
reserves the LIST areas for EXCLUSIVE access. This reduces the
virtual memory used by long transactions during a load operation
and also eliminates I/O to the snapshot files for the LIST
storage areas.
The Restricted_Access and Parallel qualifiers are mutually
exclusive and cannot be specified together on the same RMU Load
command line or within a plan file. While RMU Load is running
with the Restricted_Access qualifier specified, no other user can
attach to the database.