Hi,
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?
 
Jim.

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 ? 
 

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.
Thanks,
Dan

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.

Hi,
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 ? 

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..........

Hello,
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.

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.

Hello,
 
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

Hello,
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.
 

Hi,

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

Hi,

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.

Thanks!

Paul

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?