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

454 Chapter8
Using the Database Utilities
>>SHOW
Refer to the IMAGE/SQL Administration Guide for more information.
The example displays, "Dynamic capacity expansion is used for 2 detail sets." Enable this
feature for new databases by using the capacity parameters for detail data sets. See
chapter 3 for more information. Enable this feature for existing databases by using
DBChange Plus or a third-party utility. Refer to the MPE/iX Release 5.0 Communicator
for information on using DBChange Plus.
Example (Show Capacity)
.
.
.
>>SHOW ORDERS CAPACITY
No. of %Max --------------Capacity-------------- Dyn
Data Set Name Type Entries Cap Maximum Current Initial Increment Exp
(Hashing)
CUSTOMER M 20 10 200 200 200 0 NO
DATE-MASTER A 111 53 211 211 200 0 NO
PRODUCT M 15 5 300 300 200 0 NO
SALES D 100 2 5012 140 140 70 YES
SUP-MASTER M 60 3 2000 600 400 200 YES
INVENTORY D 4998 1 500000 5000 5000 10000 YES
>>
The example shows Maximum, Current, Initial and Increment Capacities. The "%Max
Cap" column shows how full the data set is as a percent of the maximum capacity for that
set. "Dyn Exp" column shows whether dynamic capacity expansion is enabled or not.
Enable this feature for new databases by using the capacity parameters when defining
data sets. See chapter 3 for more information. Enable this feature for existing databases by
using DBChange Plus or a third-party utility which supports this feature.
Format of Show Device List
The following example lists the TurboIMAGE/XL files for the ORDERS database, along
with the data set names and the device where each resides. In the following example, the
root file ORDERS and the data sets are shown. The file devices are listed as specified with
the device class names. The ORDERS05 data set was moved using the DBUTIL >>MOVE
command to logical device number 3; the device class name is displayed.
Example (Show Device)
>>SHOW ORDERS DEVICE
For database ORDERS
Volume set: volname
MPE/iX File Name Data Set Name Device
ORDERS.IMAGE.DATAMGT DISC
ORDERS01.IMAGE.DATAMGT Date-Master DISC1