How to enable the SmartStor metric query logging in EM_HOME/logs file querylog.txt (it always has size of 0 bytes).

Document ID : KB000011433
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

How to enable the SmartStor metric query logging in EM_HOME/logs file querylog.txt (it always has size of 0 bytes).

Answer:

1. Edit <EM_HOME>/config/IntroscopeEnterpriseManager.properties

2. Change these properties:

log4j.additivity.Manager.QueryLog=false

log4j.logger.Manager.QueryLog=INFO, querylog

TO:

log4j.additivity.Manager.QueryLog=true

log4j.logger.Manager.QueryLog=DEBUG, querylog

3. Save the file.

4. The properties are hot configurable so will be processed by the Enterprise Manager after a maximum of 1 minute. INFO logging will show "Detected hot config change to ...\config\IntroscopeEnterpriseManager.properties", while DEBUG logging will show the changed properties.

Additional Information:

1. In a cluster environment the querylog can be enabled on both MOM and Collectors. The query will be visible in both the querylog for the MOM and the querylog for the Collector that receives the query via the MOM.

2. These 2 properties are also hot configurable if they need to be changed while the Enterprise Manager is running

  • log4j.appender.querylog.MaxBackupIndex
  • log4j.appender.querylog.MaxFileSize