DBQL - Account String logging and individual user logging.

Database
Enthusiast

DBQL - Account String logging and individual user logging.

Hello,

We have an user 'user01' with account '$Test'. The DBQL logging is on for account '$Test' as

BEGIN QUERY LOGGING LIMIT SQLTEXT=200 ON "$Test" ;

The dbc.dbqlrules doesnt show me any row for "user01" which is fine.

We want to have StepInfo on the user 'user01' for a query.

BEGIN QUERY LOGGING WITH SQL, STEPINFO ON "user01";

As far as I understand I need to end the query logging on the "user01" first then issue the above statement. Also when I finish off capturing stepinfo information i need to end the query logging with stepinfo

END QUERY LOGGING WITH SQL, STEPINFO ON "user01";

My query is do i need to issue BEGIN QUERY LOGGING FOR user01 again in order that the normal logging is in place as it was earlier. This will add a row into dbc.dbqlrules for the "user01". And what if i do not BEGIN query logging? Will it log the queries according to the settings in place for the account that user has?

1 REPLY
Enthusiast

Re: DBQL - Account String logging and individual user logging.

Query logging can be enabled and is recommended at the account string level. What account string expansion variables are being used? It is possible that without ASE certain levels of detail can not be captured accurately by DBQL.