All Forums Analytics
jackde 1 post Joined 01/06
06 Jan 2006
dbql rule help

I am trying to set up some rules for DBQL logging per recommendation, but am encountering an error.when I running the following sql begin query logging with objects, stepinfo, sql limit threshold = 5 on ret_msiusr1qathe error return is "cannot specify other options with Summary or Threshold.I have tried to create only a rule on a user with just the threshold, which works fine but then I cannot create any other rule on that user. Does anyone know what I might be doing wrong or do I have to initialize the summary table? HELP!!!

Phani 15 posts Joined 07/04
29 Jun 2006

As mentioned in the error message, if you select Summary, you can not add a rule with other options. The best way to see these dependecies is to use Teradata Administrator. If you select Query Logging from Tools menu, you can see all possible options. You can notice that other options are not available as soon as you pick up summary mode.

You must sign in to leave a comment.