Object type considerations


This topic describes considerations for loading specific types of objects.

Partition-by-growth table spaces

BMC AMI Load loads partition-by-growth table spaces at the table space level only; you cannot use the PART option.

If additional partitions are required during the load process and the maximum number of partitions allowed for the table space has not been reached, BMC AMI Load adds the required partitions up to the maximum number of partitions. BMC AMI Load fails if additional partitions are needed and the maximum number of partitions has been reached.

Unsupported objects

BMC AMI Load does not support the following objects:

Warning

Important

BMC AMI Load invokes DSNUTILB to process these unsupported objects.

  • Catalog tables. DSNUTILB is not called for load of any table in database DSNDB01, DSNDB06, or DSNDB07.
  • Hash-organized tables
  • Table spaces with clone tables
  • Simple multi-table table spaces
  • Archive tables, when you specify LOAD REPLACE

 

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

BMC AMI Load for Db2 13.1