I'm trying to set driver properties like:
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?