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 Future consideration
Workspace Db2 for z/OS
Created by Guest
Created on Oct 7, 2014
Merged idea

This idea has been merged into another idea. To comment or vote on this idea, please visit DB24ZOS-I-982 Control of Locksize and Maxpartitions for implicitly defined tablespaces. .

DB2 to provide a way to override MAXPARTITIONS and LOCKSIZE defaults Merged

QMF Product Development is opening this work item in response to DeveloperWorks Request id 59512 (PMR: 46297,442,000) (RTC ID 41210). Please review that work item to see the customers pain points. We have had additional discussions with the customers and here are some questions we asked with their responses as to why they need to do implicit table space creations and why they would like to override certain parameters.
· Explicit table spaces are what we were using before we started converting/creating new QMF tables with implicit tablespaces.  There are multiple reasons why we need to stay with implicit creation vs. using multi-table tablespaces for QMF tables: 
1)  As a new standard policy in our shop, we are converting all multi-table tablespaces to 1 table per tablespace, including QMF. 
2)  Specifically for QMF, we use implicit table spaces to get 1 table per tablespace in order to prevent/reduce the large size of multi-table QMF table spaces (which end up containing 100s if not 1000s of QMF tables in each tablespace). 
3)  Using implicit tablespaces to get 1 QMF table per tablespace allows us to reduce contention, improve query performance,  and improve the efficiency and reduce the cost of QMF tablespace backups/reorgs/runstats which we run conditionally based on activity in the tablespace.  
4) Using implicit table spaces eliminates the exposure of someone accidentally doing a load replace on a single table in a multi-table tablespaces and consequently emptying out all the other tables (which has happened before and resulted in significant recovery and downtime for the users).    
5) The problem right now with the implicit tablespaces used by QMF (done by DB2) is that we have to do weekly mass ALTERs on 100s of implicitly created QMF table spaces to change the MAXPARTITIONS and LOCKSIZE as well as the BUFFERPOOL (we isolate QMF tables/indexes to their own bufferpool and implicit tablespaces do not use the default BUFFERPOOL settings defined in each of our QMF databases). We do not want to change our zparms since the global settings there controlling MAXPARTITIONS and LOCKSIZE for implicitly created tablespaces are correct for the majority of DB2 users, just not most QMF users.  Space is not the issue d'jour. 
  • Guest
    Reply
    |
    Jan 10, 2020

    When multi table tablespaces is deprecated, we need an option to control LOCKSIZE and MAXPARTITIONS for implicit defined tablespaces. QMF users will be heavy user of implicit tablespaces. These users will drive up the cost of LOCK request for LOCKSIZE ROW. We need an option for controlling this Option. For administration purpose we need to control MAXPARTITION as well, so a single user will not run away with very large tablespace.

    Kind regards,
    Henrik Henriksen

    Danske Bank
    IT Infrastructure
    Mainframe Architecture & Optimisation
    Phone +45 45 13 27 77
    Extension 32777
    hhne@danskebank.dk