Skip to Content
Information
Limited support BMC 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 Datastream for Db2 7.1.

Missing fields

Many fields are present only in a subset of a particular SMF record type. 

For example, A$SSPDSN (data set name) and A$SSPVOL (volume serial) are found only in ACF2 subtype D (data set security) records. A$SSPDSN and A$SSPVOL might be said to be missing from all other ACF2 subtypes. All comparisons on missing fields are false. The following statement can filter out only subtype D records with a data set name that begins with TEMP:

SMF ACF2 FILTER(A$SSPDSN(EQ 'TEMP.**')) ...

The statement allows all other ACF2 records to be formatted and forwarded.

One implication of all comparisons on missing fields are false is that FILTER(A$SSPDSN(EQ 'TEMP.**')) and MATCH(A$SSPDSN(NE 'TEMP.**')) are not equivalent as both comparisons can be false if the data set name is missing. The FILTER specification allows ACF2 non-subtype D records to be formatted but the MATCH specification does not.


Related topic

Filtering-in-and-filtering-out-events

OPTIONS-statement


 

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

BMC AMI Defender for Db2 6.1