CMS Application - Reference Pattern Search String - Information - How to activate SQL traces in Search string

This page explains how to activate SQL traces in Search String.

SHOW SQL mode can be activated for Search String by adding - Show(SQL) at the end of the command line of the anarun.

Steps to activate:

• Run the Reference Pattern search string. Once the Run Reference Pattern search string has started, cancel it.
  
  
  
  
• Open the CAST MS log file that is in CAST Management Studio - Information - How to find logs - CastMS Log File
• Search for the statement "starting Task Run Reference Pattern Search String". The command line that has been executed to run the reference pattern search string is just below this statement :
  
  
  

• Copy the command line.
• After anarun, add -SHOW(SQL)
• Run the complete command line as below screenshot :