Default language.

Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Load for Db2 13.1.

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.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, Restarting-jobs-for-BMC-AMI-Load.
  • A robust SQL-like data manipulation languageFor more information, see BMC-AMI-Utilities-SQL-language.
  • Support for security labels


Related topic

Getting-started-with-BMC-AMI-Load


 

 

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