EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  3. Topics

Managing MicroStrategy Services from the Command Line

Kyle Petrillo

Technical Support Intern • Strategy

MicroStrategy Server Control Utility enables you to create and manage Intelligence Server server instances from the command line. A server instance is an Intelligence Server that is using a particular server definition.

Managing Strategy services from the command line

Strategy Server Control Utility enables you to create and manage Intelligence Server server instances from the command line. A server instance is an Intelligence Server that is using a particular server definition. For more information about server definitions, see Processing your data: Intelligence Server.
Server Control Utility can also be used to start, stop, and restart other Strategy services—such as the Listener, Distribution Manager, Execution Engine, or Enterprise Manager Data Loader services—and to view and set configuration information for those services.
The following table lists the commands that you can perform with the Server Control Utility. The syntax for using the Server Control Utility commands is:

mstrctl -m 
machinename
 [-l 
login
] -s 
servicename
 
command 
[
instancename
][(> | <)
 
filename
.xml]

where:

  SET QUERY_BAND = ‘MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;MSTRPriority=!i;’ FOR SESSION;
 Pre/Post Statements Cleanup Post Statement SET QUERY_BAND = NONE FOR SESSION; Pre/Post Statements Element Browsing Pre Statement SET QUERY_BAND = ‘MSTRProject=!p;;MSTRReport=ELEMENTBROWSE;;MSTRUser=!u;;MSTRJob=!j;;MSTRPriority=!i;;’ FOR SESSION; Pre/Post Statements Element Browsing Post Statement SET QUERY_BAND = NONE FOR SESSION; Query Optimizations Sub Query Type WHERE (col1, col2...) IN (SELECT s1.col1, s1.col2...)TypeArgumentUseDescriptionHSTMThstmtInputStatement handleUCHAR FAR *szSqlStrInputSQL statement to be executedSDWORDcbSqlStrInputLength of szSqlStr •

machinename
 is the name of the machine hosting the server instance or service. If this parameter is omitted, the service is assumed to be hosted on the local machine. •
login
 is the login for the machine hosting the server instance or service, and is required if you are not logged into that machine. You are prompted for a password. •
servicename
 is the name of the service, such as IntelligenceServer or EMService. •
command
 is one of the commands from the list below. •
instancename
 is the name of a server instance, where required. If a name is not specified, the command uses the default instance name. •
filename
 is the name of the file to read from or write to.

  SET QUERY_BAND = ‘MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;MSTRPriority=!i;’ FOR SESSION;
 Pre/Post Statements Cleanup Post Statement SET QUERY_BAND = NONE FOR SESSION; Pre/Post Statements Element Browsing Pre Statement SET QUERY_BAND = ‘MSTRProject=!p;;MSTRReport=ELEMENTBROWSE;;MSTRUser=!u;;MSTRJob=!j;;MSTRPriority=!i;;’ FOR SESSION; Pre/Post Statements Element Browsing Post Statement SET QUERY_BAND = NONE FOR SESSION; Query Optimizations Sub Query Type WHERE (col1, col2...) IN (SELECT s1.col1, s1.col2...)TypeArgumentUseDescriptionHSTMThstmtInputStatement handleUCHAR FAR *szSqlStrInputSQL statement to be executedSDWORDcbSqlStrInputLength of szSqlStr •

machinename
 is the name of the machine hosting the server instance or service. If this parameter is omitted, the service is assumed to be hosted on the local machine. •
login
 is the login for the machine hosting the server instance or service, and is required if you are not logged into that machine. You are prompted for a password. •
servicename
 is the name of the service, such as IntelligenceServer or EMService. •
command
 is one of the commands from the list below. •
instancename
 is the name of a server instance, where required. If a name is not specified, the command uses the default instance name. •
filename
 is the name of the file to read from or write to.

  SET QUERY_BAND = ‘MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;MSTRPriority=!i;’ FOR SESSION;
 Pre/Post Statements Cleanup Post Statement SET QUERY_BAND = NONE FOR SESSION; Pre/Post Statements Element Browsing Pre Statement SET QUERY_BAND = ‘MSTRProject=!p;;MSTRReport=ELEMENTBROWSE;;MSTRUser=!u;;MSTRJob=!j;;MSTRPriority=!i;;’ FOR SESSION; Pre/Post Statements Element Browsing Post Statement SET QUERY_BAND = NONE FOR SESSION; Query Optimizations Sub Query Type WHERE (col1, col2...) IN (SELECT s1.col1, s1.col2...)TypeArgumentUseDescriptionHSTMThstmtInputStatement handleUCHAR FAR *szSqlStrInputSQL statement to be executedSDWORDcbSqlStrInputLength of szSqlStr •

