|
|
|
Forum Newbie
Group: Forum Members
Last Login: 7/14/2009 2:56:57 AM
Posts: 7,
Visits: 13
|
|
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.
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 9/10/2009 6:25:29 AM
Posts: 16,
Visits: 74
|
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 7/14/2009 2:56:57 AM
Posts: 7,
Visits: 13
|
|
|
Measuring by the spoolusage column of the dbqlogtbl
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 11/5/2009 4:40:02 PM
Posts: 717,
Visits: 466
|
|
And comparing it to what?
Dieter
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 7/14/2009 2:56:57 AM
Posts: 7,
Visits: 13
|
|
|
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.
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 7/14/2009 2:56:57 AM
Posts: 7,
Visits: 13
|
|
|
can anyone help me on this please?
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 11/5/2009 4:40:02 PM
Posts: 717,
Visits: 466
|
|
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
|
|
|
|