Transaction Configuration Center - Information - How to launch TCC in SHOW SQL mode in order to get the SQL traces

Purpose

This page explains how to activate SQL traces in TCC.

Applicable in CAST Version


Release
Yes/No
8.3.x(tick)
8.2.x(tick)
8.1.x(tick)
8.0.x(tick)
7.3.x(tick)
Applicable RDBMS
RDBMS
Yes/No
Oracle Server (tick)
Microsoft SQL Server (tick)
CSS2 (tick) 
Details

SHOW SQL mode can be activated for TCC by adding -ShowSQL at the end of the command line of the TCC.

Steps to activate:

Create a shortcut for TCC executable from the flat (TCC executable is named CAST-TransactionConfig.exe)

Right click on Windows shortcut for TCC and choose Shortcut. Add '-ShowSQL' to the end of the command line as shown below.

Example: "C:\Program Files (x86)\CAST\7.3.0\CAST-TransactionConfig.exe" -ShowSQL

Launch TCC from the shortcut created to activate SQL traces.

SQL trace will be present in TCC log. If you want to modify TCC log location, please refer to Transaction Configuration Center - Information - How to change the default location of TCC log file

Notes/comments