Requirements and restrictions for BMC AMI Load

This topic describes requirements and restrictions for BMC AMI Load.

Software requirements

BMC AMI Load requires a minimum of version 12.1.00 of the BMC Db2 Solution Common Code (SCC).

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 V12 FL505
  • XML data or data structures
  • Data from the IBM SQL/DS product

• (PTF BQU2620 not applied) BMC AMI Unload supports 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
• 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.