DB2 10.5 for Linux, UNIX, and Windows

Snapshot routines and views

This grouping of routines and views can be used to retrieve information about the database and any connected applications at a specific time.

QUERY_PREP_COST administrative view - Retrieve statement prepare time information
The QUERY_PREP_COST administrative view returns a list of statements with information about the time required to prepare the statement.
SNAPDYN_SQL administrative view and SNAP_GET_DYN_SQL table function - Retrieve dynsql logical group snapshot information
The SNAPDYN_SQL administrative view and the SNAP_GET_DYN_SQL table function return snapshot information from the dynsql logical data group.
SNAPSUBSECTION administrative view and SNAP_GET_SUBSECTION table function - Retrieve subsection logical monitor group snapshot information
The SNAPSUBSECTION administrative view and the SNAP_GET_SUBSECTION table function return information about application subsections, namely the subsection logical monitor grouping.
SNAPSWITCHES administrative view and SNAP_GET_SWITCHES table function - Retrieve database snapshot switch state information
The SNAPSWITCHES administrative view and the SNAP_GET_SWITCHES table function return information about the database snapshot switch state.
SNAPTAB_REORG administrative view and SNAP_GET_TAB_REORG table function - Retrieve table reorganization snapshot information
The SNAPTAB_REORG administrative view and the SNAP_GET_TAB_REORG table function return table reorganization information.
SNAPUTIL_PROGRESS administrative view and SNAP_GET_UTIL_PROGRESS table function - Retrieve progress logical data group snapshot information
The SNAPUTIL_PROGRESS administrative view and the SNAP_GET_UTIL_PROGRESS table function return snapshot information about utility progress, in particular, the progress logical data group.
TOP_DYNAMIC_SQL administrative view - Retrieve information about the top dynamic SQL statements
The TOP_DYNAMIC_SQL administrative view returns the top dynamic SQL statements sortable by number of executions, average execution time, number of sorts, or sorts per statement.