DB2 Server for VSE & VM: Operation

SET POOL

Changes storage pool specifications.

Syntax

(1) (1) >>-SET POOL--n1----+-----+---+-----------+---------+-----+------->< '--n2-' | .-3--. | +-STR-+ '-DS-+----+-' '-SEQ-' '-n--' Notes: You must include at least one of these blocks.

n1

Specifies that you want to change the specifications for storage pool n1. Valid values are integers from 1 to 999.

n2

Specifies a range of storage pools from n1 to n2. Valid values are integers from 1 to 999. n2 must be greater than or equal to n1.

DS

Sets the working storage residency priority of the storage pools you specify to n. Valid values are integers from 1 to 5. The default is 3. If you do not include DS the database manager will use the current storage pool setting (unless the pools you specified are not using data spaces).

Figure 91 summarizes the five storage residence priorities. An R indicates that the database manager releases a page from main and expanded storage after it has been moved to a local buffer.

Figure 91. Storage Residence Priorities

Page Type	Current Working Storage Size	Working Storage Residence Priority
		1	2	3	4	5
Data	<= target	R	R
	> target	R	R	R	R
Index	<= target	R
	> target	R	R	R

STR

Turns striping on for the storage pools you specify.

SEQ

Turns striping off for the storage pools you specify. The database manager will allocate pages sequentially on DASD.

Note:

If you do not include SEQ or STR, the database manager will use the current storage pool setting.

Description

This command lets you dynamically change some of the current storage pool specifications. Note that since you cannot use this command to dynamically change whether a storage pool uses Data Spaces Support, the storage pool you specify must already be using data spaces before you can use the DS parameter.

Example

The following example shows a summary of storage pools before and after turning striping on for storage pool 2:

+--------------------------------------------------------------------------------+
|show pool summary                                                               |
|                                                                                |
|POOL     TOTAL   NO. OF     NO. OF     NO. OF     %  NO. OF                     |
|NO.      PAGES PAGES USED FREE PAGES RESV PAGES USED EXTENTS SOS I/O            |
|   1      1710        122      1588         20    7       2      D2S            |
|   2      7467          2      7465         20    0       1      BK             |
|FREE   1674279                                                                  |
|ARI0065I Operator command processing is complete.                               |
|set pool 2 str                                                                  |
|ARI0065I Operator command processing is complete.                               |
|show pool summary                                                               |
|                                                                                |
|POOL     TOTAL   NO. OF     NO. OF     NO. OF     %  NO. OF                     |
|NO.      PAGES PAGES USED FREE PAGES RESV PAGES USED EXTENTS SOS I/O            |
|   1      1710        122      1588         20    7       2      D2S            |
|   2      7467          2      7465         20    0       1      BKS            |
|FREE   1674279                                                                  |
|ARI0065I Operator command processing is complete.                               |
+--------------------------------------------------------------------------------+

This example shows storage pool 1 before and after turning striping off and setting its working storage residence priority to 2:

+--------------------------------------------------------------------------------+
|show pool 1                                                                     |
|                                                                                |
|POOL NO.  1:     NUMBER OF EXTENTS = 2  DS3 STR                                 |
|                                                                                |
|EXTENT   TOTAL   NO. OF     NO. OF     NO. OF     %                             |
| NO.     PAGES PAGES USED FREE PAGES RESV PAGES USED                            |
|   1       855         74       781               8                             |
|   2       855         47       808               5                             |
|TOTAL     1710        121      1589         20    7                             |
|ARI0065I Operator command processing is complete.                               |
|set pool 1 ds2 seq                                                              |
|ARI0065I Operator command processing is complete.                               |
|show pool 1                                                                     |
|                                                                                |
|POOL NO.  1:     NUMBER OF EXTENTS = 2  DS2 SEQ                                 |
|                                                                                |
|EXTENT   TOTAL   NO. OF     NO. OF     NO. OF     %                             |
| NO.     PAGES PAGES USED FREE PAGES RESV PAGES USED                            |
|   1       855         74       781               8                             |
|   2       855         47       808               5                             |
|TOTAL     1710        121      1589         20    7                             |
|ARI0065I Operator command processing is complete.                               |
+--------------------------------------------------------------------------------+