Architecture Checker - Information - How to launch Architecture Checker in SHOW SQL mode

Purpose

This page explains, how to activate SQL traces in Architecture Checker.

Applicable in CAST Version

ReleaseYes/No
8.3.x
8.2.x
8.1.x
8.0.x

Applicable RDBMS

RDBMSYes/No
Oracle Server
Microsoft SQL Server
CSS2

Details

SHOW SQL mode can be activated for AC by adding -ShowSQL at the end of the command line of AC. This can be done by using either one of the following methods:

  1. By creating a shortcut

    1. Create a shortcut for TCC executable from the flat (TCC executable is named CAST-TransactionConfig.exe)
    2. Right click on the shortcut → Properties → Shortcut tab, then add ‘-ShowSQL’ to the end of the command line as shown below.
  2. By running AC from CMD by adding the option -ShowSQL

\CAST-TransactionConfig.exe -ShowSQL


   SQL trace will be present in AC log file, for the location of the log file refer to [CAST Management Studio - Information - How to find logs](/export-v2/tg/information-guides/information-guides-by-cast-aip-component/cast-management-studio-cms/cast-management-studio-information-how-to-find-logs/)

**Notes/comments**

**Related Pages**