TurboIMAGE/XL Database Management System Reference Manual MPE/iX V6.5 (30391-90011)
Chapter 8 455
Using the Database Utilities
>>SHOW
ORDERS02.IMAGE.DATAMGT Customer DISC1
ORDERS03.IMAGE.DATAMGT Product DISC1
ORDERS04.IMAGE.DATAMGT Sup-Master DISC2
ORDERS05.IMAGE.DATAMGT Inventory DISC3
ORDERS06.IMAGE.DATAMGT Sales DISC2
>>
where
volname
is the name of the volume set in which the database resides.
Format of Show Indices
The following example lists the data set names, type, and whether they are indexed.
Example (Show Indices)
>>SHOW ORDERS INDICES
For database ORDERS
Data Set Name Type Indexed?
DATE-MASTER A YES
CUSTOMER M YES
PRODUCT M YES
SUP-MASTER M YES
4 indexed datasets
>>
Format of Show Locks List
DBUTIL lists the locking information sequentially by locking level: database locks followed
by data set locks, followed by data entry locks. The names of locked entities (for example,
the database, data set, or lock descriptor for data entries) appear in uppercase followed by
a list of other processes waiting at that locking level. DBUTIL indicates in lowercase the
reason each process is waiting. This message is preceded by a hyphen so that it can be
identified on terminals or listings from a line printer without lowercase.
If the term (PENDING) appears after a locked entity, it indicates that the lock has been
obtained but control cannot be returned to the caller until other locks have been released.
The same process identification will appear elsewhere in the list together with an
explanation of why it is waiting.
Infrequently, the term (TEMP) may appear. TurboIMAGE/XL places a temporary lock on a
data set while it processes an existing data entry lock request. Temporary locks occur only
when a user requests data entry locks on different items. Whenever the lock item changes,
TurboIMAGE/XL must wait until all existing locks on the current lock item are cleared
before it places a lock on the new lock item. During the wait the lock is termed "TEMP."
These locks are held very briefly and only under rare circumstances. The Process
Identification Numbers (PINs) and job/session numbers listed are the same as those shown
by MPE/iX commands, such as SHOWJOB and SHOWQ.