BMC AMI Unload requirements and restrictions

Authorization requirements

Using BMC AMI Unload requires the following authorizations:

• One of the following for the database:
  • SYSADM
  • DBADM
  • COPY
• One of the following for the tables:
  • Ownership
  • SELECT
  • SYSCTRL (catalog tables only)
  • UNLOAD (Only validated for DIRECT YES or DIRECT AUTO which resolves to DIRECT YES)
• The following for the views:
  • DBADM (PTF BQU4897 - Enhance authorization to support IBM APARs PH54863(PTF UI92616) and PH54936 (PTF UI92531))

Status requirements

When running BMC AMI Unload, the objects must be in the following statuses:

• The database must be in either RW status or UT,RO status. In addition, it cannot be in any restricted status.
• The table space must be in RW status and cannot be in any restricted status.

Restrictions

The following restrictions apply to BMC AMI Unload:

• BMC AMI Unload does not support:
  
  • DECFLOAT INDEXES, released in Db2 12 FL505
  • Table with a column name that exceeds 30 characters 
• BMC AMI Unload does not process the following objects:
  • Hash tables
  • Clone tables and base tables of clone tables
  • XML columns
    
• BMC AMI Unload does not unload temporal columns or write them to SYSPUNCH.

• BMC AMI Unloadsupports 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

• BMC AMI Unload supports a maximum of 32,950 SYSIN statements.
• BMC AMI Unload DIRECT YES does not support SELECT statements greater than 64k and has other imposed limits as defined by the language interface.