machinename
 is the name of the machine hosting the server instance or service. If this parameter is omitted, the service is assumed to be hosted on the local machine. •
login
 is the login for the machine hosting the server instance or service, and is required if you are not logged into that machine. You are prompted for a password. •
servicename
 is the name of the service, such as IntelligenceServer or EMService. •
command
 is one of the commands from the list below. •
instancename
 is the name of a server instance, where required. If a name is not specified, the command uses the default instance name. •
filename
 is the name of the file to read from or write to.

  SET QUERY_BAND = ‘MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;MSTRPriority=!i;’ FOR SESSION;
 Pre/Post Statements Cleanup Post Statement SET QUERY_BAND = NONE FOR SESSION; Pre/Post Statements Element Browsing Pre Statement SET QUERY_BAND = ‘MSTRProject=!p;;MSTRReport=ELEMENTBROWSE;;MSTRUser=!u;;MSTRJob=!j;;MSTRPriority=!i;;’ FOR SESSION; Pre/Post Statements Element Browsing Post Statement SET QUERY_BAND = NONE FOR SESSION; Query Optimizations Sub Query Type WHERE (col1, col2...) IN (SELECT s1.col1, s1.col2...)TypeArgumentUseDescriptionHSTMThstmtInputStatement handleUCHAR FAR *szSqlStrInputSQL statement to be executedSDWORDcbSqlStrInputLength of szSqlStr •

machinename
 is the name of the machine hosting the server instance or service. If this parameter is omitted, the service is assumed to be hosted on the local machine. •
login
 is the login for the machine hosting the server instance or service, and is required if you are not logged into that machine. You are prompted for a password. •
servicename
 is the name of the service, such as IntelligenceServer or EMService. •
command
 is one of the commands from the list below. •
instancename
 is the name of a server instance, where required. If a name is not specified, the command uses the default instance name. •
filename
 is the name of the file to read from or write to.

  SET QUERY_BAND = ‘MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;MSTRPriority=!i;’ FOR SESSION;
 Pre/Post Statements Cleanup Post Statement SET QUERY_BAND = NONE FOR SESSION; Pre/Post Statements Element Browsing Pre Statement SET QUERY_BAND = ‘MSTRProject=!p;;MSTRReport=ELEMENTBROWSE;;MSTRUser=!u;;MSTRJob=!j;;MSTRPriority=!i;;’ FOR SESSION; Pre/Post Statements Element Browsing Post Statement SET QUERY_BAND = NONE FOR SESSION; Query Optimizations Sub Query Type WHERE (col1, col2...) IN (SELECT s1.col1, s1.col2...)TypeArgumentUseDescriptionHSTMThstmtInputStatement handleUCHAR FAR *szSqlStrInputSQL statement to be executedSDWORDcbSqlStrInputLength of szSqlStr •

machinename
 is the name of the machine hosting the server instance or service. If this parameter is omitted, the service is assumed to be hosted on the local machine. •
login
 is the login for the machine hosting the server instance or service, and is required if you are not logged into that machine. You are prompted for a password. •
servicename
 is the name of the service, such as IntelligenceServer or EMService. •
command
 is one of the commands from the list below. •
instancename
 is the name of a server instance, where required. If a name is not specified, the command uses the default instance name. •
filename
 is the name of the file to read from or write to.

  SET QUERY_BAND = ‘MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;MSTRPriority=!i;’ FOR SESSION;
 Pre/Post Statements Cleanup Post Statement SET QUERY_BAND = NONE FOR SESSION; Pre/Post Statements Element Browsing Pre Statement SET QUERY_BAND = ‘MSTRProject=!p;;MSTRReport=ELEMENTBROWSE;;MSTRUser=!u;;MSTRJob=!j;;MSTRPriority=!i;;’ FOR SESSION; Pre/Post Statements Element Browsing Post Statement SET QUERY_BAND = NONE FOR SESSION; Query Optimizations Sub Query Type WHERE (col1, col2...) IN (SELECT s1.col1, s1.col2...)TypeArgumentUseDescriptionHSTMThstmtInputStatement handleUCHAR FAR *szSqlStrInputSQL statement to be executedSDWORDcbSqlStrInputLength of szSqlStr •

