DB2 Version 9.7 for Linux, UNIX, and Windows

last_request_type - Last request type monitor element

The type of the last request completed by the application.

Table 1. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_CONNECTION_DETAILS table function - Get detailed connection metrics (reported in DETAILS XML document) Always collected
MON_GET_UNIT_OF_WORK_DETAILS table function - Get detailed unit of work metrics (reported in DETAILS XML document) Always collected

Usage

This monitor element is only reported on the coordinator member for the application.

The following values are possible.
  • CLOSE
  • COMMIT
  • COMPILE
  • DESCRIBE
  • EXCSQLSET
  • EXECIMMD
  • EXECUTE
  • FETCH
  • INTERNAL number, where number is the value of the internal constant
  • OPEN
  • PREPARE
  • REBIND
  • REDISTRIBUTE
  • REORG
  • ROLLBACK
  • RUNSTATS
Parent topic: Database system monitor elements