Skip to Main Content
IBM Data Platform Ideas Portal for Customers


This portal is to open public enhancement requests against products and services offered by the IBM Data Platform 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 Submitted
Workspace Db2 for z/OS
Created by Guest
Created on Oct 24, 2026

ID Propagation Improvement

Hi, this is about id propagation as described in RedBook SG24-7850-00. I prepared a test by using IBMUSER as the primary connection user and a switched remote user CN=lisa,DC=test,DC=com, who I think was supposed to appear as CURRENT CLIENT_USERID special registry, instead of the connection userid IBMUSER.

I know the remote user will appear in some SMF reports, but it is important to have the information available to the applications (they can use triggers to track who did updates). So, after a lot of work and thanks to IBM support I managed to change the DSN3SATH exit to provide user defined session variables with external user info from IDID control block. Here you have 2 results from the Java code I attached (DC=test… is mapped to user MAPUSER1):

FIRSTNME: CHRISTINE
CLI_U_VC255: IBMUSER (should be CN=lisa,DC=test,DC=com?)
SQLID_VC128: MAPUSER1
SESS_USR_VC128: MAPUSER1
USER_VC128: MAPUSER1
SCH_VC128: MAPUSER1
EXIT_USER: CN=lisa,DC=test,DC=com
EXIT_REG: localRegistry

FIRSTNME: CHRISTINE
CLI_U_VC255: IBMUSER
SQLID_VC128: MAPUSER1
SESS_USR_VC128: MAPUSER1
USER_VC128: MAPUSER1
SCH_VC128: SAMPALL
EXIT_USER: CN=lisa,DC=test,DC=com
EXIT_REG: localRegistry

The 2 results differ by using  WITH ROLE AS OBJECT OWNER AND QUALIFIER when defining the trusted context.

Since CURRENT CLIENT_USERID is updatable by the application, this is not an ideal solution. Moreover, the userid itself not necessarily is an unique identifier, in some cases we need the Realm Name too.

Proposal

1) To have 2 new built in session variables CLIENT_USERID/CLIENT_REG (whatever other names) containing the remote user info.

2) As I said before, I created a solution by changing DSN3SATH to create the above mentioned variables as user-defined session variables, so IBM can insert my modifications (marked as <TITO>) as commented (optional) code in future provided DSN3SATH sample, as an alternative solution.

Java test code and DSN3SATH.asm attached.

Changes:

New version of DSN3SATH, modifications marked as <IDPR>, CLIENT_REG variable changed to CLIENT_REGISTRY.

Needed By Not sure -- Just thought it was cool
  • Guest
    Nov 3, 2026

    New java example: