How to change the value of MaxDB parameter UseDBAnalyzer

[SAPSupport]

Hello Team,

We want to adjust the parameter value of "UseDBAnalyzer" using Database Studio.
However the parameter does not appear when searching in Studio and we are unable to adjust the parameter. 

Thank You

------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

[SAPSupport · Accepted solution]

With DBM Command param_getfull UseDBAnalyzer, you can get detailed information for this parameter.

-1 : default setting

0 : analyzer is disabled

> 0 : number of seconds for measurement interval (-1 means the value from db analyzer configuration file analyzer)

You can try to use command line to change the value of UseDBAnalyzer.
param_put UseDBAnalyzer <value>


Best regards,
SAP Support

[holger_becker]

Hi,

the UseDBAnalyzer parameter is a hidden parameter because it is only intended to be used internally by the MaxDB tools and not directly manipulated by the user. To set the properties of the Database Analyzer such as automatic start or the desired snapshot interval, the dbmcli commands dban_start or auto_dbanalyzer should be used. More information can be found in Commands for Using Database Analyzer

Best regards