MicroStrategy ONE

Create DBInstance statement

Creates a new DBInstance.

Copy 
CREATE DBINSTANCE "dbinstance_name" DBCONNTYPE "dbconnection_type" 
 DBCONNECTION "dbconnection_name" [DESCRIPTION "description"] 
 [LONGDESCRIPTION 
 "long_description"] ODBCVERSION (2.0_ODBC | 3.X_ODBC) [DATABASE 
 "database_name"] 
 [TABLESPACE "tablespace_name"] [PRIMARYDBINSTANCE 
 "dbinstance_name2"] 
 [DATAMART "dbinstance_name2"] [TABLEPREFIX "table_prefix"] [HIGHTHREADS 
 no_high_connections] 
 [MEDIUMTHREADS no_medium_connections] 
 [LOWTHREADS no_low_connections];

where:

  • DBINSTANCE "dbinstance_name" is the name of the DBInstance to be created, used as a primary DBInstance or used to specify a data mart, of type string.

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

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

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

  • LONGDESCRIPTION "long_description" is the 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 "database_name" is the name of the database for the intermediate table storage, of type string.

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

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

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

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

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

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

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

Example

Copy 
CREATE DBINSTANCE 
 "Production Database" DBCONNTYPE "Microsoft SQL Server 
 2000" DBCONNECTION "Data" DESCRIPTION "Production 
 Database" HIGHTHREADS 10 MEDIUMTHREADS 5 LOWTHREADS 7;