IBM Data and AI Ideas Portal for Customers


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:

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

Help IBM prioritize your ideas and requests

The IBM team may need your help to refine the ideas so they may ask for more information or feedback. The product management team will then decide if they can begin working on your idea. If they can start during the next development cycle, they will put the idea on the priority list. Each team at IBM works on a different schedule, where some ideas can be implemented right away, others may be placed on a different schedule.

Receive notification on the decision

Some ideas can be implemented at IBM, while others may not fit within the development plans for the product. In either case, the team will let you know as soon as possible. In some cases, we may be able to find alternatives for ideas which cannot be implemented in a reasonable time.

Additional Information

To view our roadmaps: http://ibm.biz/Data-and-AI-Roadmaps

Reminder: This is not the place to submit defects or support needs, please use normal support channel for these cases

IBM Employees:

The correct URL for entering your ideas is: https://hybridcloudunit-internal.ideas.aha.io


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
    Nov 23, 2020

    Available now in 4.50.xC4W1

  • Guest
    Dec 12, 2019

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

  • Guest
    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
    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
    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
    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