Resizing page sets

You can resize page sets to eliminate extents and to free unused space. To do so, use the Space Manager feature of Db2 Admin Tool. With Space Manager, you can resize all page sets for a database or select specific page sets to resize.

Procedure

To resize page sets:

Complete steps 1 through 3 of Displaying page set statistics.
On the Page Set Statistics (ADB2M1S) panel, specify the RESZ line command to resize a specific page set or the RESZ primary command to resize all listed page sets, and press Enter.
If the page set cannot be resized (because it is not overallocated or in extents), Db2 Admin Tool issues the following message:
```
Nothing to resize (not overallocated or in extents)
```
On the Resize Page Sets (ADB2M1R) panel, complete the following fields, and press Enter:
No. of extents greater than

Specify the minimum number of extents that a page set must have to cause it to be resized.

Pct. used less than

Specify the percentage of space that must be available for a page space to be resized. For example, if you enter 45 in this field, only those page sets that are using less than 45 percent of the space available are resized.
Figure 1. Resize Page Sets (ADB2M1R) panel
```
 DB2 Admin -------------------- DB2X Resize Page Sets -------------------- 20:50
 Option ===> 																							   
																												
 Resize pagesets having:																				
   No. of extents greater than ===> 30  (1-100)										   	
   Pct. used less than         ===> 90  (5-90)  										   	
																												
   BP - Change batch job parameters 
```
Db2 Admin Toolcreates a batch job to resize those page sets that meet the criteria that you specified.
Submit the job to resize the page sets.