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 Log Master for Db2 13.1.

Layout of records in load files


Each record in an output load file represents a log record selected by your filter and time frame.

In addition to the row image (or images) of the log record, Log Master includes additional informational columns to give context to the record. The following paragraphs summarize the layout of an output load file record.

  • Load record header

    The header contains all of the additional informational columns that Log Master includes with the log record. The length and content of the header varies depending on the values of the INFO COLUMNS or URID FIELDS keywords. For more information, see INFO COLUMNS.

  • Row image

    Depending on the type of database action that the load record represents, and the value of the UPDATES keyword, the content of the row image is as follows:

    • Insert action—an image of the inserted row
    • Delete action—an image of the deleted row
    • Update action—an image of the row after the update is completed
    • Mass delete action—an image with all default column values
    • Exchange action—an image with the same load column information leading to the record type, followed by the clone table creator and the clone table name

      Important

      The format of the exchange record is different than the rest of the load records because it does not have the column values.

    • Additional row image (when required)

      If the load record represents an update action, the record includes another row image that contains the before image of the row.

The UPDATES keyword determines the position and content of the row image (or images) in an output load file. The following figure shows the layout of row images for each value of the UPDATES keyword.


 Load file record layout for different UPDATES values
GUID-7A725C44-E4D8-45ED-9900-A68A1830A7F0-low.png


 

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