Show TOC

Process documentationSpace Management with DB2 for Linux, UNIX, and Windows Locate this document in the navigation structure

 

This section looks at space management (including reorganization) of database objects (that is, tables and tablespaces). If you neglect space management, this can lead to downtime due to normal database growth when database objects fill up. If this happens, applications cannot write to the database and you have to quickly make more space available. Therefore, it is much better to anticipate the problem by monitoring and proactively managing the disk space in your database.

Recommendation Recommendation

We recommend that you manage space using the DBA Cockpit in the SAP system. You need to monitor regularly and take timely action to avoid the problem leading to downtime.

End of the recommendation.

Prerequisites

The standard page size for DB2 V9.7 and higher for Linux, UNIX, and Windows is 16 KB. This leads to a limitation of 32 TB per tablespace. If larger tablespaces are needed, DB2 for Linux, UNIX and Windows offers the additional page size 32 KB.

Table Space Limitations

Page Size of Tablespace

Maximum Tablespace Size

4 KB

8 TB

8 KB

16 TB

16 KB

32 TB

32 KB

64 TB

Process

  1. You monitor storage by using the DBA Cockpit.

    If free space in a tablespace decreases continuously, extend the tablespace by resizing or adding containers or by reorganizing tables. Resizing containers is the fastest way to extend tablespaces.

  2. When free space in a tablespace reaches a critical limit, you decide which of the following to do:

Result

By managing the space in your DB2 for Linux, UNIX, and Windows database, you can avoid unplanned downtime due to database objects filling up.

More Information

Database Administration Using the DBA Cockpit: IBM DB2 for Linux, UNIX, and Windows at:

  https://service.sap.com/instguidesnw   <Your SAP NetWeaver Release>   Operations   Database-Specific Guides