Creating tables for HALDB databases

When defining a new table for a HALDB database, use the CREATE TABLE statement.

Define the physical characteristics of the table and its relationship with other tables. Its hierarchy in the database is determined by the FOREIGN KEY clause.

Consider the following guidelines when creating a new table for a PHDAM or PHIDAM HALDB database:
  • At least one table with a maximum of 255 tables for the database.
  • Use of hierarchic, physical child, or physical twin pointers between tables in the database.
  • 0-255 columns for each table, and a maximum of 10,000 for the database.
  • Optional Editproc identifying an edit or compression exit routine to enable user-supplied routines to manipulate each occurrence of a table on their way to or from auxiliary storage.
  • Optional logical relationships between tables using direct address or symbolic pointer options.
  • Optional maximum of 32 secondary index relationships per table and a maximum of 1000 for the database.
  • Optional Data Capture exit routine, to enable DB2® for z/OS® users access to updated IMS data.
  • Optional data set group definitions based on the size of the database partitions and usage of the tables by applications.