Skip to Main Content
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,

  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


Status Not under consideration
Workspace Db2 for z/OS
Created by Guest
Created on Jun 22, 2022

Implicit Tablespaces for conversion of multi-table tablespaces to UTS PBG

When converting multi-table tablespaces to universal tablespaces with new command ALTER TABLESPACE MOVE TABLE you need to create a new tablespace for each table explicitely before you can use the command.

It would be very nice if the ALTER TABLESPACE MOVE TABLE would be able to create the needed tablespaces implicitely, controlled by parameter or changed syntax of the command.


Needed By Quarter
  • Guest
    Reply
    |
    Jan 3, 2023

    Hi Janet,

    many thanks for your explanations about our idea! We will just use the Db2 Admin Tool functionality (MOVE TABLE) for creating the new tablespaces. ���

    Happy New Year!

    Mit freundlichen Gr����en / Kind regards

    Thomas Renner
    Dipl-Physiker

    Certified IMS & DB2 Specialist
    Teamleitung SSD CO ITOM 2 zOS 2

    Bitte verwenden Sie f��r alle Informationen und Anfragen zu IMS- bzw. Db2-relevanten Themen das Funktionspostfach
    ���BWI FP Mainframe Datenbanken���
    mailto: bwi.fp.mainframe-datenbanken@bwi.de

    Phone:

    +49 (0)2225-988-6270

    BWI GmbH

    Mobile:

    +49 (0)151-11760523

    Pascalstr. 10 / Rz Haus 940

    E-Mail:

    Thomas.Renner@bwi.de

    53125 Bonn

    Deutschland

    www.bwi.de
    Besuchen Sie uns auf: XING | LinkedIn | Facebook | Twitter |

    ���Wir sorgen f��r die digitale Zukunftsf��higkeit unseres Landes���

    BWI GmbH
    Gesellschaft mit beschr��nkter Haftung ��� Sitz der Gesellschaft: Meckenheim ��� Registergericht: Bonn ��� HRB 15251 ��� USt-IdNr: DE814789837
    Vorsitzender des Aufsichtsrats: Dr. Thomas Daum
    Gesch��ftsf��hrung: Martin Kaloudis (Vorsitzender), Katrin Hahn, Frank Leidenberger

    Von: IBM Data and AI Ideas <1acbe8e77e0b5c12ca33fbf3-bigblue@iad-prod1.mailer.aha.io>
    Gesendet: Montag, 2. Januar 2023 19:38
    An: Renner, Thomas
    Betreff: Janet Figone responded to idea DB24ZOS-I-1377 Implicit Tablespaces for conversion of multi-table tablespaces to UTS PBG

  • Admin
    Janet Figone
    Reply
    |
    Jan 2, 2023

    Dear Thomas and Joachim, Thank you for submitting this enhancement request. The Db2 for z/OS development team reviewed it and provided the following feedback:

    Multi-table tablespace conversion to PBG requires the explicit creation of target PBG tablespaces. This was a deliberate design decision because Db2 has to support scenarios where customers have specific naming conventions for tablespaces, so support for explicitly created tablespaces was a necessity whereas support for implicit creation was not. Target tablespaces can be created in advance by REXX scripts, or by use of administration tooling. E.g. the IBM Administration Tool has been enhanced to support this type of scenario to simplify conversion. Since such alternatives exist, Db2 development has other priorities in the short/medium term than to deliver this capability and therefore this will be marked as currently not under consideration.

    Please do continue to submit enhancement requests to us as we review each and every one to assess its value for improving the Db2 for z/OS product for our customers.

    Sincerely,

    The Db2 for z/OS Team