Reduce high-level mark operations for DB2 to manage tablespaces

Today, we are mainly going to show you how to correctly reduce the high-water mark of the DB2 management tablespace. The following describes the specific steps for correctly reducing the high-water mark of the DB2 management tablespace, I hope this will help you in your future studies.

IBM and DB2 Management

How can we use the DB2DART tool to reduce the high-level mark of tablespaces managed by the DB2 database?

For DB2 database governance DMS) the High-Level mark HWM of a tablespace refers to the maximum number of data pages that have been used in the tablespace. For example: db2 list tablespaces show detail

If you see that the number of used pages in a DMS tablespace is lower than the mark of the High Level, you may use the following method to reduce the mark:

1. reorganize a table in the tablespace;

2. Export the data in a table, delete it, recreate the table, and import the data.

In the preceding method, you must first find the table that holds the high-water mark, which can be used after the instance is stopped using the DB2DART command.) Add the/DHWM option to provide the tablespace identifier, then, obtain it from the report file generated by the command.

To learn about how to reduce HWM by performing operations on the table, you can use DB2DART and the/LHWM option to obtain it from the generated report file. When the/LHWM option is used, the user is required to give the table space identification and the number of pages to which the HWM is reduced. Although the HWM cannot be sure to be reduced to the expected value, if the value is 0, it indicates that the HWM is reduced by DB2 to the minimum value that can be reached.

In addition, you can use the DB2DART plus/RHWM option to remove the space ing data blocks that are no longer needed in the DMS tablespace to reduce HWM, these spatial ing data blocks will not be deleted when the mapped data is deleted. The above content is an introduction to how to reduce the high-level mark of the DB2 management tablespace.

Transfer to a website

The above content is a description of how to reduce the high level mark of the table space managed by DB2. I hope it will help you in this regard.