DBQL Query !!!

Tools & Utilities
Enthusiast

DBQL Query !!!

I am new to DBQL.
DBA's has already enabled DBQL and i want to check the CPU Time of my batch job.i Know that i can query DBQLogtable but it is asking Procid and queryid. i guess i can able to get Procid from my Unix Box but not sure about the query Id ? can anybody tell me how to find the query Id ?

Regards
Abhijit
3 REPLIES
Enthusiast

Re: DBQL Query !!!

Have you tried this?

Select *
from dbc.qrylog
where username = 'xxx'
and cast(starttime as date) = date;

If you run this query with your username, it should show you all of the queries that you ran for the day. You shouldn't need the QueryID or procID to find the log row for your query.

Enthusiast

Re: DBQL Query !!!

Thanks Berry

That worked but i am curious if at all i need to find out the queryid how am i going to find it ?

Regards
Abhijit
Enthusiast

Re: DBQL Query !!!

That's the way that I would normally find it. There may be another way, but I'm not aware of it.