Claus_Jambrich_5663

How to set Client information when running an SQL job

Discussion created by Claus_Jambrich_5663 on Oct 6, 2016
Latest reply on Nov 8, 2016 by Claus_Jambrich_5663
Is it possible to set the Client information string for a DB2 job, when running a UC4 SQL job? Is it maybe possible to set it in a connection object, under additional parameters or in the SQL job itself?

The aim is to see in DB2 where the a particular connection/statement is originated from.

UC4 calls return the default value (DB2JCC_APPLICATION) - this value should be changed.

The ApplicationName value can be retrieved with below query:

 

SELECT CURRENT CLIENT_APPLNAME from sysibm.sysdummy1;


Outcomes