Driver properties for db2jcc in Squirrell and MON_GET_CONNECTION table function
1
vote
1
answer
417
views
I'm trying to set driver properties like:
* clientAccountingInformation
* clientApplicationInformation
* clientProgramId
* clientProgramName
in Squirrell 3.6 (http://squirrel-sql.sourceforge.net/) . See https://www-01.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.apdv.java.doc/src/tpc/imjcc_r0052607.html for a more detailed description of these properties.
I was under the impression that it should be possible to inspect these values with for example:
select APPLICATION_HANDLE, APPLICATION_NAME, APPLICATION_ID
, CLIENT_WRKSTNNAME, CLIENT_ACCTNG, CLIENT_USERID
, CLIENT_APPLNAME
from table(MON_GET_CONNECTION(cast(NULL as bigint), -2))
but no matter what values I use, I get null back from the query.
The db cfg regarding metrics are:
Request metrics (MON_REQ_METRICS) = BASE
Activity metrics (MON_ACT_METRICS) = BASE
Object metrics (MON_OBJ_METRICS) = BASE
Unit of work events (MON_UOW_DATA) = BASE
Lock timeout events (MON_LOCKTIMEOUT) = HISTORY
Deadlock events (MON_DEADLOCK) = HISTORY
Lock wait events (MON_LOCKWAIT) = HISTORY
Thoughts anyone, what am I missing?
Asked by Lennart - Slava Ukraini
(23862 rep)
Jun 4, 2015, 11:37 AM
Last activity: Jun 8, 2015, 07:22 AM
Last activity: Jun 8, 2015, 07:22 AM