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,
Post an idea
Upvote ideas that matter most to you
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
Available now in 4.50.xC4W1
Small correction, As the changes are available, please contact Karen/Shelly to get pre-build of the changes.
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).
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).
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
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