Tracing stored procedure parameter values

Database

Tracing stored procedure parameter values

For one of our use cases we use AccessLogV, DBQLSQLTbl , DBQLSQLTbl to trace stored procedure executions.

In order to trace its parameter values we referred QryLogParam. But the data are not traceable.

Which is the best mechanism (from the Teradata log info) to trace stored procedure calls and their parameter values?

3 REPLIES

Re: Tracing stored procedure parameter values

Hello experts,

any direction on how to overcome the issue?

Teradata Employee

Re: Tracing stored procedure parameter values

Not sure of the question. Did you enable query logging with the PARAMINFO option?

Enthusiast

Re: Tracing stored procedure parameter values

you need to enable this replace Query Logging with PARAMINFO on ALL; (or specific account you would like to).

The only issue i had is that i can trace any store proc parameters executed from SQLA but could not trace any procs that executed from a .NEt applicaiton, any idea?