Example: Report Options for a User when System-Level Logging is Enabled and User-Level Rule is in Place - Teradata Vantage

REPLACE Statement

REPLACE QUERY LOGGING with STEPINFO DETAILDIAG=128 STEPETTHRESHOLD=100 on user1;

SHOW Statement

SHOW QUERY LOGGING on user1

Result:

    Rule UserName   user1 (From a System and a User rule)
      Rule UserId   00005404
      Rule ZoneId   00000000
          Account   (Rule for any Account)
       DBQL RULE: Active  System  User
          Explain   F       F      F
           Object   F       F      F
              SQL   T       T      F
             Step   T       F      T
          XMLPlan   F       F      F
       StatsUsage   F       F      F
         UseCount   F       F      F
            Param   F       F      F
     FeatureUsage   T       T      T
          Verbose   F       F      F
     StatsDetails   F       F      F
      UtilityInfo   T       T      F
        NoColumns   F       F      F
          Summary   F       F      F
        Threshold   F       F      F
  Text Size Limit   200     200    200
 DETAILDIAG RULE:  User
      AMPDataDiag   T
      ExtDBQLData   F
SumThreshOverride   F
  StepETThreshold     User : 100