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,
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
Dear KC, Thank you for your response. The Db2 for z/OS development team reviewed it and would like you to be aware that even with SYSPACKAGE.LASTUSED, applications need to be exposed over time in order for Db2 to record usage.
We will reconsider this idea again at a later time.
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
Agreed that this meets our expectations regarding static calls. However, most of our calls would be dynamic, and as such, we don���t have a good solution today.
You suggested that IBM could create a new trace and we could ���monitor the new trace and SYSPACKAGE.LASTUSED over time while exposing all applications���. Exposing all applications is no small feat in our enterprise. Therefore, even this solution is not trivial. I would say that your proposal is better than nothing but far from ideal.
Classification: Internal Use
May I ask for some patience?
We have a lot of other projects going on, and we support more software than DB2. We need to ensure we are extracting this data and that it meets our needs before we can say that we are comfortable closing this idea.
Thanks,
KC
Classification: Internal Use
Dear KC, We are awaiting your response - if we have provided an acceptable solution. If you are not able to respond by June 6th we will close this idea (due to information not provided). But please be aware you will still be able to post comments following the closure of the idea.
We do hope to hear from you as we hope what has been provided is an acceptable solution for you.
Kind regards,
The Db2 for z/OS Team
Dear KC, Thank you for submitting this enhancement request. Our apologies for the delayed response. Please be aware that our Db2 for z/OS development has review this idea and has provided the following feedback and question for you:
We are thinking that for static SQL, you can query the stored procedure dependency in SYSPACKDEP and monitor usage via SYSPACKAGE.LASTUSED. For dynamic SQL and static SQL which needs to go through incremental bind, we can consider writing a new trace record for object dependencies. You'd need to monitor the new trace and SYSPACKAGE.LASTUSED over time while exposing all applications, before confidently dropping the procedure. Is this an acceptable solution?
Stored procedures with SQL statements have packages in Db2 so you can use package accounting for performance statistics. At statement level, you can use IFCID 316 (if cached dynamic) or IFCID 401 (if static), just like any other SQL statistics in a regular application package.
Please let us know your thoughts.
Kind regards,
The Db2 for z/OS Team