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


Add a new idea Subscribe
Status Functionality already exists
Workspace Db2 Utilities Suite for z/OS
Created by Guest
Created on Dec 27, 2021

RELATED IDEAS

DIS UTIL could show also the Db2 Object involved

DISPLAY UTIL(*) is used daily, but it doesnt't show the Object involved/affected. This info is already in SYSUTILX so it seems to be possible to obtain it directly with the command Display.

Currently, the DBA, Operator or Developer has to deal to get that main info.

Thanks in advance; hope you find the way to solve it.

Needed By Not sure -- Just thought it was cool
  • Admin
    Janet Figone
    Reply
    |     Jan 29, 2025

    Hi Maria, I have asked our Utilities SME to review your latest post and once I receive their feedback I will provide it to you.

    Sincerely,

    The Db2 for z/OS and utilities team

  • Guest
    Reply
    |     Jan 29, 2025

    Hi Janet, thanks for the new options at db2v13. Currently we have Db2v12 but we'll be progressing soon.

    Anyway, reading the manual i realize that new collected information about objects implied in the utility, is not displayed with the command DISPLAY UTIL(*), and it's a pity because is could be much more useful, because it's not needed a User-Query to the Catalog/Directory to obtain that info.

    My proposal is to include in Db2v12 (&v13) an additional info in the DISPLAY UTIL, showing "ONE OBJECT INVOLVED IS ....", similar as how Db2 already shows the PLAN-HOLDER in a Timeout message (One holder is...) :

    DSNT376I -DBXX PLAN=PPPPPPP WITH 025

    IS TIMED OUT. ONE HOLDER OF THE RESOURCE IS PLAN=DSNUTIL WITH

    CORRELATION-ID=SSSSSSSS

    CONNECTION-ID=UTILITY


    Currently DISPLAY UTIL already informs about number of objects involved (NUMBER OF OBJECTS IN LIST), and even the LAST object started (in the list).

    Our Business JOBs use to refer only 1 object in utilities, and in my opinion this is the much more scenarios in general in other companies. Using LISTDEFs is less used inside Business JOBs. Then "NUMBER OF OBJECTS IN LIST" usually is = 1, and we demand a new line informing about that object "ONE OBJECT INVOLVED IS ....".

    Could you please review this possibility?.

    Thanks in advance


    DSNU100I -DBSX DSNUGDIS - USERID = SISBFF

    MEMBER =

    UTILID = LOADSDB2

    PROCESSING UTILITY STATEMENT 1

    UTILITY = LOAD

    PHASE = RELOAD COUNT = 0

    NUMBER OF OBJECTS IN LIST = 1

    LAST OBJECT STARTED = 1

    new line: ONE OBJECT INVOLVED IS bd.tablespace (and only if possible the table name)

    STATUS = STOPPED

    JOBNAME = SISBFFLO

    TIME STARTED = 2025-01-24-11:48:56






  • Admin
    Janet Figone
    Reply
    |     Jan 24, 2025

    Hi Maria, Please verify the following APARs are applied: (PH55476) (PH55914) (PH55915) (PH55916)

    Sincerely,

    The Db2 for z/OS team

    2 replies
  • Admin
    Janet Figone
    Reply
    |     Apr 14, 2022

    Hello Maria, You are very welcome.

  • Guest
    Reply
    |     Apr 5, 2022

    Hi Janet, this utility history table is really a much complete solution !.

    Thanks in advance

  • Admin
    Janet Figone
    Reply
    |     Jan 5, 2022

    Dear Maria, Thank you for submitting this Aha! Idea. The Db2 for z/OS team has reviewed and provided the following feedback:

    Many utilities can operate against multiple pagesets at a time and due to this complexity there are no plans to enhance -DIS UTIL to report on the various pagesets involved at any point. That said, we are actively working on supporting a proper utility history table in Db2 for z/OS and the plan for the second phase of that support is to reference each pageset that is being or has been processed by any given utility. On that basis this requirement is being marked as future consideration.

    Sincerely,

    The Db2 for z/OS Team

  • Guest
    Reply
    |     Jan 5, 2022

    Thanks Db2-team to consider this "Under Review" of the command

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.