DBQL - Database Query Logging

Database
Enthusiast

DBQL - Database Query Logging

Hi All,

I am using DBQL for some analysis work on TD12.0 Express Edition Demo version,
But have a space issue with the DBC database.

Please can anyone advise if i can change the DBQL setting so that it will refer to my personal
database in which i have created the replica of DBQL tables.?

One way is to do a backup of the DBC - DBQL tables everyday in my personal database.
and then delete the data from dbc - dbql tables.

I need to directly log the information which goes into dbql tables into my personal database
so their is no space crunch.

Please advise.

Rgds,
mtlrsk.
3 REPLIES
Teradata Employee

Re: DBQL - Database Query Logging

Hello,

I seriously doubt, if it possible to change the DBQL tables. But offcourse, you need to implement some sort of archiving strategy for DBQL tables as per business requirements, otherwise some point in time they will eat-up the space easily.

Also, if you get space issue often, better to think of requirements against the logging level. You surely don't need to log everything at each point in time.

HTH.

Regards,

Adeel
Enthusiast

Re: DBQL - Database Query Logging


Thanks Adeel, ya it has helped me .

But I just doubt then how DBQL help developer to do some analysis on the queries they fire.
As they need access to DBC tables/views which only DBA's have.?

rgds,

mtlrsk...
Teradata Employee

Re: DBQL - Database Query Logging

I couldn't understand your question completely, but what I did has the following answer:

Following are the possible ways of getting the access to DBQL tables:

- Any user can be "granted" a SELECT access to DBC tables/views/macros/etc
- Views may be created by DBAs in some other database, with "SELECT WITH GRANT OPTION" access rights

Regards,

Adeel