DB2GOV and DB2QP

[bala_e]

Hi,

We are using db2 udb 8.1 FP 9 in AIX environment. Also we have DB2QP
and DB2 Gov. We are facing the problem like the entries in DB2 GOV
does not matching DB2QP. Example, we killed one query due to some
reasons. If we issue the following command,

db2govlg NORMGOVlog rectype FORCE|grep -i ET

the output of the above command is,

2007-10-16-12.53.15 13 FORCE applname `aspnet_wp.exe` authid `OBIPUSR`
applid `M924344E.E30C.013F46152317` coord 0 (line 34) ET 5406

But for this aborted entry we don't find the logs in QP.

SELECT *
FROM DB2QP.TRACK_QUERY_INFO
WHERE COMPLETION_STATUS = 'A'
AND STMT_AUTH_ID = 'OBIPUSR'
;

Seems there is a leak between DB2 GOV and DB2QP.

Anyone has any idea? Kindly help us.

Thanks

Bala