If a SQL / Session is aborted then the DBQLogTbl doesnt capture the actual CPU consumed by the request before it was aborted.
If I want to find out the CPU of aborted sessions, is there a place i can quey and get that information ?
DBQL holds CPU consumption of the queryid upto the step prior to when the query was aborted. You have to use monitorsession APIs that capture CPU usage at a 10 minute interval to arrive at lost CPU numbers.
Since TD14.10 there's a new algorithm (DBQLogTbl.DataCollectAlg = 3) which includes data for aborted steps.
But it must be enabled explicitly (either using dbscontrol or using BEGIN QUERY LOGGING).
And information about MonitorSession and other Performance Monitor functions is found in the "Application Programming Reference" manual.