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 Delivered
Workspace z/OS Connect
Created by Guest
Created on May 22, 2018

Pass Application credentials when using z/OS Connect for DB2

As part of a PoC on z/OS Connect specifically calling to DB2, it was found that the application credentials are not being passed all the way through to DB2. Over the last several years we have changed our Security model with things like DB2 Stored Procedures, so that only very specific application IDs are allowed to call them, especially when they involve access to PI type data. Without the application credentials being passed through on an application by application basis, that level of validation is no possible. That's considered a show stopper for us, we won't open up access and take a step backwards on our Security model for DB2.

Idea priority Urgent
  • Guest
    Reply
    |
    Dec 17, 2018

    This requirement is addressed by z/OS Connect Enterprise Edition V3.0.15 / APAR PH04447:
    https://www-01.ibm.com/support/docview.wss?crawler=1&uid=swg1PH04447

    This requirement is satisfied by identity propagation over REST to Db2 using RACF PassTickets. z/OS Connect EE generates a PassTicket for the specific user ID and target Db2 subsystem, which is then passed in the HTTP Authorization header to Db2 where it is validated.

    For further details about identity propagation over REST to Db2 using RACF PassTickets, refer to the “Configuring PassTicket support for Db2 RESTful services” topic in the z/OS Connect EE V3.0 Knowledge Center:
    https://www.ibm.com/support/knowledgecenter/SS4SVW_3.0.0/configuring/config_rest_db2passticket.html

  • Guest
    Reply
    |
    May 25, 2018

    Thank you for this RFE.

    ID Propagation over the REST Service Provider to DB2 native REST services is not something we currently support.

    However, ID Propergation to DB2 is supported when using the IBM Data Virtualisation Manager (DVM) Service Provider to access DB2 via DVM. More information can be found in the "z/OS Connect" topic in the DVM Knowledge Center: https://www.ibm.com/support/knowledgecenter/en/SS4NKG_1.1.0/havuga10/topics/dvs_sg_con_zcon_cms_parms.html

    As an extra benefit DVM provides much more comprehensive support for DB2 data access than the DB2 native REST services provide us. It also enables you to access and combine data from multiple sources such as VSAM and IMS DB.

    If this does not meet your needs we would love to hear what you require in addition to what is provided by DVM today. If there is nothing more you require please let us know and we'll close this RFE as delivered by the solution stated above.

0 MERGED

identity propagation with z/OS Connect connecting to Db2

Merged
User needs identity propagation with z/OS Connect connecting to Db2. Current server.xml file for Db2 has the username and password hardcoded in the Db2 Connection information. User is currently using Db2 Native REST Services and can pass userid/pa...
over 5 years ago in z/OS Connect 2 Delivered