1

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?

  • 1
    Are you sure your client does indeed set these properties? Did you try setting them with some other client program, e.g. Data Studio? – mustaccio Jun 4 '15 at 14:10
  • No, I'm not sure of that. It might be the case that Squirrel ignores them. My next step where to create a small standalone java app, but I'll try with Data Studio first. Thanx for the idea. – Lennart Jun 4 '15 at 14:45
  • It appears to be working with Data Studio (the driver that is shipped with that). I'll try that driver together with Squirrel next week and see if db2jcc is what is causing this. – Lennart Jun 4 '15 at 16:29
  • I removed my answer since it no longer works with the jcc4 driver in Squirrel (not sure if it ever did, could be connection from DataStudio). I'll try DataStudio with the jcc driver and see if I get that to work. – Lennart Jun 5 '15 at 7:41
  • DataStudio works with both db2jcc and db2jcc4 so it appears as if there is something wrong with the way Squirrell handles additional properties for the driver. – Lennart Jun 5 '15 at 8:22
1

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/

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.