Creating HALDB databases

When defining a new HALDB database, use the CREATE DATABASE statement.

The default database description generated is with an IMS PHIDAM OSAM access type. To override this default setting, you can use the ACCESS keyword to indicate either PHIDAM or PHDAM. The OS access value may also be changed from OSAM to VSAM. Alternately, you can use the LIKE keyword to generate a database description using attributes of an existing resource.

The ddname is not defined in DDL. However, data set groups are defined through DDL. They are dependent on the DSGROUP=A-J setting on each table that is defined. Later when the partitions are defined to DBRC, it will pull the definition from the catalog to determine how many data set groups were defined for the database.

The DDL statements used for a new HALDB is purely for defining the hierarchical structure and relationships of the data. DDL does not define each individual partition.