Number of data sets in a HALDB partition

The minimum and maximum number of data sets a HALDB partition can contain depends on the type of HALDB database and whether or not you use the integrated HALDB Online Reorganization function.

For the integrated HALDB Online Reorganization function, IMS creates an additional data set for each database data set and PHIDAM primary index data set in the partition being reorganized. The additional data sets are used by the reorganization process and might or might not be active, or even present, depending on whether an online reorganization is currently in progress and, if a reorganization is not in progress, whether the inactive data sets were deleted after the last online reorganization completed.

The following table lists the minimum and maximum number of data sets a HALDB partition can contain.

Table 1. Minimum and maximum number of data sets for each HALDB partitions
HALDB type	Minimum number of data sets	Maximum number of data sets
PHDAM	Two or three: an OSAM or VSAM ESDS for the database data set, a KSDS for the ILDS, and, if the integrated HALDB Online Reorganization function is used, a second OSAM or VSAM ESDS.	Eleven or twenty one: ten OSAM or VSAM ESDSs for the database data sets, one KSDS for the ILDS, and, if the integrated HALDB Online Reorganization function is used, ten additional OSAM or VSAM ESDSs.
PHIDAM	Three or five: an OSAM or VSAM ESDS for the database data sets, a KSDS for the ILDS, a KSDS for the primary index, and, if the integrated HALDB Online Reorganization function is used, a second OSAM or VSAM ESDS and a second KSDS for the primary index.	Twelve or twenty three: ten OSAM or VSAM ESDSs for the database data sets, one KSDS for the ILDS, one KSDS for the primary index, and, if the integrated HALDB Online Reorganization function is used, ten additional OSAM or VSAM ESDSs and a second KSDS for the primary index.
PSINDEX	One: a KSDS	One: a KSDS