Skip to Main Content
IBM Z Software


This portal is to open public enhancement requests against IBM Z Software products. 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
  1. Post an idea.

  2. Get feedback from the IBM team and other customers to refine your idea.

  3. Follow the idea through the IBM Ideas process.


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.

Status Not under consideration
Categories Runtime
Created by Guest
Created on Apr 15, 2025

override the userid and password in the XA_OPEN string of a TXSeries region

 

TXSeries region does connect to the database using the user specified in the XAD.stanza when the cicsas comes up that  same user will be used by application programs throughout that process for all DB related queries. 

For security requirement need to invoke invoke SQL commands by using the userid logged onto cics region  in order DB2 uses authorization IDs to provide authorization checking of SQL statements. 

On Once the XA_OPEN is done to the DB2 database can a different userid be used when processing the SQL functions for the database?  Which essentially means each user logging onto the cics region would do their own XA_OPEN to the database or  override user specified on XA_OPEN . 

In that way  txseries region   will be  work similar of z/OS environment 

thanks  

Anna 

 

Idea priority High
  • Admin
    ANUBHUTI KAUSHIK
    Jul 11, 2025

    Hi,

    Thank you for raising this idea. Currently, task initiation user exit does not work for DB2 for z/OS. After a thorough evaludation, we have decided not to pursue this request. As a result, we are closing this request at this time.

    We appreciate your input and continued support.

    Thank you.

  • Guest
    May 7, 2025

    Thanks I've seen what  has been done for TXS-I-129  where you implemented Task Initiation user exit to support transaction user propagation to DB2. The task initiation user exit will be invoked for every user transaction just before starting the transaction. 
    Task initiation user exit can be used to configure DB2 trusted connection and propagate transaction user identity to DB2. 
    Refer /opt/ibm/cics/samples/userexit/ cicstrusted.README to configure user exit for DB2 identity propagation.

    In our  case we are working with  a database server that it is a  DB2 for z/OS 

    Does above Task Initiation user exit work to DB2 for z/OS ? 

    thanks  Anna 

     

  • Guest
    Apr 15, 2025

    The support of the transmission of userid  from TXSeries to DB2 is like  of the feature on  CICS TS   AUTHTYPE(USERID) both in DB2CONN and DB2ENTRY. I've seen this kind  of  request has been delivered  for TXS-I-129 .   Please could  you show me in with way ?    thanks  Anna