machinename
 is the name of the machine hosting the server instance or service. If this parameter is omitted, the service is assumed to be hosted on the local machine. •
login
 is the login for the machine hosting the server instance or service, and is required if you are not logged into that machine. You are prompted for a password. •
servicename
 is the name of the service, such as IntelligenceServer or EMService. •
command
 is one of the commands from the list below. •
instancename
 is the name of a server instance, where required. If a name is not specified, the command uses the default instance name. •
filename
 is the name of the file to read from or write to.

  SET QUERY_BAND = ‘MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;MSTRPriority=!i;’ FOR SESSION;
 Pre/Post Statements Cleanup Post Statement SET QUERY_BAND = NONE FOR SESSION; Pre/Post Statements Element Browsing Pre Statement SET QUERY_BAND = ‘MSTRProject=!p;;MSTRReport=ELEMENTBROWSE;;MSTRUser=!u;;MSTRJob=!j;;MSTRPriority=!i;;’ FOR SESSION; Pre/Post Statements Element Browsing Post Statement SET QUERY_BAND = NONE FOR SESSION; Query Optimizations Sub Query Type WHERE (col1, col2...) IN (SELECT s1.col1, s1.col2...)TypeArgumentUseDescriptionHSTMThstmtInputStatement handleUCHAR FAR *szSqlStrInputSQL statement to be executedSDWORDcbSqlStrInputLength of szSqlStr •

machinename
 is the name of the machine hosting the server instance or service. If this parameter is omitted, the service is assumed to be hosted on the local machine. •
login
 is the login for the machine hosting the server instance or service, and is required if you are not logged into that machine. You are prompted for a password. •
servicename
 is the name of the service, such as IntelligenceServer or EMService. •
command
 is one of the commands from the list below. •
instancename
 is the name of a server instance, where required. If a name is not specified, the command uses the default instance name. •
filename
 is the name of the file to read from or write to.

  SET QUERY_BAND = ‘MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;MSTRPriority=!i;’ FOR SESSION;
 Pre/Post Statements Cleanup Post Statement SET QUERY_BAND = NONE FOR SESSION; Pre/Post Statements Element Browsing Pre Statement SET QUERY_BAND = ‘MSTRProject=!p;;MSTRReport=ELEMENTBROWSE;;MSTRUser=!u;;MSTRJob=!j;;MSTRPriority=!i;;’ FOR SESSION; Pre/Post Statements Element Browsing Post Statement SET QUERY_BAND = NONE FOR SESSION; Query Optimizations Sub Query Type WHERE (col1, col2...) IN (SELECT s1.col1, s1.col2...)TypeArgumentUseDescriptionHSTMThstmtInputStatement handleUCHAR FAR *szSqlStrInputSQL statement to be executedSDWORDcbSqlStrInputLength of szSqlStr •

machinename
 is the name of the machine hosting the server instance or service. If this parameter is omitted, the service is assumed to be hosted on the local machine. •
login
 is the login for the machine hosting the server instance or service, and is required if you are not logged into that machine. You are prompted for a password. •
servicename
 is the name of the service, such as IntelligenceServer or EMService. •
command
 is one of the commands from the list below. •
instancename
 is the name of a server instance, where required. If a name is not specified, the command uses the default instance name. •
filename
 is the name of the file to read from or write to.

  SET QUERY_BAND = ‘MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;MSTRPriority=!i;’ FOR SESSION;
 Pre/Post Statements Cleanup Post Statement SET QUERY_BAND = NONE FOR SESSION; Pre/Post Statements Element Browsing Pre Statement SET QUERY_BAND = ‘MSTRProject=!p;;MSTRReport=ELEMENTBROWSE;;MSTRUser=!u;;MSTRJob=!j;;MSTRPriority=!i;;’ FOR SESSION; Pre/Post Statements Element Browsing Post Statement SET QUERY_BAND = NONE FOR SESSION; Query Optimizations Sub Query Type WHERE (col1, col2...) IN (SELECT s1.col1, s1.col2...)TypeArgumentUseDescriptionHSTMThstmtInputStatement handleUCHAR FAR *szSqlStrInputSQL statement to be executedSDWORDcbSqlStrInputLength of szSqlStr •

machinename
 is the name of the machine hosting the server instance or service. If this parameter is omitted, the service is assumed to be hosted on the local machine. •
