Using db2diag log search feature

This section provides information about the filtering mechanism. The DB2 of IBM has a tool called diaglog. This tool is used to retrieve specific data from diaglog.log file according to a search command.

PATROL for IBM DB2 allows you to perform db2diag log filtering at any instance level within the DB2 hierarchy. 

This topic includes:

Before you begin

You must have installed and imported PATROL for IBM DB2 to the TrueSight console.

To perform db2diag log search configuration

Do the following for all DB2 Local, DB2 Remote Unix, and DB2 Remote Windows connection setups:

1. Login to your TrueSight console and go to the Infrastructure Policies under the Configuration tab.
2. Click Create Policy and enter the Policy Name, Agent Selection Criteria, and enable the policy.
3. Click Add Monitoring Configuration.

4. Select Monitoring Solution as IBM DB2, Monitor Profile as IBM DB2, and for instance consider Monitor Type as DB2 Local connection setup.

5. Click Add to configure the policy.
6. After specifying the Environment configuration details, expand the db2diag log search configuration list tab and click Add.
7. Enter the DB2 instance name that you want to monitor. It supports regex for monitoring multiple instances. Use comma to separate instances.
8. Click Add to enter the db2diag log search list.
9. Specify the State from the list. 
10. Enter the search command. Based on the specified search command, the state will alert the user.
    For example: If you select State as Alarm and specify the search command as -g data:="ABP Start", this command displays the data that contains: "ABP Start" as an annotation with an Alarm.