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 Administration Tool for z/OS
Created by Guest
Created on May 2, 2019

RELATED IDEAS

Parameter to govern "drop LOB tablespace" when dropping base table

See this idea on ideas.ibm.com

When dropping a table using Db2Admin, it should be possible to ensure that any related LOB tablespaces will be dropped as well. This could be done via a new parameter.

An explicitly defined LOB tablespaces does not get dropped by Db2 when the base tables is dropped. Neither does Db2Admin drop it when using parameter KEEPTARGET=’Y’. We always use this parameter for security reasons.

This gives us two challenges:

  • When archiving old tables out and dropping them, we are left with a number of empty LOB tablespaces. Because of this we have to have regular checks to see if there are empty tablespaces on our system and then remove them manually.
  • When making a change to a table that requires drop/create, the LOB tablespaces is not dropped in between. When loading the rows in again there is actually still data in the “empty” tablespace - which is inaccessible but still takes up space and gives odd results in check utilities.

We opened PMR 61544,040,678 against Db2 for this problem, and PMR 61771,040,678 against Db2Admin. 

  • Guest
    Reply
    |     Mar 9, 2020

    solved by fl506

  • Guest
    Reply
    |     Jun 18, 2019

    This should be opened against DB2 engine please open accordingly

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.