MicroStrategy ONE

Alter DBInstance statement

Modifies the properties of a DBInstance.

Copy 
ALTER DBINSTANCE "dbinstance_name" [NAME "new_dbinstance_name"] 
 [DBCONNTYPE "new_dbconnection_type"] [DBCONNECTION ("new_dbconnection_name" | [CONNSTRING "embedded_dbconnection_connection_string"]  [LOGIN "embedded_dblogin_username" ] [PASSWORD "embedded_dblogin_password"] )] 
 [DESCRIPTION "new_description"] [LONGDESCRIPTION 
 "long_description"] ODBCVERSION (2.0_ODBC | 3.X_ODBC) [DATABASE 
 "new_database_name"] 
 [TABLESPACE "new_tablespace_name"] [PRIMARYDBINSTANCE 
 "new_dbinstance_name2"] 
 [DATAMART "new_dbinstance_name"] [TABLEPREFIX "new_table_prefix"] 
 [HIGHTHREADS new_no_high_connections] 
 [MEDIUMTHREADS new_no_medium_connections] 
 [LOWTHREADS new_no_low_connections];

where:

  • DBINSTANCE "dbinstance_name" is the DBInstance to be modified, of type string.

  • NAME "new_dbinstance_name" is the new name of the DBInstance, the new datamart, or the DBInstance to be used as primary, of type string.

  • DBCONNTYPE "new_dbconnection_type" is the type of the database connection (DBMS), of type string.

  • DBCONNECTION "new_dbconnection_name" is the new DBConnection to be used in this DBInstance, of type string.

  • CONNSTRING "embedded_dbconnection_connection_string" is a string containing all information to connect to database, this parameter can be modified only if DBConnection in this DBInstance is embedded.

  • LOGIN "embedded_dblogin_username" is new login name of DBLogin in this DBInstance, this parameter can be modified only if DBConnection in this DBInstance is embedded.

  • PASSWORD "embedded_dblogin_password" is new login password of DBLogin in this DBInstance, this parameter can be modified only if DBConnection in this DBInstance is embedded.

  • DESCRIPTION "new_description" is the new description of the DBInstance, of type string.

  • LONGDESCRIPTION "long_description" is the new long description of the DBInstance, of type string.

  • ODBCVERSION indicates whether to use ODBC version 3.x or version 2.0 for this DBInstance. Version 3.x is supported in MicroStrategy beginning with MicroStrategy 9.0.

  • DATABASE "new_database_name" is the new name of the database for the intermediate table storage, of type string.

  • TABLESPACE "new_tablespace_name" is the new table space for the intermediate table storage, of type string.

  • PRIMARYDBINSTANCE"new_dbinstance_name" is

  • DATAMART "new_dbinstance_name2" is a DBInstance that is located in the same data warehouse as this DBInstance, for data mart optimization purposes.

  • TABLEPREFIX "new_table_prefix" is the new prefix to be used in this DBInstance, of type string.

  • HIGHTHREADS new_no_high_connections is the new number of connections to be established for high priority jobs, of type integer.

  • MEDIUMTHREADS new_no_medium_connections is the new number of connections to be established for medium priority jobs, of type integer.

  • LOWTHREADS new_no_low_connections is the new number of connections to be established for low priority jobs, of type integer.

Example

Copy 
ALTER DBINSTANCE 
 "Production Database" DBCONNTYPE "Oracle 8i" DATABASE 
 "Production" TABLESPACE "managers" HIGHTHREADS 8;