Command Reference

LIST ACTIVE DATABASES

Displays a subset of the information listed by the GET SNAPSHOT FOR ALL DATABASES command (see GET SNAPSHOT). An active database is available for connection and use by any application. For each active database, this command displays the following:

• Database name
• Number of applications currently connected to the database
• Database path.

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:

• sysadm
• sysctrl
• sysmaint

Command Syntax

>>-LIST ACTIVE DATABASES----+-------------------+--------------><
                            +-AT NODE--nodenum--+
                            '-GLOBAL------------'
 

Command Parameters

AT NODE nodenum

Specifies the node for which the status of the monitor switches is to be displayed.

GLOBAL

Returns an aggregate result for all nodes in a partition database system. For details on how results are aggregated see the System Monitor Guide and Reference.

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.

ACTIVATE DATABASE.

DEACTIVATE DATABASE.