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


Add a new idea Subscribe
Status Delivered
Workspace Db2 for z/OS
Created by Guest
Created on Feb 1, 2022

RELATED IDEAS

Provide functionality to free inactive copies of native REST service packages

See this idea on ideas.ibm.com

Native REST services in Db2 system have packages. There can also exist inactive copies (original and previous copies - COPYID 1 and 2) of these REST service packages - coming out of PLANMGMT.


Problem:

Current FREE SERVICE command implementation (currently following the Remote FREE PACKAGE design) does not provide the functionality to free the inactive copies, but keep the active copy of the package.

Current FREE PACKAGE command implementation does not provide the functionality to free packages for REST services.


Current State:

We have to keep the inactive copies of REST service packages in the DB2 system as long as the corresponding REST service is active and used. This copies occupies space in SPT01.


Proposed solution:

Allow local FREE PACKAGE with PLANMGMTSCOPE(INACTIVE/ORIGINAL/PREVIOUS) for REST service packages

or

Implement PLANMGMTSCOPE + INVALIDONLY options for FREE SERVICE command


Value:

general housekeepning and brings a little relief for SPT01 space occupation

Please be aware, that the number of inactive REST service packages will increase over time with the increase of REST service usage.


Needed By Quarter
  • Admin
    Janet Figone
    Reply
    |     Aug 15, 2023

    Hello Frank, That is great news. Thank you for the update!

    Sincerely,

    The Db2 for z/OS Team

  • Guest
    Reply
    |     Jul 24, 2023

    Hello Janet and Db2 for z/OS team,

    thank you for providing this functionality via UI92473. We alreday received the PTF and will activate it with the next maintenance rollout.

    Best regards

    Frank

  • Admin
    Janet Figone
    Reply
    |     Jul 17, 2023

    Hello Frank, Great news! Db2 for z/OS APAR PH54129/UI92473 is now available. This APAR delivered the function you requested: to delete only the INACTIVE copies of the RESTful service package version.

    Sincerely,

    The Db2 for z/OS Team

  • Admin
    Janet Figone
    Reply
    |     Jun 29, 2022

    Hello Frank, We agree with you and have therefore re-opened this idea and are re-reviewing it at this time to determine next state.

  • Guest
    Reply
    |     Jun 22, 2022

    Hello Janet and Db2 for z/OS,

    I took a look into PH21058 (= Db2 V12 PTF UI68731). This PTF is already active in our systems.

    The functionality provided by PH21058 / UI68731 for freeing RESTful services is not the functionality we requested by this idea.

    We do not want to free a whole version of a RESTful service, which is possible with PH21058, but rather want to delete only the INACTIVE copies of the RESTful service package version. The inactive copies of a package version are created by Db2 within PLANMANAGEMENT concept.

    Therefore I think, your status change of this idea to "Delivered" is not correct.

    Best regards

    Frank


  • Admin
    Janet Figone
    Reply
    |     Jun 21, 2022

    Hello, We are pleased to inform you this Aha! Idea has been delivered in APAR PH21058: NEW FUNCTION UPDATE OF DB2 NATIVE RESTFUL SERVICES SUPPORT.

    This APAR provides updates to Db2 native RESTful services that allow a Db2 requester to free a service on a Db2 server.

    Sincerely,

    The Db2 for z/OS Team

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.