Benefits of BMC AMI Load

The BMC AMI Load product provides the following features and benefits:

  • Flexible data type conversions
  • Extensive integrity checking on the input data, and on newly-loaded table spaces and indexes.For more information, see Integrity-checking.
  • Optional sorting of input data.

Related topic

Getting-started-with-BMC-AMI-Load

  • For more information, Sort-considerations.
  • Discard processing for conversion and duplicate index key errors
  • The ability to override defined OBIDs when loading from a FORMAT (UNLOAD) input file.For more information, see OBID-integer.
  • Support for ROWID columns.For more information, ROWID-columns.
  • Support for both GENERATED ALWAYS and GENERATED BY DEFAULT identity columns
  • Support for indexes defined on an expression.For more information, Expression-based-indexes.
  • Use of the IBM z Systems Integrated Information Processor (zIIP)
  • Enabling LOAD REPLACE in read-only or read/write mode
  • Keeping nonpartitioned indexes in read/write status when running either LOAD RESUME YES or LOAD REPLACE.For more information, Partitioned-table-spaces-with-nonpartitioned-indexes.
  • One-pass loading of multiple tables
  • Quick recovery from a failed LOAD RESUME YES job.
  • For more information, see Restarting-jobs.
  • A robust SQL-like data manipulation languageFor more information, see BMC-AMI-Utilities-SQL-language.
  • Support for security labels


 

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