Skip to Main Content
IBM Data and AI Ideas Portal for Customers


This portal is to open public enhancement requests against products and services offered by the IBM Data & AI organization. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (https://ideas.ibm.com).


Shape the future of IBM!

We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:


Search existing ideas

Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updates on them if they matter to you. If you can't find what you are looking for,


Post your ideas

Post ideas and requests to enhance a product or service. Take a look at ideas others have posted and upvote them if they matter to you,

  1. Post an idea

  2. Upvote ideas that matter most to you

  3. Get feedback from the IBM team to refine your idea


Specific links you will want to bookmark for future use

Welcome to the IBM Ideas Portal (https://www.ibm.com/ideas) - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal (https://ideas.ibm.com) - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM.

ideasibm@us.ibm.com - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.

IBM Employees should enter Ideas at https://ideas.ibm.com


Status Delivered
Workspace Informix
Created by Guest
Created on Nov 20, 2019

Add CLIENT_LABEL parameter for setnet32 (ODBC) connections

Hi,

We have noticed there is no parameter value we can set for CLIENT_LABEL through setnet32 driver.

To debug or diagnose particular user session easily, we would request to add this 'CLIENT_LABEL' parameter into setnet32. One other thing we would like to be known:  Is there a way to pass User login as a parameter value through this CLIENT_LABEL parameter as we use a common user to connect into the database from the client application side or Windows end?

Hard coded value would not be helpful to distinguish each individual user session.

Please , Think about having a dynamic  value when implementing this as a new feature request?

Thanks

  • Admin
    Karen Qualley
    Reply
    |
    Nov 23, 2020

    Available now in 4.50.xC4W1

  • Guest
    Reply
    |
    Dec 12, 2019

    Small correction, As the changes are available, please contact Karen/Shelly to get pre-build of the changes.

  • Guest
    Reply
    |
    Dec 11, 2019

    The changes for setnet32 and ODBC Driver are available. Please contact technical support team to get the CSDK with changes. You can ask for idsdb00104829 (setnet32) and idsdb00104812 (ODBC).

  • Guest
    Reply
    |
    Nov 26, 2019

    Thanks for suggesting the way to capture sessions using --> onstat -g env all | egrep "session|CLIENT_LABEL" Nick. In a busy system , this command has given us all the sessions without CLIENT_LABEL set also. Where as querying 'sysenvses' table with the exact label name  gives us only the relevent sessions to be investigated on. Further, The output of onstat -g env all | egrep "session|CLIENT_LABEL" contains several pages and there could be a chance to misses some session entries with it easily. My view would be to have only the filtered required session list only on the intended onstat command. The suggested way we can use as a workaround till we have new onstat command (or arguments).

  • Guest
    Reply
    |
    Nov 22, 2019

    Hi,

    While CSDK setnet32 is primarily about setting environment variable only, and CLIENT_LABEL could be added in supported variable list. Until then the workaround suggested by Nicholas Geib could be used.

     

    However, does exact requirement says about ability to provide CLIENT_LABLE value as "database connection string option", similar to what JDBC driver supports today i.e.  "jdbc:informix-sqli://myhost:52220:user=myuser;password=mypasswd;CLIENT_LABEL=jdbc_client1" ?

     

    Which component (one or more) of CSDK i.e. ODBC, .NET, ESQL/C and OLEDB we are looking to have CLIENT_LABEL supported as "connection string" option?

     

    Thanks

  • Guest
    Reply
    |
    Nov 21, 2019

    Until setnet32 supports this here is a work-around.  CLIENT_LABEL can be used via the SET ENVIRONMENT statement.  E.g.

        set environment CLIENT_LABEL "my favorite application".

    Our documentation will be updated to include this.

     

    > One other requirement with this would be,  to identify associated sessions by providing a given CLIENT_LABEL using an onstat option. This way even for non-teachnical user can be easily identified all the sessions associated with a given CLIENT_LABEL without need to be executed 'dbaccess' database query using 'sysenvses' table.

    Please consider this: 

    $ onstat -g env all | egrep "session|CLIENT_LABEL"
    Environment for session 2739:
    CLIENT_LABEL another label
    Environment for session 2706:
    CLIENT_LABEL my favorite application