Defining table spaces and indexes using the GENERATE statement

The GENERATE statement may be used to create table spaces, partitioning on tables, and indexes on tables. The GENERATE statement has a PROFILE parameter which is the major key to the GENERATE_PROFILES and GENERATE_KEYS system tables. All customization for creating table spaces, partitioning, and indexes may be performed using these system tables. The definition member DRLTKEYS is used to create and load the default values into the GENERATE_PROFILES and GENERATE_KEYS when the system tables are created.

These system tables provide default profiles for IMS, SMF, and the SMF CICS partitioned components. The supplied defaults may be changed by updating the data in these system tables without modifying the GENERATE statements in the Tivoli Decision Support for z/OS definition members. The profiles may be made more granular by using the COMPONENT_ID, SUBCOMPONENT_ID or TABLESPACE_NAME key fields, with no changes required to the product definition members.

For Tivoli Decision Support for z/OS 1.8.2, the use of the GENERATE statement is implemented for all Key Performance Metrics components and all CICS Partitioned components.

When you select a table space type of RANGE to create a Range Partitioned Universal Table space, the number of partitions created is determined by the number of entries for the key in the GENERATE_KEYS system table. For example the supplied profile of IMS has PART_NUM 1-4 which will generate 4 partitions for a RANGE table. This may be increased or decreased to generate the number of partitions you require. Changing the number of partitions does not require a change to the GENERATE statement in the Tivoli Decision Support for z/OS definition members.