login
 is the login for the machine hosting the server instance or service, and is required if you are not logged into that machine. You are prompted for a password. •
servicename
 is the name of the service, such as IntelligenceServer or EMService. •
command
 is one of the commands from the list below. •
instancename
 is the name of a server instance, where required. If a name is not specified, the command uses the default instance name. •
filename
 is the name of the file to read from or write to.

To retrieve a list of services on a machine, use the command 

mstrctl -m 
machinename
 ls
.

  SET QUERY_BAND = ‘MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;MSTRPriority=!i;’ FOR SESSION;
 Pre/Post Statements Cleanup Post Statement SET QUERY_BAND = NONE FOR SESSION; Pre/Post Statements Element Browsing Pre Statement SET QUERY_BAND = ‘MSTRProject=!p;;MSTRReport=ELEMENTBROWSE;;MSTRUser=!u;;MSTRJob=!j;;MSTRPriority=!i;;’ FOR SESSION; Pre/Post Statements Element Browsing Post Statement SET QUERY_BAND = NONE FOR SESSION; Query Optimizations Sub Query Type WHERE (col1, col2...) IN (SELECT s1.col1, s1.col2...)TypeArgumentUseDescriptionHSTMThstmtInputStatement handleUCHAR FAR *szSqlStrInputSQL statement to be executedSDWORDcbSqlStrInputLength of szSqlStr •

machinename
 is the name of the machine hosting the server instance or service. If this parameter is omitted, the service is assumed to be hosted on the local machine. •
login
 is the login for the machine hosting the server instance or service, and is required if you are not logged into that machine. You are prompted for a password. •
servicename
 is the name of the service, such as IntelligenceServer or EMService. •
command
 is one of the commands from the list below. •
instancename
 is the name of a server instance, where required. If a name is not specified, the command uses the default instance name. •
filename
 is the name of the file to read from or write to.

  SET QUERY_BAND = ‘MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;MSTRPriority=!i;’ FOR SESSION;
 Pre/Post Statements Cleanup Post Statement SET QUERY_BAND = NONE FOR SESSION; Pre/Post Statements Element Browsing Pre Statement SET QUERY_BAND = ‘MSTRProject=!p;;MSTRReport=ELEMENTBROWSE;;MSTRUser=!u;;MSTRJob=!j;;MSTRPriority=!i;;’ FOR SESSION; Pre/Post Statements Element Browsing Post Statement SET QUERY_BAND = NONE FOR SESSION; Query Optimizations Sub Query Type WHERE (col1, col2...) IN (SELECT s1.col1, s1.col2...)TypeArgumentUseDescriptionHSTMThstmtInputStatement handleUCHAR FAR *szSqlStrInputSQL statement to be executedSDWORDcbSqlStrInputLength of szSqlStr •

machinename
 is the name of the machine hosting the server instance or service. If this parameter is omitted, the service is assumed to be hosted on the local machine. •
login
 is the login for the machine hosting the server instance or service, and is required if you are not logged into that machine. You are prompted for a password. •
servicename
 is the name of the service, such as IntelligenceServer or EMService. •
command
 is one of the commands from the list below. •
instancename
 is the name of a server instance, where required. If a name is not specified, the command uses the default instance name. •
filename
 is the name of the file to read from or write to.

  SET QUERY_BAND = ‘MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;MSTRPriority=!i;’ FOR SESSION;
 Pre/Post Statements Cleanup Post Statement SET QUERY_BAND = NONE FOR SESSION; Pre/Post Statements Element Browsing Pre Statement SET QUERY_BAND = ‘MSTRProject=!p;;MSTRReport=ELEMENTBROWSE;;MSTRUser=!u;;MSTRJob=!j;;MSTRPriority=!i;;’ FOR SESSION; Pre/Post Statements Element Browsing Post Statement SET QUERY_BAND = NONE FOR SESSION; Query Optimizations Sub Query Type WHERE (col1, col2...) IN (SELECT s1.col1, s1.col2...)TypeArgumentUseDescriptionHSTMThstmtInputStatement handleUCHAR FAR *szSqlStrInputSQL statement to be executedSDWORDcbSqlStrInputLength of szSqlStr •

machinename
 is the name of the machine hosting the server instance or service. If this parameter is omitted, the service is assumed to be hosted on the local machine. •
