Books
in black and white
Main menu
Share a book About us Home
Books
Biology Business Chemistry Computers Culture Economics Fiction Games Guide History Management Mathematical Medicine Mental Fitnes Physics Psychology Scince Sport Technics
Ads

Teradata RDBMS Database Administration - NCR

NCR Teradata RDBMS Database Administration - NCR , 2004. - 616 p.
Download (direct link): teradatadatabaseadmin2004.pdf
Previous << 1 .. 159 160 161 162 163 164 < 165 > 166 167 168 169 170 171 .. 218 >> Next


First 200 characters of the query SQL statement.

Row Values

The available fields in a DBQLogTbl row are as follows:

DBC.DBQLogTbl Field Description
ProcID Unique processor ID of the dispatcher and part of the multi-column NUPI for the table (see also CollectTimeStamp).
CollectTimeStamp A date and time unique to each buffer cache, which changes for each new buffer. Part of the multi-column NUPI for the table (see also ProcID).
QueryID Internally-generated identifier of the query and the FK to other DBQL tables. This value might be zero (0), for example in the case of a query that is aborted or has errors.
UserID The unique ID of the user whose query is logged.

14 - 10 Teradata RDBMS Database Administration

Chapter 14: Tracking Processing Behavior with the Database Query Log (DBQL)

Logging Implementation and Validation

DBC.DBQLogTbl Field Description
AcctString The account string at the time the row was committed. Because accounts can be changed dynamically at the query or session level (see "SET SESSION ACCOUNT" under "Changing the Performance Group of a Running Job" on page 5-23), this may not be the same account that: DBQL verified for the user at logon time Was in effect when processing of this query began
ExpandAcctString The logged account string plus the expanded value of any ASE codes. (For codes and values, see "Enabling ASE" on page 5-28.) For example, if the AccountString field contains: SALES&H then the value of ExpandAcctString is: SALES13
SessionID Unique session identifier.
LogicalHostID Unique identifier of the logon source (client connection). A value of 0 indicates the console (PDN).
RequestNum Unique identifier of the query.
LogonDateTime Timestamp of the start of the session.
AcctStringTime Value of the &T ASE code in the account string. If none exists, the value is ?.
AcctStringHour Value of the expanded &H ASE code in the account string. If none exists, the value is ?.
AcctStringDate Value of the expanded &D ASE code in the account string. If none exists, the value is ?.
AppID Application (executable) name; for example, BTEQ.
ClientID The network or channel client user name under which this session is logged (for example, ADMIN) and the PK/FK for the table.
ProfileID The name of the profile, if any, under which the user submitted this query.
StartTime Timestamp when the query was submitted.
FirstStepTime Timestamp when the first step was dispatched.
FirstRespTime Timestamp when the first response packet was sent to host.
LastRespTime Timestamp when the last response packet was sent to host.

14 - 10 Teradata RDBMS Database Administration Chapter 14: Tracking Processing Behavior with the Database Query Log (DBQL)

Logging Implementation and Validation

DBC.DBQLogTbl Field Description
NumSteps Total number of Level 1 steps required to process the query. If steps do not apply, such as if the query was aborted or you ended logging for the user before steps were generated, the value is 0 (zero).
NumStepswPar Total number of Level 1 steps with parallel steps.
MaxStepsInPar Maximum number of Level 2 steps done in parallel for this query.
ErrorCode If used, the number of the error message in ErrorText. This field contains a code if the query caused a parser syntax error.
ErrorText If used, contains an informative message to the user, for example to explain the query was not processed due to a: Parser syntax error Delay based on TDQM rules (also see the TDQMFlag field in this table)
TDQMFlag If used, the value is T and an informative TDQM message is stored in the ErrorText field. Elapsed delay time is the difference between FirstStepTime and StartTime. Used when DBQL is enabled and TDQM sends an informative message to a user being logged, for example to say that a query cannot be processed immediately because of TDQM Workload rules (for details, see "TDQM Rules" on page 15-12).
AbortFlag T if the query being logged was aborted. The collected data could be incomplete.
CacheFlag T if the query was run from the statement cache and thus was repeated within the session.
QueryText The first characters of the SQL query. Up to 200 characters are captured by default. If you specify the SQLTEXT option, you can specify 0 (zero) characters, essentially turning off QueryText capture, or you can specify a number up to a maximum of 10,000 characters. Currently, DBQL does not log any SP information.

14 - 10 Teradata RDBMS Database Administration

Chapter 14: Tracking Processing Behavior with the Database Query Log (DBQL)

Logging Implementation and Validation

DBQLObjTbl

With the OBJECTS option, DBQL logs one row in DBQLObjTbl for each data object referenced by the query. An object can be a database, data table, column, secondary index, join index, or journal table. (If the object is a secondary index, its number is logged rather than a name.) Also logged is a count of the number of times the object was accessed by the optimizer.
Previous << 1 .. 159 160 161 162 163 164 < 165 > 166 167 168 169 170 171 .. 218 >> Next