It is easy to reduce the high-level mark of the tablespace managed by DB2!

The following articles mainly describe how to correctly reduce the high-level mark of the table space managed by DB2. This article mainly uses the DB2DART tool to reduce the high-level mark of the table space managed by DB2 databases. The following describes the main content of the article.

The High Level mark (HWM) for the DB2 database management (DMS) tablespace refers to the maximum number of data pages that have been used in the tablespace. If you use:

The following is a reference clip:

 
 


  
  
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 above method, first you need to find the table that holds the high-water mark, which can be used after the DB2DART command (can be used after the instance is stopped) with 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 tablespace identifier and the number of pages to which the HWM is to be reduced (although the HWM cannot be guaranteed 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 lowering the high-level mark of the DB2 management tablespace. I hope you will have some gains.