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 .. 160 161 162 163 164 165 < 166 > 167 168 169 170 171 172 .. 218 >> Next


The fields populated in an objects row are:

DBC.DBQLObjTbl Field Description
ProcID Unique processor ID of the dispatcher and part of the multi-column NUSI (see also CollectTimeStamp).
CollectTimeStamp A date and time unique to each buffer cache, which changes for each new buffer. Part of the multi-column NUSI (see also ProcID).
QueryID Internally-generated identifier of the query. This value might be zero (0), for example in the case of a query that is aborted or has errors.
ObjectDatabaseName Name of the database that owns the target object.
Obj ectTableNam e Name of the table or view.
ObjectColumnName Name of the column.
ObjectID Unique internal identifier of this object.
ObjectNum Number of the column or secondary index.
ObjectType Character code indicating the type of object targeted. Possible characters and the object each represents are:

ObjectType (continued)

Type Code Object
C Column
D Database
I Secondary index
J Join index
R Journal
T Table

FreqofUse

Number of times the object was accessed, as determined by the optimizer, to process this query.

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

Logging Implementation and Validation

DBQLSQLTbl

The DBQLSQLTbl is populated if you specify the SQL option in addition to default information. The SQL option logs the full statement text, no matter how large, into DBQLSqlTbl. Multiple rows are generated as necessary.

Note: the full SQL text of a CREATE/ALTER/REPLACE PROCEDURE/ FUNCTION is not logged in DBQLSQLTbl when the statement is submitted with the option to not save the source in the database.

The populated fields in a DBQSQLTbl row are as follows:

DBC.DBQSQLTbl Field Description
ProcID Unique processor ID of the dispatcher and part of the multi-column NUPI (also see CollectTimeStamp).
CollectTimeStamp A date and time unique to each buffer cache, which changes for each new buffer. Part of the multi-column NUSI (see also ProcID).
QueryID Internally-generated identifier of the query. This value might be zero (0), for example in the case of a query that is aborted or has errors.
SQLRowNo Row number of the statement. Value is 1 unless the statement is large and requires multiple rows.
SQLTextInfo A full SQL text segment, a string of up to approximately 32,000 characters. Note: BTEQ has a maximum column length of 254 bytes. Use Teradata SQL Assistant, formerly known as Queryman, to display longer lengths.

DBQLStepTbl

DBQLStepTbl is populated if you specify the STEPINFO option. When the query completes, it logs one row for each query step, including parallel steps.

The populated fields in a DBQStepTbl row are as follows:

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

14 - 10 Teradata RDBMS Database Administration

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

Logging Implementation and Validation

DBC.DBQStepTbl Field Description
StepLev1Num Step number. If this row is for a parallel step, the number is repeated for as many parallel steps as were used for this step (for examples, see StepLev2Num).
StepLev2Num If this row is for a parallel step, this is the second-level number of the step that spawned it. For example, if the value of StepLevl1Num is 4 and this row logs the first parallel step for step 4, this value is 04 01; if this row logs the second row generated for step 4, this value is 04 02, and so forth. If this row is not a parallel-step row, this value is 0 (zero).
StepName Abbreviation of the internal name used to identify this step (for example, DEL for a DELETE step).
StepStartDate Timestamp when the step was sent to the AMP.
StepStopDate Timestamp when the step returned from the AMP.
RowCount Number of rows returned by this step (indicating the activity count).

DBQLSummaryTbl

DBC.DBQLSummaryTbl holds the counts logged for queries of users with

SUMMARY or THRESHOLD rules.

Rows Generated by the THRESHOLD Option

THRESHOLD counts queries with an elapsed time less than or equal to the

given limit and reports queries that do not meet that criterion. DBQL behavior

resulting from the THRESHOLD option is:

For each session being logged, DBQL:

Each time a query completes within the threshold time, increments the counters for the session

Every 10 minutes, writes the cumulative count for each session as a separate row in DBQLSummaryTbl

For any query that exceeds the threshold time, DBQL generates a default row in DBQLogTbl

Rows Generated by the SUMMARY Option
Previous << 1 .. 160 161 162 163 164 165 < 166 > 167 168 169 170 171 172 .. 218 >> Next