Filter predicate

Specifies the field of a log record that BMC AMI Log Master compares against the value variable to select log records during the log scan. For more information about the fields that you can select, see Selectable-field-definition. For more information about abbreviating items, see Synonyms.

Defines the operator that BMC AMI Log Master uses to compare a selectable field against a specified value. Match the type of the operator to the type of the field that you select. The available operators are as follows:

For each log record, BMC AMI Log Master compares the value of the selectable field against the constant entered as value to determine whether to select the log record. For more information about the selectable field, see Selectable-field-definition. For value, you can enter

• Character constants (EBCDIC or Unicode)(for Unicode, use hexadecimal representation of UTF-8 values)
• Graphic (double-byte) constants (EBCDIC)
• Decimal numeric constants
• Hexadecimal numeric constants

For each filter predicate, match the type of the constant in value to the type of the selectable field. As you enter constant values, be aware of the following points:

• Enter EBCDIC character constants and decimal numeric constants using standard EBCDIC characters. If required, BMC AMI Log Master supports delimited Db2 object names. For more information about delimited names, see Defining-a-log-scan-step.
• Enter hexadecimal numeric constants as you do in SQL statements (for example, X'D3D6C1C4C7C5D5').
• Enter graphic constants (double-byte character set) as you do in SQL statements.
• For Unicode character constants (such as Db2 object names or column values)
  • If the constant contains only translatable characters, enter it using standard EBCDIC characters.
  • If the constant contains any untranslatable characters, use hexadecimal representation of the Unicode UTF-8 characters for the whole constant (for example, for a Unicode string of 'A B C', enter X'4120422043').

BMC AMI Log Master distinguishes between hexadecimal numeric constants and hexadecimal representation of Unicode characters based on the data type of the selectable field.

Selects log records that reflect activity in the specified partition of a table space. To use this keyword, the following conditions must be true:

• The value of the selectable field definition must be either TABLESPACE NAME or PSID. For more information, see Selectable-field-definition.
• The operator must be either equal or not equal (=, <>, ¬=, or *=).

For example, to select only the log records in one partition, use a search condition such as TABLESPACE NAME = ACCOUNTDB.TS01 PART 1. To select all of the log records in a table space except for the third partition, use a condition such as PSID = 505.007 AND PSID <> 505.007 PART 3.

You can also use the PART keyword as you define a set of multiple table spaces (using the IN or NOT IN keywords).

BMC AMI Log Master can compare a string item (for example, a table name or the content of a column) against a string pattern to determine whether to select log records during the log scan. This operation is similar to the LIKE predicate in SQL syntax. If the string item meets the requirements specified by the string pattern, BMC AMI Log Master selects the log record.

To specify a string pattern for selecting log records, use the wildcard characters listed in the following table. The characters can be included at the beginning of, in the middle of, or at the end of the string pattern. You can include more than one occurrence or more than one type of wildcard character in the string pattern.

The following examples illustrate some common uses of wildcard characters in a string pattern:

BMC AMI Log Master can compare data from log records against a single value or a set of values separated by commas. The IN keyword indicates a set of multiple values.

Selects log records based on the content of a specific column in a specific table. The CHANGED keyword enables you to select log records if the content of the column is changed in any way. The NULL keyword enables you to select log records if the content of the column is a null value.

BMC AMI Log Master can also compare the value in a specific table and column against a constant value or a set of constant values. For more information, see owner.tableName.columnName.

To fully qualify a specific column in a specific table, enter the user ID of the owner of the table. If you do not specify a value, BMC AMI Log Master uses a default value. The default value of owner is the user ID of the batch job that runs BMC AMI Log Master.

Do not confuse this type of filter predicate with the Column include/exclude definition that selects table columns in certain types of output. The differences are as follows:

• A filter predicate based on a column’s status affects log records in the output. If a filter excludes records based on a column’s status, the output still contains the specified column, only certain log records are missing.
• A Column include/exclude definition affects the entire column in the output (regardless of the column’s status). If a column is excluded, the output does not contain the specified column at all. For more information, see LOGSCAN-column-include-exclude-definition.

BMC AMI Log Master can compare the update type of log records against a single update type or a set of update types separated by commas. The IN keyword indicates a set of multiple update types. The valid update types are INSERT, UPDATE, DELETE, and EXCHANGE.