IBM Books

Command 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

None

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 ]