By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,021 Members | 912 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,021 IT Pros & Developers. It's quick & easy.

DB2GOV and DB2QP

P: n/a
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

Oct 17 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.