Driver properties for db2jcc in Squirrell and MON_GET_CONNECTION table function 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?
It appears to be a bug in the way Squirrel handles additional parameters. Data Studio acts as expected with both db2jcc and db2jcc4 drivers. I have filed a bug to:

https://sourceforge.net/p/squirrel-sql/bugs/1201/