0 - 35 of 35 tags for dbql

I'm using the TD14.10 VM and I'm trying to do some analysis on the DBQL object log.  I've turned on the logging but the object table doesn't get populated, even when you flush or end logging on the user.  All the other DBQL tables get populated as expected.  Is the object logging disabled and if so can it be enabled?

Hi guys,
The Viewpoint of my inviroment is very slow and I want find another way to monitoring when this kind of problem occurs.
How can I create something like the portlet of "Query monitor" of viewpoint throught DBQL tables or anything else ?
Is there possible ? 

This session will discuss Application Query Tuning on the Teradata platform. 

Are any conversion scripts needed for upgrading from TD 14.00 to 14.10?
DevX appears to show a single set of scripts for all of 14.xx, suggesting none needed; so looking for confirmation that no changes would be needed for our existing DBQL scripts.

Have you ever wished for a magic wand that could quickly point out the missing, stale, and unused statistics for you?

This presentation reviews the benefits of collecting performance data on the Teradata platform.

Hi all,
We're looking at reporting on CPU usage and trying to understand the difference between the CPU metrics in each table. We have PDCR to archive the acctg table in hourly and daily blocks.

One query was aborted by the system dba from viewpoint. I could take out the record from dbqllogtbl_hst and that shows that it was aborted. Now, i want to know which was the user/IP of the machine from which this was aborted. Can someone help me how to take out this info ?
Thanks !

Hi all. We use PDCR to archive our DBQL tables - the primary index on the tables is (logdate,procid,queryid) and they are partitioned by logdate.

Hi all. I have a requirement to generate reports based on our operating windows via DBQL. As the operating windows are subject to change, I would like to use the OpEnvName field that is populated via the PDCR process.

Is there a field in DBQL that returns the name of the script in which a command is executed?

Hello Everyone,


I have read that DBQL and ResUsageS tables, views and macros are important for system capacity planning. For example ResUsageSpma and ResNode. But what about the other tables and views.

Are they also monitored for capacity planning ? 


The DBQL setup and maintenance documents provides scripts, as well as information on how to perform DBQL logging, maintenance, and upgrade, now including Teradata 14.0.

Hi, I have put together a dashboard showing all the AMPCPUTime consumed by our various workloads based on the data from the DBQL LOG table column, AMPCPUTime. I want to add the Idle time into this so that management get an accurate picture of what is going on the system.

Hi All,
Recently one of our fastload job got failed with the error "no more room in databae" but it was found that  there is no entry in the dbql tables for the above failure. After adding space, the workflow was failed with the error "object does not exist" and its recorded in dbql.
what might be the reason for this..........

Is there any way to measure the total AMPCPUTIME consumed by any MLOAD/FLOAD/FEXP job post completion? The values from the dbql(sum of ampcputime for a particular LSN number) does not seem right.
I also tried dbc.acctg. There too, the values seem low.

Have you ever struggled over whether, or how, to use a new database feature?  In this presentation, we’ll demonstrate how database query log (DBQL) data can help when it comes to determining candidates for MLPPI (Multi-Level Partitioned Primary Index) as well as the new Columnar Partitioning feature of Teradata 14.

I am considering the impementation of algorithmic compression within our 13.10 system's DBQL History tables. We have quite a long retention requirement for this data and the daily maintenance and nightly backups are starting to become an issue because of the large sizes.

If a query runs and shows following two values.
MaxAMPCPUTime = 265.968
MinAmpCPUTime = 245.072
Can one conclude that difference between these two is small i.e. ~ 20. It is less than 10% of any one of them. Hence all the AMPs are used effectively?
Can we have any other interpretation apart from this?

I have noticed in the DBQL logs that there has been a number of records in the dbqlsqltbl.SQLTEXTINFO table and column that contain the value of "SELECT ?".  It appears that this is due to a columns that is being CAST as CLOB.  My first question :  Is this expected?     The second question:  Can DBQL be modified so that these rows are not logged into the

Which document will contain explanation of fields in DBQLOGTBL?
Some of the fields of interest are as follows.
EstMaxRowCount, NumSteps, StatementType, WDID, LSN Integer, SLGMet etc.



In release 13.10, is it possible that ProcID and QueryID exists in QryLogObjects but not in QryLog?

In my client site, I found this issue happened. As a result, I'm not able to get column access by user for some mismatch ProcID and QueryID.  We have turned on DBQL logging with object.

Hi ,
The field typeofuse of the table dbc.dbqlobjtbl according to the manual (TD14) has the following values:

1 = Found in the resolver

• 2 = Accessed during query processing

• 4 = Found in a conditional context

• 8 = Found in inner join condition

• 16 = Found in outer join condition

Starting in Teradata 13.10, there is a single delay queue for all throttles.  This means that queries delayed by system throttles will reside in the same queue as queries delayed by workload throttles.  In earlier releases, delay queues were set up independently by type of throttle, and each workload throttle had its own dedicated queue.   

Bringing together all delayed objects into a single queue streamlines the entire throttling experience and makes it easier and more accurate to manage internally.  However, as a side-effect, the DelayTime field in DBQL needs a second look.  DelayTime takes requires slightly different interpretation in 13.10 than you gave it in earlier releases.

One of the more difficult challenges in database management and administration is determining where and how to implement a new RDBMS feature or function. In this presentation we’ll look at the DBQL data available for evaluation of tables and columns used within a workload and how this data can be leveraged for determining candidates for MLPPI (Multi-Level Partitioned Primary Index).

Hi All,

Is there a way to track users who access a particular database in the data warehouse? Would this be done thru the DBQL? Are there any "standard" sql reports that exist for this kind of reporting? This is needed for security reporting requirments.



This presentation will provide recommendations and guidelines for using leading practices to enable system and performance tuning.  You will learn the benefits of using Teradata's most recent set of recommendations to manage workloads on a Teradata system. For example, by using Teradata's data collection guidelines, recommendations for Account Management and Logging, a user will be able to identify, analyze and tune problem queries for better performance. This presentation will also focus on how to use the tools provided in the Teradata Analyst Pak. 

My batch is completing late, the tactical queries show inconsistent response times, some applications show extreme variability in resource consumption, the canaries are hoarse!
Bad queries need to be fixed! We will explain why certain queries are bad and visualize how they impact Teradata performance. We will show how to find them, discuss most common mistakes, and give tips on how to fix them. Techniques to measure 'incoming traffic' from highly volatile applications will be discussed.

According to my understanding, the value returned by subtracting StartTime from FirstRespTime should be equal to AMPCpuTime. But this doesnt seem to work. Can anyone please help me understand how are all these values related/calculated?