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 Future consideration
Workspace Db2 for z/OS
Created by Guest
Created on Apr 1, 2022

Expand the scope of TRANSFER OWNERSHIP DDL

The TRANSFER OWNERSHIP DDL should also be applied to stored procedures, triggers, functions, constraints, global variables, sequences, etc.

Needed By Quarter
  • Admin
    Janet Figone
    Reply
    |
    Sep 25, 2023

    Dear Thomas, Thank you for providing the additional information. The Db2 for z/OS development team re-reviewed this idea and has decided to change the state from Not under Consideration to Future consideration state. We will be revisiting this idea in the future.

    Sincerely,

    The Db2 for z/OS team

  • Guest
    Reply
    |
    Aug 29, 2023

    Ownership plays a very import part in a secure DB2 environment and having the possibility to change/correct object ownership is a must accross all object types in DB2. Therefore please reconsider this as an very import fix to be delivered to keep DB2 as the leading secure RDBMs

  • Guest
    Reply
    |
    Aug 29, 2023

    During our migration from DB2 natiive to RACF security, we have encountered a major issue related to storep procedures and functions being owned by the IDs which are not in RACF anymore. For instance some past, 20 years long gone ex DBA, changed standard in group naming convention, you name it.

    Since after such migration, if the SP or F owner does not exist in RACF, RACF will immediatelly reject any attemp to invoke such object making it unusable. Because transfer ownership does not woprk for such objects it becomes major task to drop/recreate all the related objects. IN our case it is also a lot of objects which are depending on each other making it even more complex.

    The transfer ownership implementation of all obejcts, especially stored procs and functions, sequnces and troggers should be prioritized and not put away in time, especially in the era of the pressure on secure and safe DB2 environment protected by RACF.

  • Admin
    Janet Figone
    Reply
    |
    Jan 13, 2023

    Dear Thomas, Thank you for submitting this enhancement request. The Db2 for z/OS team reviewed it and believe it is a good idea, however, it does not align with functionality prioritized for the upcoming 12 months.

    We have marked this idea as Not under consideration, and also to re-review it in 2023.

    We appreciate your input to the Db2 for z/OS development team. And we hope that you will continue to submit enhancement suggestions for improvements as customer feedback is a key component to shaping the future direction of Db2 for z/OS.

    Sincerely,

    Db2 for z/OS Team

    1 reply
1 MERGED

Specify OWNER for External Stored Procedures

Merged
We use a CI/CD pipeline to create external stored procedures in all test environments and production. The pipeline use a single userID to create all objects, a user with as low privileges as possible and absolutely not SYSADM. When creating plans,...
about 1 year ago in Db2 for z/OS 4 Future consideration
11 MERGED

TRANSFER OWNERSHIP for SEQUENCE objects

Merged
The sequences are DB2 objects but normally are related to a specific application so also the ownership of these objects should be related to the owner of the application itself to be compliant the te security business rule.
almost 7 years ago in Db2 for z/OS 1 Future consideration