Communicator 3000 MPE/iX Release 6.0 (Platform Software Release C.60.00) (30216-90269)

160 Chapter 10
Technical Articles
IMAGE/SQL with TurboIMAGE/XL Enhancements
DBINFO mode 208 returns information about internals which will
be meaningful to only a few customers.
• DBUTIL SHOW database ALL command shows the presence of MDX.
The SHOW database CAPACITY command gives detailed information
pertaining to capacity parameters and identifies sets enabled for
dynamic expansion.
For more information, refer to the sixth edition of the
TurboIMAGE/XL Database Management System Reference Manual.
NOTE Select master data sets which need dynamic expansion based on
anticipated growth and specify the capacity parameters (in particular
the initial capacity) very carefully. Specifying low initial
(primary/hashing) capacity and increment leading to frequent
expansions may result into long synonym chains, which degrade the
performance of some TurboIMAGE intrinsics, and disk fragmentation.
Select initial capacity such that expansions will be minimal.
80 GB Data Sets
TurboIMAGE/XL version C.07.14 includes an enhancement which will
allow jumbo data sets to be up to 80 GB in size, twice as big as the old
limit. There are no new externals/options added for this enhancement.
For new databases, DBSCHEMA will allow data sets to be up to 80 GB in
size. As for jumbo data sets, the control option '$CONTROL JUMBO' is
required prior to specifying a data set greater than the default of 4 GB.
For existing databases, use third-party tools which support this feature.
If you use third-party indexing software, you may need the version of
the software which supports this feature.
When creating a jumbo data set of this magnitude using DBUTIL, you
will experience some delay.
6 High-water mark (0 for non-expanded masters)
7 Expansion threshold:
-1 ... 2 billion blocks
-1 this value means expansion not triggered by
traversing 3 blocks without success, or it is a
non-expandable set.
8…16 Reserved; 0 is returned
Element Contents