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

498 Chapter11
B-Tree Indices
External Commands and Utilities Affected
>> show ORDERS all
For database ORDERS
...
Dynamic capacity expansion is not used.
BTREEMODE1 is off, wildcard = "@"
Logid is not present.
...
New Syntax for SHOW
SHOW has a new option INDEX, alternatively INDEXES or INDICES.
SHOW
database name [/ maintword ] INDEX
>>SHOW ORDERS INDEX
For database ORDERS
Database root version < "C"4; there are no indexes.
>>addindex orders for all
Found 4 master datasets.
Adding index to set# 1 (#entries = 162,730, capacity = 218,987)
Adding index to set# 2 (#entries = 84,164, capacity = 188,517)
Adding index to set# 3 (#entries = 18,784, capacity = 21,943)
Adding index to set# 4 (#entries = 783, capacity = 2583)
Done.
>>
>>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
>>
DBCONTROL
DBCONTROL allows DBUTIL and privileged callers to perform several B-Tree index file
related functions such as the addition, deletion, or rebuilding of a B-Tree index file for a
specified master data set. Some functions require exclusive database access.
There are four additional DBCONTROL modes pertaining to B-Trees:
Mode 13 B-Tree index file functions.
Mode 14 obtain/control database-wide B-Tree index information.
Mode 15 sets BTREEMODE1 option ON and optionally sets the wildcard character
for the current DBOPEN.
Mode 16 sets BTREEMODE1 option OFF for the database for the current DBOPEN.