DB2 Version 9.7 for Linux, UNIX, and Windows

prep_time_worst - Statement worst preparation time monitor element

The longest amount of time in milliseconds that was required to prepare a specific SQL statement.

Table 1. Snapshot Monitoring Information
Snapshot Level	Logical Data Grouping	Monitor Switch
Dynamic SQL	dynsql	Basic

Usage

Use this value in conjunction with prep_time_best to identify SQL statements that are expensive to compile.