DB2 Version 9.7 for Linux, UNIX, and Windows

stmt_type_id - Statement type identifier monitor element

Statement type identifier.

Table 1. Table Function Monitoring Information
Table Function Monitor Element Collection Command and Level
MON_GET_PKG_CACHE_STMT table function - Get SQL statement activity metrics in the package cache Always collected
MON_GET_PKG_CACHE_STMT_DETAILS table function - get detailed metrics for package cache entries Always collected
Table 2. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Package cache - COLLECT BASE DATA

Usage

The stmt_type_id monitor element has the following possible values:
  • Statement not prepared
  • DDL, (not Set Constraints)
  • DDL, Set Constraints
  • DML, Select
  • DML, Insert/Update/Delete
  • Authorization
  • DML, Select (blockable)
  • DML, Lock Table
  • DML, Commit/Rollback
  • Set environment
  • DDL, Savepoint
  • DDL, (declared user temp)
  • Passthru support
  • CALL
  • Free locator
  • DML, Select with IUD
  • DML, Select with IUD (blockable)
  • Top-level SET, no SQL
  • Top-level SET, reads SQL
  • DDL, (issues internal commit)
  • Top-level SET, modifies SQL
  • Unknown
Parent topic: Database system monitor elements