DBQLOGTBL SPOOL USAGE NOT CORRECT IN TD12

Database
Enthusiast

DBQLOGTBL SPOOL USAGE NOT CORRECT IN TD12

THE SPOOLUSAGE FOUND IN DBQLOGTBL FOR A QUERY IS NOT CORRECT. IT DIFFERS A LOT FROM THE ACTUAL SPOOL USAGE
OF A QUERY.

Let me know any other way to extract accurate spool information after query execution.
6 REPLIES
Enthusiast

Re: DBQLOGTBL SPOOL USAGE NOT CORRECT IN TD12

How are you measuring?
Enthusiast

Re: DBQLOGTBL SPOOL USAGE NOT CORRECT IN TD12

Measuring by the spoolusage column of the dbqlogtbl
Junior Contributor

Re: DBQLOGTBL SPOOL USAGE NOT CORRECT IN TD12

And comparing it to what?

Dieter
Enthusiast

Re: DBQLOGTBL SPOOL USAGE NOT CORRECT IN TD12

I look for the maximum of current spool with pmon during query execution and compare it with dbqllogtbl spool usage column value after query execution.
Enthusiast

Re: DBQLOGTBL SPOOL USAGE NOT CORRECT IN TD12

can anyone help me on this please?
Junior Contributor

Re: DBQLOGTBL SPOOL USAGE NOT CORRECT IN TD12

Is the PMon values less or greater than DBQL?
Are you shure you presses the refresh button in PMon the right time?
Could you post some numbers?

If this repeats for certain types of queries you should open an incident.

Dieter