Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
18 Cards in this Set
- Front
- Back
DBQL is used for what
|
Logging Historical query infomation.
Key use is to track SQL |
|
How is information stored
|
In cache, not released until cache is full, or end query logging is done.
|
|
Can you do live reviews of sql using DBQL.
|
Not built for that. Use PMON
|
|
How is it invoked, revoked
|
BEGIN QUERY LOGGING
END QUERY LOGGING |
|
To who is it invoked
|
by ALL users
by list of Users by List of Account Strings by User with 1 or more Account Strings |
|
What is logged by default
|
1 row per query with userid info and some stats on the query. There are options for MORE
|
|
what is rate of cache to disk
|
default is 10 minutes. DBSControl option "DBALFLUSHRATE" is used to set rate.
|
|
Can dbql track tpump?
|
Yes... TPUMP sends sql to Teradata.
|
|
What are the components of DBQL and how are they implemented
|
1 Security macro
several tables Install Dip script sets it up |
|
Where are dbql logging rules kept
|
DBC.DBQRuleTbl
|
|
What is the view for DBC.DBQLogRuleTbl
|
DBC.DBQL.LogRules
|
|
What is required for a user to start or end Query logging
|
Must have EXEC prifilege on DBC.DBQLAccessMacro
|
|
What is the KEY table in DBQL
|
DBC.DBQLogTbl
|
|
How many rows are stored here?
|
One row. Requests for more info is stored in other tables.
|
|
When won't a record be inserted into the DBQLogTbl
|
Use of Summary option
or a query finishes within a defined "THRESHOLD" |
|
what is the recommended limit of how many users?
|
100 user/account pairs per statement
|
|
Where are default rows stored
|
DBQLogTbl
|
|
Is sql stored in LogTbl
|
yes, default is 1st 200 characters.
|