This version of the software is currently available only to customers in the Controlled Availability (CA) program.

Disabling and enabling archive log mode for import and export

Typically, production OLTP systems operate in Archive Log mode to ensure that the database can recover to as close to failure time as possible. However, when bulk loading terabytes of data, Archive Log mode can have a detrimental performance impact if the IO channels and disks used for archive logs do not have sufficient bandwidth and are not isolated from the main data files.

We recommend disabling Archive Log Mode for the initial import into a clean target system. For subsequent incremental loads, you can enable Archive Log mode.

BMC Helix Data Manager creates staging data during export. This generates archive logs. If you are extracting data from a staging database (as per our best practice), disable archive logging. If you are running from a production system, do not disable archive logging.

 

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