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.

LOGSCAN search condition definition


Use this syntax to define the data that 

Log Master

 includes in the output of your LOGSCAN statement.

A search condition can contain a simple filter predicate, multiple filter predicates, or a combination of filter predicates and additional search conditions. Use standard SQL syntax to combine multiple filter predicates and search conditions.

The following figure shows the Search condition definition syntax used in the WHERE clause of the LOGSCAN statement.

GUID-27696F76-1F4F-4BF1-AFA1-AC5D81DFCFC8-low.png

Option

Description

Filter predicate

A simple filter predicate defines one condition that will control log scan output. For more information, see Filter-predicate.

Search condition definition

Search conditions can include additional, nested search conditions. All nested search conditions must conform to the syntax rules defined in this section.

AND | OR | NOT

Use the AND keyword, the OR keyword, or the NOT keyword to join multiple search conditions or filter predicates. These keywords work the same as logical operators in standard SQL syntax.

This section contains the following topics:

Related topic

 

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