Communicator e3000 MPE/iX Release 7.5 (Software Release C.75.00) (30216-90336)
Chapter 5
Technical Articles
Large File Data Set (LFDS)
130
Large File Data Set (LFDS)
by Tien-You Chen, Commercial Systems Division
Overview
When TurboIMAGE was introduced, the size of a data set was limited to 4GB (this was the MPE limitation
until recently). When users demanded a larger data set, JUMBO data set was introduced, which can have a
maximum size of 396GB (max. size per chunk multiplied by max. no. of chunks = 4GB * 99 = 396GB). Jumbo
and single file data set are functionally similar except for dynamic expansion capability; while single file data
set can grow dynamically, jumbo data set cannot. Now, with the availability of LARGE FILES (file greater
than 4GB) on MPE, starting from version 6.5, we can increase the limit on a single file data set to 128GB,
which is now the MPE file system limit.
Changes
1. Creation of Large File Data Set
By default, any data set size less than 128GB is created as a single file data set, while a data set size
greater than 128GB is created as Jumbo data set. The user can force creation of Jumbo data sets, if data
set size is greater than 4GB, with a $CONTROL JUMBO option in the database schema. Each jumbo chunk
file would be a maximum of 4GB and can have up to 99 chunks. If the user specifies $CONTROL NOJUMBO,
which is default, any data set greater than 4GB but less than or equal to 128GB will be LFDS, while data
set size greater than 128GB cannot be created.
NOTE Large File Data Set cannot co-exist with Jumbo data set within one database. For example,
a database contains either all single file data sets if their size are less than 128GB or if any
of a data set is greater than 128GB in size, all the data sets that their size are greater than
4GB have to be Jumbo data set. However, TurboIMAGE supports both LFDS and Jumbo.
2. DBUTIL
DBUTIL “show all” command displays the current usage of data set file. Depending on whether or not the
database has large file data sets, either Database has at least one large file dataset or Database
has no large file dataset present is displayed.
3. DBINFO
DBINFO mode 406 returns information about fully qualified database name and open mode. In addition to
that, the 17th element is a bitmap denoting which features this database has used. If the 8th bit (start
from left, 0 based) is 1, it denotes the database has at least one large file data set, otherwise it is 0.
Conversion
The customer can convert Jumbo data set to Large File data set by using DBLOAD/DBUNLOAD utility.
DBLOAD/DBUNLOAD has been enhanced to unload database to one or more disk files instead of writing to tape.
Third party tools are available for this kind of conversion if performance is the concern.