×
$helper.renderConfluenceMacro('{bmc-global-announcement:$space.key}')
 
 

Space announcements

   

This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

BMC AMI Log Master for Db2 12.1 ... Administering BMC AMI Log Master for Db2 expert information Working with large volume columns Specifying large volume column processing

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.

Note

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


Related topic

Specifying large volume column processing


Was this page helpful? Yes No Submitting... Thank you
Last modified by Anagha Evans on Aug 14, 2020
administration task

Comments

Specifying XML columns
Processing of large volume column data
© Copyright 1996 - 2020 BMC Software, Inc.
Legal notices

Powered by Atlassian Confluence and Scroll Viewport

© Copyright 2005-2021 BMC Software, Inc. Use of this site signifies your acceptance of BMC’s Terms of Use . BMC, the BMC logo, and other BMC marks are assets of BMC Software, Inc. These trademarks are registered and may be registered in the U.S. and in other countries.