IBM Support

How to manually extend automatic storage tablespace containers upfront

How To


Summary

Starting from Db2 v10.1, system managed (SMS) and database managed (DMS) table spaces have been deprecated and automatic storage table spaces have become the default user table space.

As automatic storage table spaces manage container storage for you, the database manager seeks to maximize space utilization by creating and extending table space containers only as needed.  Therefore, maintenance operations to manually extend automatic storage table spaces are not available.

One benefit of extending table space containers upfront is avoiding the penalty of multiple extensions later as the table space grows.

Document Location

Worldwide

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
30 April 2025

UID

ibm11078515