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

Chapter 8 449
Using the Database Utilities
>>SHOW
>>SHOW
Displays information about the database on a terminal or line printer. This can include a
list of processes that have the database open, the status of locks in the database, the log
identifier and flags, the current buffer specifications, and the setting for the critical item
update option. Displays the capacity expansion information for the database and the data
sets. If you are using IMAGE/SQL,
displays the names of any ALLBASE/SQL database environments (DBEnvironments) to
which the database is attached. This command should be used with care because it obtains
exclusive control of the database for several seconds preventing all other access.
Syntax
>>SH[OW] dbname [. group [. account ]][/ maint word ] {ALL
BUFFSPECS
CAPACITY
CIUPDATE
DEVICE
FLAGS
INDEX
INDEXES
INDICES
LANGUAGE
LOCKS
LOGID
LOGINFO
MAINT
PASSWORDS
SUBSYSTEMS
USERS } [OFFLINE]
For example:
SHOW ORDERS/SELL ALL OFFLINE
where ORDERS is the database name and SELL is the maint word .
Parameters
dbname is the name of a TurboIMAGE/XL database root file catalogued in the
current session or job's account and logon group. If you have account
manager (AM) capability, you can qualify the database with the
group
name. If you have system manager (SM) capability, you can qualify the
database with the
group and account name.
group is the group where the database resides. To qualify the database name by
group, you must have AM or SM capability. If you have AM capability and
want to qualify the database name by group, the database must have a
maintenance word as you will be required to supply one.
account is the account where the database resides. To qualify the database name