IBM Books

System Monitor Guide and Reference

LIST ACTIVE DATABASES

Displays a subset of the information listed by the GET SNAPSHOT FOR ALL DATABASES command (see GET SNAPSHOT). For each active database, this command displays the following:

Scope

This command can be issued from any node that is listed in $HOME/sqllib/db2nodes.cfg. It returns the same information from any of these nodes.

Authorization

One of the following:

Command Syntax

>>-LIST ACTIVE DATABASES---------------------------------------><
 

Command Parameters

None

Examples

Following is sample output from the LIST ACTIVE DATABASES command:




                           Active Databases
 
Database name                              = TEST
Applications connected currently           = 0
Database path                              = /home/smith/smith/NODE0000/SQL00002/
 
Database name                              = SAMPLE
Applications connected currently           = 1
Database path                              = /home/smith/smith/NODE0000/SQL00001/

See Also

GET SNAPSHOT.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]