login
 is the login for the machine hosting the server instance or service, and is required if you are not logged into that machine. You are prompted for a password. •
servicename
 is the name of the service, such as IntelligenceServer or EMService. •
command
 is one of the commands from the list below. •
instancename
 is the name of a server instance, where required. If a name is not specified, the command uses the default instance name. •
filename
 is the name of the file to read from or write to.

  SET QUERY_BAND = ‘MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;MSTRPriority=!i;’ FOR SESSION;
 Pre/Post Statements Cleanup Post Statement SET QUERY_BAND = NONE FOR SESSION; Pre/Post Statements Element Browsing Pre Statement SET QUERY_BAND = ‘MSTRProject=!p;;MSTRReport=ELEMENTBROWSE;;MSTRUser=!u;;MSTRJob=!j;;MSTRPriority=!i;;’ FOR SESSION; Pre/Post Statements Element Browsing Post Statement SET QUERY_BAND = NONE FOR SESSION; Query Optimizations Sub Query Type WHERE (col1, col2...) IN (SELECT s1.col1, s1.col2...)TypeArgumentUseDescriptionHSTMThstmtInputStatement handleUCHAR FAR *szSqlStrInputSQL statement to be executedSDWORDcbSqlStrInputLength of szSqlStr •

machinename
 is the name of the machine hosting the server instance or service. If this parameter is omitted, the service is assumed to be hosted on the local machine. •
login
 is the login for the machine hosting the server instance or service, and is required if you are not logged into that machine. You are prompted for a password. •
servicename
 is the name of the service, such as IntelligenceServer or EMService. •
command
 is one of the commands from the list below. •
instancename
 is the name of a server instance, where required. If a name is not specified, the command uses the default instance name. •
filename
 is the name of the file to read from or write to.

  SET QUERY_BAND = ‘MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;MSTRPriority=!i;’ FOR SESSION;
 Pre/Post Statements Cleanup Post Statement SET QUERY_BAND = NONE FOR SESSION; Pre/Post Statements Element Browsing Pre Statement SET QUERY_BAND = ‘MSTRProject=!p;;MSTRReport=ELEMENTBROWSE;;MSTRUser=!u;;MSTRJob=!j;;MSTRPriority=!i;;’ FOR SESSION; Pre/Post Statements Element Browsing Post Statement SET QUERY_BAND = NONE FOR SESSION; Query Optimizations Sub Query Type WHERE (col1, col2...) IN (SELECT s1.col1, s1.col2...)TypeArgumentUseDescriptionHSTMThstmtInputStatement handleUCHAR FAR *szSqlStrInputSQL statement to be executedSDWORDcbSqlStrInputLength of szSqlStr •

machinename
 is the name of the machine hosting the server instance or service. If this parameter is omitted, the service is assumed to be hosted on the local machine. •
login
 is the login for the machine hosting the server instance or service, and is required if you are not logged into that machine. You are prompted for a password. •
servicename
 is the name of the service, such as IntelligenceServer or EMService. •
command
 is one of the commands from the list below. •
instancename
 is the name of a server instance, where required. If a name is not specified, the command uses the default instance name. •
filename
 is the name of the file to read from or write to.

  SET QUERY_BAND = ‘MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;MSTRPriority=!i;’ FOR SESSION;
 Pre/Post Statements Cleanup Post Statement SET QUERY_BAND = NONE FOR SESSION; Pre/Post Statements Element Browsing Pre Statement SET QUERY_BAND = ‘MSTRProject=!p;;MSTRReport=ELEMENTBROWSE;;MSTRUser=!u;;MSTRJob=!j;;MSTRPriority=!i;;’ FOR SESSION; Pre/Post Statements Element Browsing Post Statement SET QUERY_BAND = NONE FOR SESSION; Query Optimizations Sub Query Type WHERE (col1, col2...) IN (SELECT s1.col1, s1.col2...)TypeArgumentUseDescriptionHSTMThstmtInputStatement handleUCHAR FAR *szSqlStrInputSQL statement to be executedSDWORDcbSqlStrInputLength of szSqlStr •

machinename
 is the name of the machine hosting the server instance or service. If this parameter is omitted, the service is assumed to be hosted on the local machine. •
login
 is the login for the machine hosting the server instance or service, and is required if you are not logged into that machine. You are prompted for a password. •
servicename
 is the name of the service, such as IntelligenceServer or EMService. •
command
 is one of the commands from the list below. •
