Skip to Main Content
IBM Data and AI Ideas Portal for Customers
Hide about this portal


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


Clarification on Alter or Modify Time Column in syscat.procedures Admin View/Table

See this idea on ideas.ibm.com

Hi Team,


As part of SOX Audit, we were asked to get latest Alter or Modify time of procedures from syscat.procedures view. But only Create_Date column is found and Alter_Time column is not found. We were questioned why the syscat.procedures view doesn't contain Alter_Time like syscat.tables. We have responded like below,

"In one source its found that PROCEDURE has to be dropped and re-created to modify it and we don't have an option alter to modify and Create_time in syscat.procedures is considered as recent alter or modify time."


The above information is not found in any of IBM official document, but It is confirmed from IBM through TS018397757. Audit team has asked to provide the IBM official document which confirms the same.


So, If above statement is true, please add it to IBM official document. So that This information will be provided to them.


Regards,

Anil Maddineni

Needed By Week
  • Admin
    Siji Daniel
    Reply
    |
    Feb 7, 2025

    Hello.

    Please continue to work through the open Support case and provide the details requested there. Db2 Support team will provide additional guidance based on your responses. Note that you may get the desired functionality querying the SYSCAT.ROUTINES view which has replaced SYSCAT.PROCEDURES view. Check out the ALTER TIME field as described here.

    Since the feature is available, and no documentation change remains to be made, I will proceed to mark this idea as Functionality already delivered. Db2 Support will continue to work with you for more specific questions.

    Thank for you shaping the future roadmap of Db2 with your valuable input.

  • Admin
    Siji Daniel
    Reply
    |
    Feb 4, 2025

    Thank you for submitting your request. We are reviewing this. If I understand correctly, your request is related to updating the IBM documentation to show stored procedures cannot be altered, only dropped and recreated - which will alter the Create_time field in the catalog tables - is that right?

    Such a request should have been completed in the Support case you had open. I will review that with the support team. In the meantime, let me connect the Documentation owner with this request.

    Please expect an update in the portal within 90 days.
    Thank you.