PART (database partitioning)


The PART keyword is valid with the CLONE, UNLOAD, BUILD, RELOAD, REORG, OREORG, and GROUP commands.

This keyword is available in PLUSIN; it is not available as a global option. The following table describes the keyword.

Partitioning keyword

To do this

Specify this in PLUSIN

Process selected partitions. (BMC AMI Partitioned Database Facility for IMS product and HALDB)

PART(partitionName, ...)

Process selected partitions. (BMC AMI Partitioned Database Facility for IMS product only)

PART(nn,nn,...)

Process all partitions. (BMC AMI Partitioned Database Facility for IMS product and HALDB)

PART(ALL)

Process a selected partition. (Online/Defrag)

PART(nn)

Internal default: ALL

If a HALDB uses a Partition Selection Exit routine that returns a subset of the partitions, the internal default of ALL processes the partitions returned by the Partition Selection Exit routine. To process all the partitions when a Partition Selection Exit routine is used, explicitly specify PART(ALL) in PLUSIN.

The PART keyword is valid for HALDBs. Currently, you can specify PART for the Unload function, Reload function, Index Build function, and Reorg function, including DEFRAG. Using the PART keyword, you can build primary indexes and Indirect List Data Sets (ILDS) for selected HALDB partitions.

Warning

Note

You can also build secondary indexes for selected HALDB partitions by using the SECINDEX keyword. For more information, see HALDBs.

MAXM Reorg solutions support the BMC AMI Partitioned Database Facility for IMS product, which allows you to split a database into as many as 32 partitions. With the MAXM Reorg/EP for IMS or BMC AMI Online Reorg for IMS solutions, you can reorganize selected partitions. The PART keyword enables partitioning support. Because the default is PART(ALL), you need to specify the PART keyword in the PLUSIN control statement data set only if you want to process selected partitions.

If you are performing reorganization tasks for selected partitions, the following restrictions apply:

  • The USERHDR keyword is not supported.
  • You cannot make DBD changes during the reorganization.
  • If the partitioned database has logical relationships, you must specify DBR (rather than DBIL) when creating the control data set (CDS) with the IMS Prereorganization utility.

If you perform reorganization tasks for selected partitions, rather than the entire database, you must make JCL changes as described in the following sections.

This section contains the following topics: 

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI Online Reorg for IMS 5.1