instancename
 is the name of a server instance, where required. If a name is not specified, the command uses the default instance name. •
filename
 is the name of the file to read from or write to.

  SET QUERY_BAND = ‘MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;MSTRPriority=!i;’ FOR SESSION;
 Pre/Post Statements Cleanup Post Statement SET QUERY_BAND = NONE FOR SESSION; Pre/Post Statements Element Browsing Pre Statement SET QUERY_BAND = ‘MSTRProject=!p;;MSTRReport=ELEMENTBROWSE;;MSTRUser=!u;;MSTRJob=!j;;MSTRPriority=!i;;’ FOR SESSION; Pre/Post Statements Element Browsing Post Statement SET QUERY_BAND = NONE FOR SESSION; Query Optimizations Sub Query Type WHERE (col1, col2...) IN (SELECT s1.col1, s1.col2...)TypeArgumentUseDescriptionHSTMThstmtInputStatement handleUCHAR FAR *szSqlStrInputSQL statement to be executedSDWORDcbSqlStrInputLength of szSqlStr •

machinename
 is the name of the machine hosting the server instance or service. If this parameter is omitted, the service is assumed to be hosted on the local machine. •
login
 is the login for the machine hosting the server instance or service, and is required if you are not logged into that machine. You are prompted for a password. •
servicename
 is the name of the service, such as IntelligenceServer or EMService. •
command
 is one of the commands from the list below. •
instancename
 is the name of a server instance, where required. If a name is not specified, the command uses the default instance name. •
filename
 is the name of the file to read from or write to.

  SET QUERY_BAND = ‘MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;MSTRPriority=!i;’ FOR SESSION;
 Pre/Post Statements Cleanup Post Statement SET QUERY_BAND = NONE FOR SESSION; Pre/Post Statements Element Browsing Pre Statement SET QUERY_BAND = ‘MSTRProject=!p;;MSTRReport=ELEMENTBROWSE;;MSTRUser=!u;;MSTRJob=!j;;MSTRPriority=!i;;’ FOR SESSION; Pre/Post Statements Element Browsing Post Statement SET QUERY_BAND = NONE FOR SESSION; Query Optimizations Sub Query Type WHERE (col1, col2...) IN (SELECT s1.col1, s1.col2...)TypeArgumentUseDescriptionHSTMThstmtInputStatement handleUCHAR FAR *szSqlStrInputSQL statement to be executedSDWORDcbSqlStrInputLength of szSqlStr •

machinename
 is the name of the machine hosting the server instance or service. If this parameter is omitted, the service is assumed to be hosted on the local machine. •
login
 is the login for the machine hosting the server instance or service, and is required if you are not logged into that machine. You are prompted for a password. •
servicename
 is the name of the service, such as IntelligenceServer or EMService. •
command
 is one of the commands from the list below. •
instancename
 is the name of a server instance, where required. If a name is not specified, the command uses the default instance name. •
filename
 is the name of the file to read from or write to.

  SET QUERY_BAND = ‘MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;MSTRPriority=!i;’ FOR SESSION;
 Pre/Post Statements Cleanup Post Statement SET QUERY_BAND = NONE FOR SESSION; Pre/Post Statements Element Browsing Pre Statement SET QUERY_BAND = ‘MSTRProject=!p;;MSTRReport=ELEMENTBROWSE;;MSTRUser=!u;;MSTRJob=!j;;MSTRPriority=!i;;’ FOR SESSION; Pre/Post Statements Element Browsing Post Statement SET QUERY_BAND = NONE FOR SESSION; Query Optimizations Sub Query Type WHERE (col1, col2...) IN (SELECT s1.col1, s1.col2...)TypeArgumentUseDescriptionHSTMThstmtInputStatement handleUCHAR FAR *szSqlStrInputSQL statement to be executedSDWORDcbSqlStrInputLength of szSqlStr •

machinename
 is the name of the machine hosting the server instance or service. If this parameter is omitted, the service is assumed to be hosted on the local machine. •
login
 is the login for the machine hosting the server instance or service, and is required if you are not logged into that machine. You are prompted for a password. •
servicename
 is the name of the service, such as IntelligenceServer or EMService. •
command
 is one of the commands from the list below. •
instancename
 is the name of a server instance, where required. If a name is not specified, the command uses the default instance name. •
filename
 is the name of the file to read from or write to.

Get information about the Server Control Utility

List all commands for the Server Control Utility.

