DB2 snapshot function classic edition

Today, we will mainly describe the comprehensive analysis of DB2 snapshot functions. If you encounter DB2 snapshot functions in actual operations, but you do not know how to solve them correctly, the following articles must be good teachers and friends for you. The following are the main content of the article.

Select funcname from syscat. functions where funcschema = 'sysproc 'and funcname like 'snapshot _ %' with ur; use this statement to view all of them. The following are some definitions.

DB2 snapshot functions:

Select funcname from syscat. functions where funcschema = 'sysproc 'and funcname like 'snapshot _ %' with ur; use this statement to view all of them. The following are some definitions:

SNAPSHOT_DBM Database Manager Information.

SNAPSHOT_DATABASE database information. Information is returned only when at least one application is connected to the database.

SNAPSHOT_APPL information about the lock wait application on the application connecting to the database on the partition. This includes the cumulative counter, status information, and recently executed SQL statements (if the statement monitor switch is set ).

SNAPSHOT_APPL_INFO the general application ID information of each application connected to the database on the partition.

SNAPSHOT_LOCKWAIT information about the application that the lock is waiting to connect to the database on the partition.

SNAPSHOT_STATEMENT information about the statement of the application connecting to the database on the partition. This includes the recently executed SQL statements (if the statement monitor switch is set ).

The table activity information of each table accessed by SNAPSHOT_TABLE connected to the database application. The table monitor switch is required.

SNAPSHOT_LOCK database-Level Lock information and lock information of each application connected to the database at the application level. You need to lock the monitor switch.

The tablespace activity information at the SNAPSHOT_TBS database level, the tablespace activity information of each application connected to the database at the application level, and each tablespace accessed by the application connected to the database in the tablespace table space activity information at the level. The buffer pool monitor switch is required.

SNAPSHOT_BP specifies the buffer pool activity counter of the database. The buffer pool monitor switch is required.

SNAPSHOT_DYN_ SQL comes from the statement information at a certain time point cached by the SQL statements used for the database.

The above content is a description of the full resolution of DB2 snapshot functions, hoping to help you in this regard.