DB2 Version 9.7 for Linux, UNIX, and Windows

valid - Section validity indicator monitor element

Indicates whether the dynamic SQL statement section is valid. For static SQL statements, the value of this monitor element is always Y.

Table 1. Table Function Monitoring Information
Table Function	Monitor Element Collection 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

Usage

Valid values for this monitor element are Y and N. An invalid section is implicitly prepared by the system when next used.

A dynamic statement section can become invalid when:

SQL objects that the statement depends on directly or indirectly are altered or dropped
Privileges that are required by the authorization ID used to prepare the statement are revoked