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 Db2 for z/OS
Created by Guest
Created on Sep 10, 2019

Allow Client Information to be propagated from a Db2 REST call

In a multi-tenant environment it is of great importance to be able to quickly isolate a problem in order to resolve a problem. We are currently using the Db2 JDBC Client Information API to provide Db2 with various correlation data from our Java based applications such that it will show up in different messages, traces and accounting information so that we could relate a transaction to not only a technical user but also to the real end user (authenticated by an LDAP catalog) as well as to where in the code we had the problem. We are also providing a reference to a correlation identity generated in the user's device so that we can correlate logs from all tiers of the application all the way down to Db2 for z/OS. Our implementation is based on design rules effectively managed by framework code.

 

When introducing the valuable Db2 REST feature in Db2 for z/OS, the implementation itself populates four of the client information special registers with Db2 related, and relevant information. A fifth special register is populated with the information in the User-Agent HTTP header. Furthermore the client's ip address is put into a global variable. The problem for us is that this is basically Db2 related downstream information that does not really refer to what is happening upstream in the calling stack of tiers in which Db2 more or less is in the bottom, at least far down.

 

Hence, the current implementation is basically fixed. The only way  we can influence the content is to let a REST call modify the User-Agent HTTP header with our own information. This is not acceptable to us. If we cannot have more control over the client information for a Db2 REST call as we have for our Java JDBC calls to provide similar correlation information we will have difficulties in correlating activities in all tiers. This in turn will have a negative impact on problem isolation, determination as well as resolution that will be hard to accept by our line-of-business.

Needed by Date Dec 25, 2019
  • Guest
    Reply
    |
    May 24, 2020

    Hi, The Aha! idea will be delivered by APAR/PTF PH24619/UI69646. The PTF UI69646 has been created and should CORCLOSE and be orderable within the next two weeks. Thanks!

  • Guest
    Reply
    |
    May 22, 2020

    How was this shipped? When was it shipped?