Begin Query Logging Options for All and a Specific User

Database
Teradata Employee

Begin Query Logging Options for All and a Specific User

Hi,

 

We enabled XMLPlan logging option for a specific user on our system.

 

I need to know that whether we have to explicity enable rest of the logging options that i see in All user options for that one user or will that particualr user rest of the settings will be treated the same for All user settings. For e.g. I see StatsUsage and ObjUsage settings as 'T' in All while they are 'F' for my specific user. Will my specific user able to log StatsUsage and ObjUsage or should i explicity had to enable it.


Accepted Solutions
Senior Apprentice

Re: Begin Query Logging Options for All and a Specific User

Hi,

You'll need to enable the other options as well for this user.

Once DBQL has found a rule to use (e.g. based on username) it only looks at that rule when determining what to log.

Cheers,

Dave

 

Ward Analytics Ltd - information in motion
www: http://www.ward-analytics.com
1 ACCEPTED SOLUTION
2 REPLIES
Senior Apprentice

Re: Begin Query Logging Options for All and a Specific User

Hi,

You'll need to enable the other options as well for this user.

Once DBQL has found a rule to use (e.g. based on username) it only looks at that rule when determining what to log.

Cheers,

Dave

 

Ward Analytics Ltd - information in motion
www: http://www.ward-analytics.com
Highlighted
Teradata Employee

Re: Begin Query Logging Options for All and a Specific User

Hi Dave,

 

Thanks for the information. I have enabled rest of logging options for that user now.