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.

Specifying LOB columns


To process LOB column data, specify only the base objects in your filter, not the auxiliary tables.

Log Master automatically locates and obtains data from the LOB objects.

To specify LOB columns

  1. Define LOB processing values.The online interface fields are as follows:

    • Run Time Options panel: LOB Option field
    • Work ID Run Time Options panel: LOB Option field
    • LOB Options panel

    The SYSIN syntax keyword is the LOBOPTS statement.

  2. Include LOB data in output files.The online interface field is the Include LOBS field on the following panels. LOB data includes DDL statements, which are stored in LOB columns.

    • SQL Output panel
    • Logical Log Output panel
    • Load Output panel
    • Report Output panel

    The SYSIN syntax keyword is the INCLUDE LOBS keyword.

Important

For larger LOB output records, consider unloading to VBS data sets by using SPANNED YES.



 

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