On VantageCloud Lake, query logging is controlled by the system. Because of this, the output from SHOW QUERY LOGGING provides DBQL RULE information for active queries, for system queries, and for user queries.
SHOW QUERY LOGGING ON user1;
Result:
Rule UserName "user1" (From a System rule)
Rule UserId 00000000
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 T F
XMLPlan F F F
StatsUsage F F F
UseCount F F F
Param F F F
FeatureUsage T T F
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 0
The output shows if DBQL logs particular items (T) or not (F). For example, SQL is logged for the system, but not for this user.
You can change the logging for a user:
REPLACE QUERY LOGGING WITH PARMINFO ON user1;
Result:
DBQL RULE: Active System User
Explain F F F
Object F F F
SQL T T F
Step T T F
XMLPlan F F F
StatsUsage F F F
UseCount F F F
Param T F T
FeatureUsage T T F
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 0
The output shows that Param is now set to true for the user, so information about parameters is logged to DBC.DBQLParamTbl and viewable in the DBC.QryLogParamV view.