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.

Add a new idea Subscribe
Status Not under consideration
Workspace IMS Database Manager
Categories General DB
Created by Guest
Created on Feb 13, 2019

RELATED IDEAS

Enhance the IMS SQL batch utility and the IMS DDL generation batch utility

At the moment the only way to execute DDL statements on z/OS is to run the IMS SQL Batch Utility. This utility is using the IMS Universal JDBC Driver to connect to IMS Connect and executes the DDL statements through ODBM. This forces you to setup IMS Connect and ODBM to be able to execute DDL Statements in the case you haven't already setup both.

For being able to connect with IMS Connect you need to specify a RACF user ID and a password in clear text within the connecting URL the JDBC driver uses, which isn't acceptable in production environments. Instead of RACF user ID and password RACF PassTickets can be used, but enabling PassTicket support in IMS Connect may have negative implications on existing IMS Connect applications.

If the SQL Batch Utility could be executed in a JBP region neither a setup of IMS Connect and ODBM would be necessary nor a RACF user ID and password respectively a RACF PassTicket needs to be provided.

The same problems applies to the DDL Generation Batch Utility, which allows you create DDL statements from either IMS Catalog metadata or DBD and PSB sources, in the case you decide to use the IMS Catalog as the metadata source for this utility.

In general such important utilities should be better native utilities like the other Catalog utilities to make their adoption as easy as possible.

Idea priority High
  • Guest
    Reply
    |     Mar 19, 2019

    Hi Robert,
    Thank you for your interest in keeping IMS a vital and successful product. Software development has continuously evolved during IMS's lifetime, and so has IMS itself. We have kept pace with, adopted, and implemented many industry standard best practices within our organization, including Continuous Delivery, Design Thinking, and Agile.

    When choosing new features to add from the list of requirements in our backlog, we assess which will bring the most value to as many clients as possible and prioritize those.

    At this time, after reviewing this request for enhancement and assessing its potential value, we have decided to reject it. We think it’s a great idea but we are rejecting RFE 129933 for the following reasons:
    1) The enhancement is a DDL related enhancement and right now our focus is on IMS Managed ACBs.
    2) We will not be able to get to this enhancement within 18-24 months which is the goal we have set for RFE deliverables as part of our IMS Gold program.

    We have put this enhancement on our future roadmap for DDL.
    You are welcome to resubmit this RFE at a later date if you like but we have noted it for our futures roadmap.

    We appreciate your input to IMS, and we hope that you will continue to submit ideas for improvements as customer feedback is a key component to shaping the future direction of IMS.
    Thank you.
    Sincerely,
    Deepak Kohli - deepakk@us.ibm.com

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.