BMC AMI Load requirements and restrictions

Authorization requirements

To run BMC AMI Load, you need the following authorizations:

• LOAD authority on the database for the object that you are loading
• SYSADM authority or DBADM authority
• Ownership of the table that you are loading

Status requirements

When running BMC AMI Load with LOAD RESUME NO, the table space cannot be in a restricted status.

Restrictions

The following restrictions apply to BMC AMI Load:

• BMC AMI Load does not support:
  • DECFLOAT INDEXES, released in Db2 12 FL505
  • XML data or data structures
  • Data from the IBM SQL/DS product
  • Db2 Catalog tables— any table in database DSNDB01, DSNDB06, or DSNDB07.
  • Indexes in RBDPM status

• BMC AMI Loadsupports partition-by-range (PBR) and partition-by-growth (PBG) table spaces with partition sizes (DSSIZE) greater than 64 GB except for the following PAGESIZE and DSSIZE combinations: 

  PAGESIZE	DSSIZE
  4 KB	128 GB
  	256 GB
  8 KB	256 GB

Objects or conditions that invoke DSNUTILB

The following objects or conditions invoke DSNUTILB:

• Table with a LOB column
• Table with a XML column
• Table with a column name that exceeds 30 characters
• Multi-table simple table space (deprecated)
• Hashed tables (deprecated)
• Column-level CCSID
• Certain expressions when there’s an index on expression. For more information, see Functions-that-the-BMC-AMI-Utilities-SQL-language-supports.
• (BMC.DB2.SPE2210)  Table spaces that contain a mixture of fixed length and Huffman compression across the partitions.