DB2 Version 9.7 for Linux, UNIX, and Windows

db2govlg - DB2 governor log query command

Extracts records of specified type from the governor log files. The DB2® governor monitors and changes the behavior of applications that run against a database.
Important: With the new workload management features introduced in DB2 Version 9.5, the DB2 governor utility has been deprecated in Version 9.7 and might be removed in a future release. For more information, see "DB2 Governor and Query Patroller have been deprecated".

Authorization

None

Command syntax

Read syntax diagramSkip visual syntax diagram
>>-db2govlg--log-file------------------------------------------->

>--+-------------------------------------+---------------------->
   '-dbpartitionnum--db-partition-number-'   

>--+----------------------+------------------------------------><
   '-rectype--record-type-'   

Command parameters

log-file
The base name of one or more log files that are to be queried.
dbpartitionnum db-partition-number
Number of the database partition on which the governor is running.
rectype record-type
The type of record that is to be queried. Valid record types are:
  • START
  • FORCE
  • NICE
  • ERROR
  • WARNING
  • READCFG
  • STOP
  • ACCOUNT

Compatibilities

For compatibility with versions earlier than Version 8:
  • The keyword nodenum can be substituted for dbpartitionnum.