IBM Data Platform Ideas Portal for Customers
This portal is to open public enhancement requests against products and services offered by the IBM Data Platform 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,
Post an idea
Upvote ideas that matter most to you
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
Hi Maria, I will have our Db2z team review your proposal again.
Yes, as i already response to Janet, in Db2v13 there has been a great improvement. But OPERATORs know about Commands, but they are not familiar with SQL, so, if we don't show it in the DISPLAY it's a pity.
My proposal for adding a line to the DISPLAY, similar as the one for Timeouts/Deadlocks, showing ... one of the tables involved is .... should be really useful.
Even if it's complicated to add a new line to DISPLAY, another option is to change "NUMBER OF OBJECTS IN LIST" (usually is = 1) continued with the name of the first Tablespace involved.
I'll will appreciate if you can review it. Be aware that if we don´t have that in the display, we finally will have to create a in-house tso command...
Thank's for your help
Although not supported with DISPLAY, this is available from the utility history tables.
Our strategy is to use utility object-level history to show and record the objects involved and affected by utilities. As soon as an executing utility has vetted the objects and enters the utility serialization process, SYSIBM.SYSOBJEVENTS rows are inserted for each object that will be affected. Utility object-level history gives real-time information with SQL SELECT. Displaying the object information in the DISPLAY UTILITY command output is not practical for utilities operating on a large number of objects. Some customers invoke the COPY utility on tens of thousands of objects.
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
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
Hi Maria, Please verify the following APARs are applied: (PH55476) (PH55914) (PH55915) (PH55916)
Sincerely,
The Db2 for z/OS team
Hello Maria, You are very welcome.
Hi Janet, this utility history table is really a much complete solution !.
Thanks in advance
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
Thanks Db2-team to consider this "Under Review" of the command