BAAN SQL Trace:
We usually face performance issues in few program so we need to understand which query of taking time to analyse the performance issue. In BAAN we have SQL Trace functionality which will give you list of queries and execution time. Basically we need to modify BW Configuration file with following syntax:
-keeplog -logfile mylogfile -set TT_SQL_TRACE=000200
This command will create mylogfile in home directory of current user. This file will looks like:
This file will show all queries executed since you added SQL Trace in your BW Configuration file.
To get detailed flow of use following command in BW config file:
-- -dbgflow -dbgfun -dbgcpu -tracelevel 1 -logtime -set BDB_DEBUG=02 -set BAAN_SQL_TRACE=2000 -logfile /baantst/tmp/bshdebug.trace -keeplog
We usually face performance issues in few program so we need to understand which query of taking time to analyse the performance issue. In BAAN we have SQL Trace functionality which will give you list of queries and execution time. Basically we need to modify BW Configuration file with following syntax:
-keeplog -logfile mylogfile -set TT_SQL_TRACE=000200
This command will create mylogfile in home directory of current user. This file will looks like:
To get detailed flow of use following command in BW config file:
-- -dbgflow -dbgfun -dbgcpu -tracelevel 1 -logtime -set BDB_DEBUG=02 -set BAAN_SQL_TRACE=2000 -logfile /baantst/tmp/bshdebug.trace -keeplog
No comments:
Post a Comment