Sample Header Ad - 728x90

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