Document Actions

How to get snapshot information

A useful table containing all snapshot information about databases and instances.

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 DB2(R) 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 DB2 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 on 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.

DBA to DBA

Personal tools

Document Actions

How to get snapshot information

Would you like your company to implement gamification into your security awareness program?