TurboIMAGE/XL Database Management System Reference Manual (30391-90012)

454 Chapter8
Using the Database Utilities
>>SHOW
by account, you must have SM capability.
maint word is the current maintenance word for the database. The database creator or
the user with SM capability can omit the maintenance word.
ALL displays all the information provided with MAINT, BUFFSPECS,
LANGUAGE, LOCKS, USERS, LOGID, SUBSYSTEMS, FLAGS, and the
last-stored date. Displays number of detail data sets using dynamic
capacity expansion and if dynamic capacity expansion is used for master
data sets. Also, if the database is attached to any ALLBASE/SQL database
environments (DBEnvironments) via IMAGESQL, the DBEnvironment
names are displayed (refer to the IMAGE/SQL Administration Guide for
information).
BUFFSPECS displays the current buffer specifications which can be either the
TurboIMAGE/V default setting or the values specified with the DBUTIL
>>SET command for those databases that will be migrated to MPE V; the
TurboIMAGE/XL default setting is not displayed. Refer to the discussion
of BUFFSPECS in the earlier section on the >>SET command and also in
"Moving from MPE/iX to MPE V" in appendix H.
CAPACITY displays, for all data sets, capacity information including dynamic capacity
fields. Information includes: data set name, type, number of entries,
entries as a percentage of the maximum capacity for the data set,
maximum capacity, current capacity, initial capacity, incremental number
of entries and whether or not dynamic capacity expansion is used.
CIUPDATE displays the setting for the critical item update option. Valid settings are
DISALLOWED, ALLOWED, and ON.
DEVICE displays the TurboIMAGE/XL root and data sets and where files reside
(device class name or logical number) for a database.
FLAGS displays the state (enabled or disabled) of the logging, roll-back, ILR,
recovery, restart, subsystem access, AUTODEFER, access, dumping,
HWMPUT, PREFETCH, MUSTRECOVER, and third-party indexing (TPI)
options. If MUSTRECOVER is enabled, the flags option also displays a
message if the database needs recovery. In addition, it displays the last
database store date, and information on whether the database has been
modified since the last-stored date (DBSTORE flag).
INDEX INDEXES INDICES displays the B-Tree indices for the database.
LANGUAGE displays state of the native language declaration for the database.
LOCKS displays the status of locks currently obtained (or requested).
LOGID displays the current MPE/iX log identifier for the database.
LOGINFO displays information about all types of logging available with
TurboIMAGE/XL.
MAINT displays the maintenance word, if any.
PASSWORDS displays the access class numbers from 1 through 63 together with the
passwords assigned to them. (You must be the database creator.)