MicroStrategy ONE

Alter Server Configuration statement

Modifies the configuration of a MicroStrategy Intelligence Server. To cause these changes to take effect, use the Apply Run-time Settings statement.

Some configuration changes require that Intelligence Server be restarted before they take effect. Consult the Intelligence Server documentation for the configuration change you are making to determine whether it requires that Intelligence Server be restarted.

Copy 
ALTER SERVER CONFIGURATION [DESCRIPTION "<description>"] [MAXCONNECTIONTHREADS <number_of_threads>] [CONTENTSERVERDBINSTANCE "<content_server_db_instance_name>" ] [BACKUPFREQ <number_of_minutes>] [USEPERFORMANCEMON (FALSE | TRUE)] [USEMSTRSCHEDULER (FALSE | TRUE)] [SCHEDULERTIMEOUT <seconds>] [BALSERVERTHREADS (FALSE | TRUE)] [CACHECLEANUPFREQ <seconds>] [LICENSECHECKTIME <time_of_day>] [ENABLEUSERAFFINITYCLUSTER (FALSE | TRUE) ENABLESUBSCRIPTIONLOADBALANCING (FALSE | TRUE)] [HISTORYLISTREPOSITORYTYPE DBBASED ENABLEREPORTCACHEBACKUP (FALSE | TRUE) HYBRIDCENTRALINBOXFILEPATH "<file_path>"] [HISTORYDIR "<folder_path>"] [MAXNOMESSAGES <number_of_messages>] [MESSAGELIFETIME <number_of_days>] [MAXNOJOBS <number_of_jobs>] [MAXNOCLIENTCONNS <number_of_client_conns>] [IDLETIME <number_of_seconds>] [WEBIDLETIME <number_of_seconds>] [MAXNOXMLCELLS <number_of_xml_cells>] [MAXNOXMLDRILLPATHS <number_of_xml_drill_paths>] [MAXMEMXML <number_MBytes>] [MAXMEMPDF <number_MBytes>] [MAXMEMEXCEL <number_MBytes>] [MAXMEMHTML <number_MBytes>] [ENABLEWEBTHROTTLING (TRUE | FALSE)] [MAXMEMUSAGE <percentage>] [MINFREEMEM <percentage>] [ENABLEMEMALLOC (TRUE | FALSE)] [MAXALLOCSIZE <number_MBytes>] [ENABLEMEMCONTRACT (TRUE | FALSE)] [(MINRESERVEDMEM <number_MBytes> | MINRESERVEDMEMPERCENTAGE <percentage>)] [MAXVIRTUALADDRSPACE <percentage>] [MEMIDLETIME <seconds>] [WORKSETDIR "<folder_path>"] [MAXRAMWORKSET <number_KBytes>] [AUTODELETEMESSAGECOUNT <number_of_messages>] [ERRORMESSAGESFIRST (FALSE | TRUE)] [DELETEOLDESTMESSAGESBY (CREATIONTIME | MODIFICATIONTIME | STARTTIME | FINISHTIME)] [ENABLECACHEAUTOUNLOAD (TRUE | FALSE)] [LDAPSERVERNAME "<ldap_server_name>"] [LDAPSERVERPORT <ldap_server_port>] [LDAPAUTHMETH (COMPAREPWD |BINDING)] [LDAPSECCONN (TEXT|SSL [LDAPSERVERCERTIFICATE "<ldap_server_certificate_file>"])] [LDAPAUTHDN "<ldap_user_distinguished_name>"] [LDAPAUTHPWD "<ldap_user_password>"] [LDAPSERVERVENDORNAME (IBM|OTHERS|NOVELL|ADS|SUNONE|OPENLDAP|HPUX)] [LDAPSEARCHROOTDN "<ldap_search_root_dn>"] [LDAPSEARCHFILTERUSER "<ldap_search_filter_for_user>"] [LDAPSEARCHFILTERGROUP "<ldap_search_filter_for_group>"] [LDAPIMPORTUSER (NOTIMPORT|IMPORT)] [LDAPIMPORTGROUP (NOTIMPORT|IMPORT)] [LDAPSERVERDRIVER (IBM|OTHERS|NOVELL|ADS|SUNONE|OPENLDAP|HPUX)] [ LDAPISERVERPLATFORM (WINDOWS|SOLARIS|AIX|LINUX|HPUX)] [LDAPCONNECTIVITYFILE "<dll_file_1>"[, "<dll_file_2>"...]] [LDAPSYNCHRONIZEUSERGROUP (NONE|USER|GROUP|ALL)] [LDAPBATCHIMPORTUSER (NOTIMPORT|IMPORT)][LDAPBATCHIMPORTGROUP (NOTIMPORT|IMPORT)] [LDAPBATCHSYNCHRONIZEUSERGROUP (NONE|USER|GROUP|ALL)][LDAPBATCHSEARCHFILTERFORUSER "<ldap_search_filter_for_user_in_batch>"] [LDAPBATCHSEARCHFILTERFORGROUP "<ldap_search_filter_for_group_in_batch>"] [LDAPATTRIBUTELOGIN (CN|DN|"<login_name_imported_as>")] [LDAPATTRIBUTEUSERNAME (CN|DN|"<login_name_imported_as>")] [LDAPATTRIBUTEGROUP (CN|DN|"<login_name_imported_as>")] [LDAPNTAUTHENTICATION (TRUE|FALSE)] [SERVERTOREFORMATSTARTUP ("<server_name>"[, "<server_name>"...] | NONE)];

