DB2 Server for VSE & VM: Operation

SHOW POOL

Displays physical storage information about database storage pools.

Syntax



                .-ALL-----.
>>-SHOW POOL----+---------+------------------------------------><
                +-SUMMARY-+
                +-DELETED-+
                '-n-------'

ALL
Displays detailed information, grouped by dbextent, about each storage pool in the database.

SUMMARY
Displays summary information about each storage pool in the database.

DELETED
Display information about deleted dbextents

n
Displays detailed information, grouped by dbextent, about storage pool number n.

Description

This command is updated to let you display the following for storage pool information:

SHOW POOL SUMMARY

A column entitled "I/O" is added to the SHOW POOL SUMMARY display. Under its heading is a two-or three-letter code that indicates the current storage pool specifications. Possible specification code combinations are:

BK
The storage pool is using the standard I/O system, without striping.

BKS
The storage pool is using the standard I/O system, with striping.

Dn
The storage pool is using Data Spaces Support, without striping. n is the current storage residency priority.

DnS
The storage pool is using Data Spaces Support, with striping. n is the current storage residency priority.

SHOW POOL and SHOW POOL ALL

Two new codes are added to the SHOW POOL and the SHOW POOL ALL displays beside the number of extents. Possible specification code combinations are:

BLK SEQ
The storage pool is using the standard I/O system, without striping.

BLK STR
The storage pool is using the standard I/O system, with striping.

DSn SEQ
The storage pool is using Data Spaces Support, without striping. n is the current storage residency priority.

DSn STR
The storage pool is using Data Spaces Support, with striping. n is the current storage residency priority.

Example

+--------------------------------------------------------------------------------+
|show pool 1                                                                     |
|                                                                                |
|POOL NO.  1:     NUMBER OF EXTENTS = 2  DS2 STR                                 |
|                                                                                |
|EXTENT   TOTAL   NO. OF     NO. OF     NO. OF     %                             |
| NO.     PAGES PAGES USED FREE PAGES RESV PAGES USED                            |
|   1       855         77       778               9                             |
|   2       855         45       810               5                             |
|TOTAL     1710        122      1588         20    7                             |
|ARI0065I Operator command processing is complete.                               |
|                                                                                |
|show pool all                                                                   |
|                                                                                |
|POOL NO.  1:     NUMBER OF EXTENTS = 2  DS2 STR                                 |
|                                                                                |
|EXTENT   TOTAL   NO. OF     NO. OF     NO. OF     %                             |
| NO.     PAGES PAGES USED FREE PAGES RESV PAGES USED                            |
|   1       855         77       778               9                             |
|   2       855         45       810               5                             |
|TOTAL     1710        122      1588         20    7                             |
|                                                                                |
|POOL NO.  2:     NUMBER OF EXTENTS = 1  BLK STR                                 |
|                                                                                |
|EXTENT   TOTAL   NO. OF     NO. OF     NO. OF     %                             |
| NO.     PAGES PAGES USED FREE PAGES RESV PAGES USED                            |
|   3      7467          2      7465               0                             |
|TOTAL     7467          2      7465         20    0                             |
|                                                                                |
|FREE AREAS:    NUMBER OF DELETED EXTENTS = 0                                    |
|                                                                                |
|EXTENT   TOTAL                                                                  |
| NO.     PAGES                                                                  |
|END    1674279                                                                  |
|TOTAL  1674279                                                                  |
|                                                                                |
|Maximum number of DBEXTENTs = 6                                                 |
|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.                               |
+--------------------------------------------------------------------------------+

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]