List Database Connections statement

Lists the database connections to a warehouse through MicroStrategy Intelligence Server.

LIST [(ALL 
 | ACTIVE)] DATABASE CONNECTIONS;

This statement can only be used with three-tier or four-tier project source names.

Example

LIST ACTIVE DATABASE 
 CONNECTIONS;

ResultSet Columns

CONNECTION_ID: ID of the database connection, returned as an integer.

DB_CONNECTION_STATUS: The status of the database connection, returned as an integer:

• 0: Busy

• 1: Cached

DB_INSTANCE_NAME: Name of the database instance associated with the database connection, returned as a string.