IBM Power Ideas Portal


This portal is to open public enhancement requests against IBM Power Systems products, including IBM i. 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.

Add a new idea Subscribe
Status Under review
Workspace IBM i
Categories Core OS
Created by Guest
Created on Jul 18, 2024

RELATED IDEAS

Add an attribute to *SRVPGM object types for SQL Global Variables

Currently, there is no extended attribute associated with SQL Global Variables for *SRVPGM object types.  This poses a major challenge for change management software that utilize security templates to apply permissions and authorization lists to objects based on their type.  Most *SRVPGM objects when deployed to a production environment only require *USE authority.  However, SQL Global Variables require *CHANGE authority to *SRVPGM objects.  Without an extended attribute associated with *SRVPGM object types for SQL Global Variables, it seems impossible to use change management software to apply a different authorization list to the object.  Would it be possible to add an attribute such as "SQLVAR" or "GBLVAR" or something like that so that change management software security templates know what authorization list or permissions to apply to global variable service program object types?

Idea priority Urgent
  • Guest
    Reply
    |     Oct 15, 2024

    Column SQL_OBJ_TYPE in QSYS2.OBJECT_STATISTICS table function already returns "VARIABLE" for SQL global variable service program objects. So the functionality is already there - but the change management software needs to take this into account.

    Christian, CEAC member

  • Admin
    Carmelita Ruvalcaba Cevallos
    Reply
    |     Jul 23, 2024

    The CAAC has reviewed this IBM Idea and recommends that IBM not implement this request.
    This should be handled at the change management vendor level

    Background: The COMMON Americas Advisory Council (CAAC) members have a broad range of experience in working with small and medium-sized IBM i customers. CAAC has a key role in working with IBM i development to help assess the value and impact of individual IBM Ideas on the broader IBM i community and has therefore reviewed your Idea.

    For more information about CAAC, see www.common.org/caac

    Carmelita Ruvalcaba - CAAC Program Manager

By clicking the "Post Comment" or "Submit Idea" button, you are agreeing to the IBM Ideas Portal Terms of Use.
Do not place IBM confidential, company confidential, or personal information into any field.