IBM Data & AI

 Welcome to the IBM Data & AI Ideas Portal for Clients! 

We welcome and appreciate your feedback on IBM Data & AI Products to help make them even better than they are today!
Before you submit an idea, please perform a search first as a similar idea may have already been reported in the portal.  If a related idea is not yet listed, please create a new idea and include with it a description which includes expected behavior as well as why having this feature would improve the service and how it would address your use case.
IBM Employees:
Clients:
  • Our team welcomes any feedback  and suggestions you have for improving our offerings / products!  This forum allows us to connect your offering / product improvement ideas with IBM product and engineering teams.
  • If you have not registered on this portal please click on the following link and register.  To complete registration you will need to open the email you will receive from Aha to confirm your identity. http://ibm.biz/IBM-Data-and-AI-Portal-Register
Additional Information:
  • The shorter URL for this site is: https://ibm.biz/IBM-Data-and-AI-Ideas
  • To view our roadmaps: http://ibm.biz/Data-and-AI-Roadmaps
  • Reminder: This is not the place to submit defects or support needs, please use normal support channel for these cases
  • Please do not use the Ideas Portal for reporting bugs - we ask that you report bugs or issues with the product by contacting IBM support.

Remove per-tablespace size limitation for v11.1 and v11.5 community edition

Currently if we restore a database backup that was taken on a higher edition of Db2 into Developer-C, it fails with SQL1139N, even if it is fully less than 100GB. There are two workarounds for this:

  1. Set a MAX for all table spaces before taking the backup. This is problematic, because setting a MAX may not be desired in that environment, and may risk a future outage in that environment.
  2. Apply a different license, do the restore, then change the license.

DB2 should just force the max settings on restore without a user having to go in and change them.

  • Ember Crooks
  • Jun 7 2019
  • Planned
Why is it useful?
Who would benefit from this IDEA? Anyone who wants to build a sandbox or development environment based on another environment.
How should it work?

On restore, Db2 should set a max size for each table space of 100 GB. If any table space exceeds this, then the restore should fail. Alternately, a utility should be available to run against the backup to set the max size for each table space in the backup image.

I understand that IBM needs to enforce their licensing requirements, but making it harder to use the entry level edition is not the best way to do it.

Idea Priority High
Priority Justification It is strange that this does not work already. I understand that IBM needs to enforce their licensing requirements, but making it harder to use the entry level edition is not the best way to do it.
Customer Name
Submitting Organization
Submitter Tags
  • Attach files
  • Hung Tam Nguyen commented
    3 Jan 06:27pm

    In case anyone is confused,  the limitation of the community edition is 100 GB of storage per database.  So it's 100GB OF tablespace (the total), not PER tablespace.  db2licm -l wording can be misleading

  • Hung Tam Nguyen commented
    3 Jan 05:32pm

    Encountered this issue as well even though I was just restoring from Express edition 9.7 into Trial 11.1 and finally into the new Community edition 11.5, so higher edition is not a requirement to trigger the issue.

    I have expanded on the How should it work section a little bit:

     

    First step on restore, Db2 should check each tablespace for a maxsize of None or greater than 100GB.  It should write a warning if any are found and automatically set the tablespace maxsize to 100GB for each.

     

    Second step, Db2 should estimate the total size of the database to be restored including known compression ratios and give a warning prompt if the total actual space used risk being greater than 100GB. The user will have a chance to abort right away and fix things instead of having to wait for a lengthy restore that will just fail towards the end. 

     

    Alternately, an utility could be available to run against the backup file to do the above steps as a prerequisite check.

  • Samuel Pizarro commented
    10 Sep, 2019 08:55pm

    For sure

     

    I faced the same issues..  it was a pain! Simple change in the code...  Should not be that hard to implement this 

  • and 1 more

NOTICE TO EU RESIDENTS: per EU Data Protection Policy, if you wish to remove your personal information from the IBM ideas portal, please login to the ideas portal using your previously registered information then change your email to "anonymous@euprivacy.out" and first name to "anonymous" and last name to "anonymous". This will ensure that IBM will not send any emails to you about all idea submissions