Learn about DB2 snapshot monitoring

Source: Internet
Author: User

DB2 snapshot monitoring may be unfamiliar to many new users who are new to DB2 databases. The following describes the items of DB2 snapshot monitoring for your reference.

DB2 snapshot monitoring items:
Sorts: Number of heaps used, overflows, sorts performance, SORT] DFT_MON_SORT]
Locks: Number of locks held, number of deadlocks, LOCK] DFT_MON_LOCK]
Tables: Measure activity (rows read, rows written), TABLE] DFT_MON_TABLE]
Bufferpools: Number of reads and writes, time taken, BUFFERPOOL] DFT_MON_BUFPOOL]
Unit of work: Start times, end times, completion status, UOW] DFT_MON_UOW]
SQL statements: Start time, stop time, statement identification, STATEMENT] DFT_MON_STMT]
Timestamps: Monitors timestamp, TIMESTAMP] DFT_MON_TIMESTAMP]

You can use the following two commands to enable monitoring:

Update dbm configuration using DFT_MON_STMT ON
You do not need to restart the instance to modify this parameter. This parameter applies to each database in the instance. In addition to these monitoring parameters, other modifications to the instance parameters must take effect on the instance ).

This command enables this option to only play a role in this session. If it is disconnected, it becomes invalid.

Obtain the availability level of the metric snapshot:

Database manager-Captures information for an active instance
Database-Captures database (s) information
Application-Captures application (s) information
Bufferpools-Captures buffer pool activity information
Table space-Captures information for table spaces within a database
Table-Captures information for tables within a database
Lock-Captures information for locks held by applications against a database
Dynamic SQL cache-Captures point-in-time statement information from the SQL statement cache for the database
View monitoring switch:
Get monitor switches -- view the monitoring settings of the current session

How to Implement online DB2 Import

Common db2 stored procedure statements

Usage of the DB2 create server statement

Usage of DB2 Merge statements

Overview of DB2 Flow Control clauses

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.