This command does not require a machine name, login, or service name.

-h


--help


Display the version number of the Server Control Utility.

This command does not require a machine name, login, or service name.

-V


--version


Get information about the Strategy network

List machines that the Server Control Utility can see and affect.

This command does not require a machine name, login, or service name.

lm


list-machines

List the Strategy services available on a machine.

This command does not require a service name.

ls


list-servers


List the ODBC DSNs available on a machine.

This command does not require a service name.

lod


list-odbc-dsn


Configure a service

Display the configuration information for a service, in XML format. For more information, see Using files to store output and provide input.

You can optionally specify a file to save the configuration properties to.

gsvc 
instancename 
[> 
filename
.xml]


get-service-configuration 
instancename 
[> 
filename
.xml]


Specify the configuration information for a service, in XML format. For more information, see Using files to store output and provide input.

You can optionally specify a file to read the configuration properties from.

ssvc 
instancename 
[< 
filename
.xml]


set-service-configuration 
instancename 
[< 
filename
.xml]


Configure a server

Display the configuration properties of a server, in XML format. For more information, see Using files to store output and provide input.

You can optionally specify a file to save the configuration properties to.

gsc
 
[> 
filename
.xml]


get-server-configuration			[> 
filename
.xml]


Specify the configuration properties of a server, in XML format. For more information, see Using files to store output and provide input.

You can optionally specify a file to read the configuration properties from.

ssc
 
[< 
filename
.xml]


set-server-configuration			[< 
filename
.xml]


Configure a server instance

Display the configuration information for a server instance, in XML format. For more information, see Using files to store output and provide input.

You can optionally specify a file to save the configuration properties to.

gsic 
instancename 
[> 
filename
.xml]


get-server-instance-configuration 
instancename 
[> 
filename
.xml]


Specify the configuration information for a server instance, in XML format. For more information, see Using files to store output and provide input.

You can optionally specify a file to read the configuration properties from.

ssic 
instancename


set-server-instance-configuration 
instancename 
[< 
filename
.xml]


Manage server instances

Display the default instance for a service.

gdi


get-default-instance


Set an instance of a service as the default instance.

sdi 
instancename


set-default-instance 
instancename


Create a new server instance.

ci 
instancename


create-instance 
instancename


Create a copy of a server instance. Specify the name for the new instance as 

newinstancename
.

cpi 
instancename newinstancename


copy-instance 
instancename newinstancename


Delete a server instance.

di 
instancename


delete-instance 
instancename


Register a server instance as a service.

rs 
instancename


register-service 
instancename


Unregister a registered server instance as a service.

us 
instancename


unregister-service 
instancename


Display the license information for a service instance.

gl 
instancename


get-license 
instancename


Display the status information for a server instance

gs 
instancename


get-status 
instancename


Start or stop a server instance

Start a server instance as a service.

start --service 
instancename


Start a server instance as an application. For more information, see Starting Intelligence Server as an application.

start --interactive 
instancename


Stop a server instance that has been started as a service.

stop 
instancename


Pause a server instance that has been started as a. service

pause 
instancename


Resume a server instance that has been started as a service and paused.

resume 
instancename


Terminate a server instance that has been started as a service.

term 
instancename


terminate 
instancename

Using files to store output and provide input

Certain Server Control Utility commands involve XML definitions. The commands to display a server configuration, a service configuration, and a server instance configuration all output an XML definition. The commands to modify a server configuration, a service configuration, and a server instance configuration all require an XML definition as input.
It is difficult and time consuming to type a complete server, service, or server instance configuration from the command line. An easier way to configure them is to output the current configuration to a file, modify the file with a text editor, and then use the file as input to a command to modify the configuration.
Configuring Intelligence Server with XML files requires extensive knowledge of the various parameters and values used to define Intelligence Server configurations. Providing an incorrect XML definition to configure Intelligence Server can cause errors and unexpected functionality.
For example, the following command saves the default server instance configuration to an XML file:

mstrctl -s IntelligenceServergsic > 
filename
.xml

The server instance configuration is saved in the file 
filename
.xml
, in the current directory.
The following command modifies the default server instance configuration by reading input from an XML file:
mstrctl -s IntelligenceServerssic < 
filename
.xml

The XML definition in 
ServerInstance.xml
 is used to define the server instance configuration.

Comment

0 comments

Details

Example

Published:

June 13, 2017

Last Updated:

June 13, 2017