16.10 - Teradata Dynamic Workload Management View of the Main Log Table: QryLogTDWM[V] - Teradata Database

• DBQL verified for the user at logon time
• Was in effect when processing of the query began

This time will be set when the cache is ready to receive new data, not when rows are written to the database.

For more information on CollectTimeStamp, see Comparing CollectTimeStamp Value Between Tables.

For commands, other than those within a stored procedure, the internal request number and the number in the RequestNum field will be the same.

For stored procedures invoked within a session, the internal request number increments by 1 for every request made by the stored procedure. This means that RequestNum will be the request number of the CALL and the value in InternalRequestNum will continue to increment for all other queries issued by the session.

• DDL ALTER
• DDL CREATE
• DDL GRANT

If the statement has only one DML statement or multiple DML statements that are all of the same type, StatementGroup will indicate the type. For example if there are three DELETE statements in a request, StatementGroup will report:

DML DELETE

Similarly, for requests with individual or multiple INSERT, INSERT... SELECT, UPDATE or SELECT statements, StatementGroup will report:

• DML INSERT
• DML INSERT... SELECT
• DML UPDATE
• SELECT

In a multistatement request with different types of DML statements, you will see a list showing the number of statements of each type in the request. For example, a request with one insert and two update statements will appear as: