Skip to Content

LIMITDB2 keyword for the ANALYZE control statement

You can use the LIMITDB2 keyword on the ANALYZE control statement to set a limit on the number (1 through 9999999999) of Db2 log records to process from an input log data set.

Related topic

Specifying-ANALYZE-control-statements

ANALYZE-control-statement-example-and-keywords

The count of records to be limited begins after Log Analyzer has skipped the number of records that was specified with the SKIPDB2 keyword. After Log Analyzer processes the specified number of records, the process terminates as though it has reached the end of the data set. Specify LIMITDB2=9999999999 to process an unlimited number of records.

The default is LIMITDB2=9999999999.

Information
Example

You are analyzing the log records in a single log data set named IMSP.LOG00003 and Db2 log records in a single log data set named DB2P.DB2LOG03. If you do not want to process more than 10,000 Db2 log records from the log data set, specify the following keywords on the ANALYZE control statement:

SLDS=(IMSP.LOG00003,R153)

DB2LOG=(DB2P.DB2LOG03)

LIMITDB2=10000

For more information about the LIMITDB2 keyword, see Skipping-and-limiting-Db2-log-records.


 

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

BMC AMI Log Analyzer for IMS 1.7