Log request information with an SQL text limit for user_1 and user_2:
BEGIN QUERY LOGGING LIMIT THRESHOLD=4 AND SQLTEXT=100 ON user_1, user_2;
The following table describes the logging behavior for various request completion times for the specified threshold.
| Query Completion Time in Seconds | Log Table … |
|---|---|
| ≤ 4 | DBQLSummaryTbl. The requests are recorded only as counts in the QueryCount column. |
| > 4 | DBQLogTbl. The logged SQL text is limited to 100 characters. |
Log requests for user_1 and user_2:
BEGIN QUERY LOGGING WITH SQL, STEPINFO, OBJECTS LIMIT THRESHOLD=10 CPUTIME ON user_1, user_2;
You can specify equivalent query logging using various methods. For example, specify THRESHOLD with the SQL, STEPINFO, and OBJECTS options individually:
BEGIN QUERY LOGGING WITH SQL LIMIT THRESHOLD=10 CPUTIME ON user_1, user_2; BEGIN QUERY LOGGING WITH STEPINFO LIMIT THRESHOLD=10 CPUTIME ON user_1, user_2; BEGIN QUERY LOGGING WITH OBJECTS LIMIT THRESHOLD=10 CPUTIME ON user_1, user_2;