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_msiusr1qa
the 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!!!
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.