How to better understand the DB2 snapshot function

The following content is the correct analysis of the DB2 snapshot function. I believe that if you have a good understanding of the DB2 snapshot function, it will be of great help in your future study or work, the following is a detailed description of the main content of the article. I hope you will have a better understanding of it after browsing.

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 an introduction to the full parsing of DB2 snapshot functions. I hope you will get some benefits.

The above content is an introduction to the full parsing of DB2 snapshot functions. I hope you will get some benefits.