iX V6.5 (30391-90011)

Chapter 3 87

Deﬁning a Database

Schema Processor Output

• Two lines of summary totals are printed on the list ﬁle. For example:

NUMBER OF ERROR MESSAGES: 0

ITEM NAME COUNT: 23 DATA SET COUNT: 6

The error count includes both errors in the schema and in the Schema Processor

Table 3-7. Data Set Summary Table Information

Headings Description

DATA SET NAME The name of the data set.

TYPE A for automatic, M for manual, or D for detail. A small letter "i"

adjacent to the "M" or "A" indicates the data set has a B-Tree

index on the key item.

FLD CNT The number of data items (ﬁelds) in each entry of the data set.

PT CT Path count. For a master data set, this is the number of paths

speciﬁed for the data set key item. For a detail data set, it is the

number of search items deﬁned for the data set.

ENTR LNGTH The length in halfwords of the data portion of the data entry

(not including any of the TurboIMAGE/XL pointers or structure

information associated with a data entry).

MED REC The total length in halfwords of a media record of the data set.

This length includes the entry length plus any of the

TurboIMAGE/XL pointers associated with the data entry.

Media records are discussed in chapter 10.

MAXIMUM CAPACITY The maximum number of entries allowed in the data set. For

master data sets speciﬁed for dynamic expansion and for detail

data sets, this number can differ from the number of entries

speciﬁed in the schema itself, because the capacity is adjusted

to represent an even multiple of the blocking factor (see below).

BLK FAC The number of media records that are blocked together for

transfer to and from the disk.

BLK LGTH The total length in halfwords of the physical block as deﬁned in

BLK FAC. This includes the media records and a bit map. Bit

maps are discussed in chapter 10.

DISC SPACE The amount of disk space occupied by the MPE/iX ﬁle

containing the data set.

INITIAL CAPACITY The number of entries for which space will be allocated or

initialized when the data set is created.

INCREMENT ENTRIES The number of entries by which the data set will be expanded

each time its space is exhausted.

TOTAL DISC SECTORS

INCLUDING ROOT: nnnn

The total number of disk sectors that will be occupied by the

database when created using the DBUTIL program.