MicroStrategy ONE

List DBInstance Properties statement

Lists the properties of a DBInstance.

Copy 
LIST [ALL] 
 PROPERTIES FOR DBINSTANCE "dbinstance_name";

where:

  • DBINSTANCE "dbinstance_name" is the name of the DBInstance for which its properties will be listed, of type string.

Example

Copy 
LIST 
 ALL PROPERTIES FOR DBINSTANCE "Production Database";

ResultSet Columns

CONNECTIONS_HIGH_PRIORITY: The number of high priority database connections, returned as an integer.

CONNECTIONS_LOW_PRIORITY: The number of low priority database connections, returned as an integer.

CONNECTIONS_MEDIUM_PRIORITY: The number of medium priority database connections, returned as an integer.

DATABASE_NAME: The name of the database, returned as a string.

DATAMART: The name of the data mart associated with the database instance.

DB_CONNECTIONS: A result connection containing a list of database connections assigned to the database instance.

  • DB_CONNECTION: The name of the database connection.

DB_CONNECTION_TYPE: The type of database connection, such as "Microsoft Access 2000/2002/2003". Returned as a string.

DB_INSTANCE: The name of the database instance, returned as a string.

DESCRIPTION: The description of the database instance, returned as a string.

ID: The object ID of the database instance, returned as a string.

LONG_DESCRIPTION: The long description of the database instance, returned as a string.

ODBCVERSION: Open Database Connectivity version information, returned as a string.

PRIMARY_DBINSTANCE: The name of the primary database instance, returned as a string.

TABLE_PREFIX: The table prefix associated with the database instance, returned as a string.

TABLE_SPACE: The table space associated with the database instance, returned as a string.