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:

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:

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
Customer can use client side solution to specify members for the initial connection by enabling enableAlternateServerListFirstConnect and providing serverlist.

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