TurboIMAGE/XL Database Management System Reference Manual MPE/iX V6.5 (30391-90011)

Chapter 8 427
Using the Database Utilities
>>DISABLE
INDEXING disables third-party indexing (TPI) for the database. Third-party indexing
provides the capability to do generic key searches, multiple keyword
retrievals, and sorted sequential searches on any database. Refer to your
vendor documentation for information on TPI.
LOGGING disables the database roll-forward logging facility. Roll-back and
MUSTRECOVER must be disabled first.
MUSTRECOVER disables the MUSTRECOVER option for the database. Logging is not
affected by disabling MUSTRECOVER. If the database needs recovery
when you disable MUSTRECOVER, you are prompted to confirm the
DISABLE command. If you respond to continue, the consistency of the
database cannot be guaranteed. To ensure database consistency, respond
with N, recover the database, and then disable MUSTRECOVER after
recovering the database.
PREFETCH disables the prefetching of data blocks required by the DBPUT and
DBDELETE intrinsics under certain conditions. Refer to "Coordinating
Additions to a Database" or "Coordinating Deletions from a Database" in
chapter 4 for additional information.
RECOVERY disables the database roll-forward recovery facility.
ROLLBACK disables the database roll-back logging facility. However, logging will not
be automatically disabled. To disable logging, use the >> database name
FOR LOGGING command. Otherwise, logging (roll-forward) will remain
enabled.
Default Conditions
Access is Enabled
Autodefer is Disabled
Dumping is Disabled
HWMPUT is Disabled
ILR is Disabled
Indexing is Disabled
Logging is Disabled
Mustrecover is Disabled
Prefetch is Disabled
Recovery is Disabled
Roll-Back is Disabled
Example
:RUN DBUTIL.PUB.SYS
.
.
.
>>DISABLE ORDERS FOR ACCESS
Access is Disabled
>>