Snapshot monitor CLP commands

You can control the snapshot monitor through the command line prompt. For CLP commands, information about the monitor level is returned only if the associated monitor switch is set to ON. You must check the monitor elements that you want to use to determine if the element is under monitor switch control.

The following table lists all the supported snapshot request types.
Table 1. Snapshot Monitor CLP Commands
Monitor level CLP command Information returned
Connections list list applications [show detail] Application identification information for all applications currently connected to a database that is managed by the database instance on the partition where snapshot is taken.
Connections list list applications for database dbname [show detail] Application identification information for each application currently connected to the specified database.
Connections list list dcs applications Application identification information for all DCS applications currently connected to a database that is managed by the database instance on the partition where snapshot is taken.
Database manager get snapshot for dbm Database manager level information, including instance-level monitor switch settings.
Database manager get dbm monitor switches Instance-level monitor switch settings.
Database get snapshot for database on dbname Database level information and counters for a database. Information is returned only if there is at least one application connected to the database.
Database get snapshot for all databases Database level information and counters for each database active on the partition. Information is returned only if there is at least one application connected to the database.
Database list active databases The number of connections to each active database. Includes databases that were started using the ACTIVATE DATABASE command, but have no connections.
Database get snapshot for dcs database on dbname Database level information and counters for a specific DCS database. Information is returned only if there is at least one application connected to the database.
Database get snapshot for remote database on dbname Database level information and counters for a specific federated system database. Information is returned only if there is at least one application connected to the database.
Database get snapshot for all remote databases Database level information and counters for each active federated system database on the partition. Information is returned only if there is at least one application connected to the database.
Application get snapshot for application applid appl-id Application level information, including cumulative counters, status information, and most recent SQL statement executed (if statement switch is set).
Application get snapshot for application agentid appl-handle Application level information, includes cumulative counters, status information, and most recent SQL statement executed (if statement switch is set).
Application get snapshot for applications on dbname Application level information for each application that is connected to the database on the partition. This includes cumulative counters, status information, and most recent SQL statement executed (if statement switch is set).
Application get snapshot for all applications Application level information for each application that is active on the partition. This includes cumulative counters, status information, and most recent SQL statement executed (if statement switch is set).
Application get snapshot for dcs application applid appl-id Application level information, including cumulative counters, status information, and most recent SQL statement executed (if statement switch is set).
Application get snapshot for all dcs applications Application level information for each DCS application that is active on the partition. This includes cumulative counters, status information, and most recent SQL statement executed (if statement switch is set).
Application get snapshot for dcs application agentid appl-handle Application level information, including cumulative counters, status information, and most recent SQL statement executed (if statement switch is set).
Application get snapshot for dcs applications on dbname Application level information for each DCS application that is connected to the database on the partition. This includes cumulative counters, status information, and most recent SQL statement executed (if statement switch is set).
Application get snapshot for remote applications on dbname Application level information, includes cumulative counters, status information, and most recent SQL statement executed (if statement switch is set).
Application get snapshot for all remote applications Application level information for each federated system application that is active on the partition. This includes cumulative counters, status information, and most recent SQL statement executed (if statement switch is set).
Table get snapshot for tables on dbname Table activity information at the database and application level for each application connected to the database. Table activity information at the table level for each table that was accessed by an application connected to the database. Requires the table switch.
Lock get snapshot for locks for application applid appl-id List of locks held by the application. Lock wait information requires the lock switch.
Lock get snapshot for locks for application agentid appl-handle List of locks held by the application. Lock wait information requires the lock switch.
Lock get snapshot for locks on dbname Lock information at the database level, and application level for each application connected to the database. Requires the lock switch.
Table space get snapshot for tablespaces on dbname Information about table space activity for a database. Requires the buffer pool switch. Also included is information about containers, quiescers, and ranges. This information is not under switch control.
Buffer pool get snapshot for all bufferpools Buffer pool activity counters. Requires the buffer pool switch.
Buffer pool get snapshot for bufferpools on dbname Buffer pool activity counters for the specified database. Requires the buffer pool switch.
Dynamic SQL get snapshot for dynamic sql on dbname Point-in-time statement information from the SQL statement cache for the database. The information can also be from a remote data source.