where:

  • description is the description to apply to the server, of type string, between double quotes (" ").

  • number_of_threads is the number of threads to apply to the server, of type integer.

  • content_server_db_instance_name is the database instance name of content server location, of type string, between double quotes(" ")

  • number_of_minutes is the number of minutes to apply to the different properties, of type integer.

  • number_of_seconds is the number of seconds to apply to the different properties, of type integer.

  • time_of_day is the time of the day (24-hour format) to be specified for the license check process, of type time (hh:mm).

  • ENABLEUSERAFFINITYCLUSTER (FALSE | TRUE) is whether user affinity cluster is enabled on the server.

  • ENABLESUBSCRIPTIONLOADBALANCING (FALSE | TRUE) is whether subscription load balancing is enabled on the server.

  • HISTORYLISTREPOSITORYTYPE DBBASED change the history list repository type to DB based.

  • ENABLEREPORTCACHEBACKUP (FALSE | TRUE) is whether backup report history caches to database is enabled on the server.

  • HYBRIDCENTRALINBOXFILEPATH "file_path" is the external central storage directory for Database-based history list, of type string.

  • folder_path is the directory that the server is to use for the History List, of type string, between double quotes (" ").

  • number_of_messages is the maximum number of History List messages that the server is to store, of type integer.

  • number_of_days is the number of days that a History List message will be valid, of type integer.

  • number_of_jobs is the maximum number of concurrent jobs that the server is to execute, of type integer.

  • number_of_client_connections is the maximum number of concurrent user connections that the server is to accept, of type integer.

  • number_of_XML_cells is the maximum number of XML cells that the server is to generate for a given report, of type integer.

  • number_of_XML_drill_paths is the maximum number of XML drill paths that the server is to generate for a given report, of type integer.

  • number_of_MBs is the number of megabytes to apply to the different properties, of type integer.

  • percentage is the minimum percentage that the server is to have for free memory, of type integer.

  • number_of_KBs is the maximum number of kilobytes that the server is to use on memory, of type integer.

  • number_of_messages is the number of History List messages to be deleted to make space for new messages, of type integer.

  • ldap_server_name is the network name of the LDAP server, of type string, between double quotes (" ").

  • ldap_server_port is the network port used by the LDAP server, of type integer.

  • ldap_server_certificate_file is the file containing the LDAP certificate, of type string, between double quotes (" ").

  • ldap_user_distinguished_name is the LDAP distinguished name of the LDAP user, of type string, between double quotes (" ").

  • ldap_user_password is the password for the specified LDAP user, of type string, between double quotes (" ").

  • ldap_search_root_dn is the distinguished name that serves as a search root  for this LDAP directory, of type string, between double quotes (" ").

  • ldap_search_filter_for_user is the LDAP user search filter, of type string, between double quotes (" ").

  • ldap_search_filter_for_group is the LDAP group search filter, of type string, between double quotes (" ").

  • dll_file_1..n are the LDAP connectivity DLL files, of type string, between double quotes (" ").

  • ldap_search_filter_for_user_in_batch is the LDAP batch user search filter, of type string, between double quotes (" ").

  • ldap_search_filter_for_group_in_batch is the LDAP batch group search filter, of type string, between double quotes (" ").

  • login_name_imported_as is the LDAP attribute imported as the MicroStrategy login, of type string, between double quotes (" ").

  • user_name_imported_as is the LDAP attribute imported as the MicroStrategy user name, of type string, between double quotes (" ").

  • group_name_imported_as is the LDAP attribute imported as the MicroStrategy group name, of type string, between double quotes (" ").

Example

Copy 
ALTER SERVER CONFIGURATION MAXCONNECTIONTHREADS 5 BACKUPFREQ 0 USENTPERFORMANCEMON TRUE USEMSTRSCHEDULER TRUE BALSERVERTHREADS FALSE HISTORYDIR ".\INBOX\dsmith" MAXNOMESSAGES 10 MAXNOJOBS 10000 MAXNOCLIENTCONNS 500 WEBIDLETIME 0 MAXNOXMLCELLS 500000 MAXNOXMLDRILLPATHS 100 MINFREEMEM 0;