Running Query Analyzer in a Cortex Development Environment

1. Update the MAVEN_OPTS system variable:

   • For Windows, open command prompt and run the following:

     set MAVEN_OPTS=%MAVEN_OPTS% -Dcom.sun.management.jmxremote -Dcom.sun.management.jmxremote.port=6969 -Dcom.sun.management.jmxremote.ssl=false -Dcom.sun.management.jmxremote.authenticate=false
     

   • For Linux, start a terminal and run the following:

     export MAVEN_OPTS="$MAVEN_OPTS -Dcom.sun.management.jmxremote -Dcom.sun.management.jmxremote.port=6969 -Dcom.sun.management.jmxremote.ssl=false -Dcom.sun.management.jmxremote.authenticate=false"
     

   This enables remote JMX connections, so that you can connect to the application through JMX and configure logging as required. Use the mvnDebug command to enable debugging

2. Run Cortex in the same terminal.

3. Navigate to the extensions/cortex/ext-cortex-webapp module and run the following command:

   mvn tomcat8:run-war
   

4. Execute a request in Cortex Studio to prime caches.

5. Start the Query Analyzer using the Felix Console.

6. Execute the request in Cortex Studio again.

7. Stop the Query Analyzer using the Felix Console.

8. To view query statistics, open {$user_home}/ep/db_statistics.json.

   Use an online JSON viewer, such as JSON Editor Online, or install a JSON viewer in your IDE to view the results.