Set APPLICATION_NAME and CLIENT_APPLNAME property on QMF tool level to easily identify QMF tool database connection

I have downloaded fresh new version of QMF for Workstation v13.1 on Windows 10. This issue is also present in previous versions, so not a regression on latest version.

1. Start QMF tool.

2. Connect to any Db2 database. I have connected to Db2 v11.5.8.0 on Linux/x86-64.

3. Execute SQL:

SELECT APPLICATION_NAME, CLIENT_APPLNAME FROM TABLE(MON_GET_CONNECTION(SYSPROC.MON_GET_APPLICATION_HANDLE(), -2))

This SQL returns current application name and client application name that is set by application tool. Because in SQL there is MON_GET_APPLICATION_HANDLE it means it will display the strings passed to database by QMF product.

The result is:

APPLICATION_NAME: db2jcc_application 
CLIENT_APPLNAME: <NULL>

Both of this data are set by application to identify itself to the database. I see QMF tool just leaves some defaults settings which are non descriptive.

I am a database administrator and I need to know what application tool is accessing a database, so I can easily spot the potential problems, like coworkers executing some performance demanding SQL from the QMF tool.

I have checked other database tools also used in our company and I see for example DataGrip tool is using:

APPLICATION_NAME: DataGrip 
CLIENT_APPLNAME: DataGrip 2022.2.4

If we follow DataGrip tool logic then for QMF it should be:

APPLICATION_NAME: QMF for Workstation
CLIENT_APPLNAME: QMF for Workstation v13.1

In APPLICATION_NAME field just application name without version should be displayed. In CLIENT_APPLNAME also additionally version number should be displayed.

ADDITIONALLY

Additionally, for example DBeaver in CLIENT_APPLNAME also displays info for each of the components that are separately connected to database. There is "Main" when connection is established. Then "Metadata" for separate connection DBeaver is masking for metadata e.g. clicking on database | table | columns and column names and data types are displayed. The last one is "SQL Editor" with file name for each of SQL tabs SQL is executed and DBeaver establishes separate connection to database.

For example "CLIENT _APPLNAME" for DBeaver are:

DBeaver 22.3.0 - Main
DBeaver 22.3.0 - Metadata
DBeaver 22.3.0 - SQLEditor myfile1.sql

If QMF has components that separately connects to database, it would be nice to have additional info in CLIENT_APPLNAME like "Main", "Metadata". This is just additionally not my main complaint.

WORDS BY IBM SUPPORT

I have opened case for this issue and one of the idea from IBM support is to set individual connection parameter string. It works, but I need to set this for every database connection and for every coworker. We have more then 50 Db2 databases and plenty of coworkers using QMF. My suggestion is to set those two settiongs on QMF tool application level like other tools do: DataGrip, DBeaver, SQL Workbench/J etc.