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 Data & AI Roadmaps (http://ibm.biz/Data-and-AI-Roadmaps) - Use this site to view roadmaps for Data & AI products.

IBM Employees should enter Ideas at https://hybridcloudunit-internal.ideas.aha.io/


Status Not under consideration
Workspace Db2
Components Serviceability
Created by Guest
Created on Mar 5, 2015

Ipaddress similar to how we have distributed dynamic vipa on z/OS

Here's the scenario
State Farm has a client server where they catalog a single node of the purescale cluster 10.5/FP5
then then connect successfully from a 10.5/FP4 client,
they then run a statement,
then kill a member,
the connection gets rerouted successfully without any client side configuration (-30108 on first retry, success on second).

If they open another session on the same server or run db2 terminate and try to connect in the same session there are two issues.

1. The connection does not get routed to another member that is up even though the ip address list was been returned via a previous successful connection. This is because the ip address list does not get persisted to disk for the CLP and possibly is the same for CLI. It should (in my opinion) be persisted. Probably an RFE??
2. This connection to the member that is done eventually returns an error message(30081) after about 5 minutes. What State Farm would expect would be a sqlcode 1224 when member is down rather than waiting for 5 minutes to get 30081
3. Does CLI behave the same way as CLP?

What they would really like is a group ipaddress similar to how we have distributed dynamic vipa on z/OS so that apps can catalog one ip address and if any member in the cluster is available they will get routed to it instead of getting an error.

State Farm Response to this URL
For DVIP:
Customer can use client side solution to specify members for the initial connection by enabling enableAlternateServerListFirstConnect and providing serverlist.
http://www-01.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.ibm.db2.luw.apdv.cli.doc/doc/c0056196.html

Sounds great but why would I want to have to do this on every client and have to update every client if I add members when IBM is using TSA for the cluster which already has the capability to have a virtual IP address for the cluster?



That's every JVM that wants to connect for java and every Linux server. You guys got anything to generate the XML for the db2dsdriver.cfg?



That doc also states



Note that if you do not define a list of alternate servers in the db2dsdriver.cfg configuration file, at the first successful connection to the server, the client obtains from the server a list of all available alternate servers. The client stores the list in memory and also creates a local cache file, srvrlst.xml that contains the server's list of alternate servers. This file is refreshed whenever a new connection is made and the server's list differs from the contents of the client srvrlst.xml file.



That is apparently not the case at least for CLP apps.


Rob Lemeuix