!--a11y-->
Tablespaces: Extended Storage (DB2 UDB for
UNIX and Windows) 
To display information on extended storage for your selected tablespace(s), call the DBA Cockpit.
...
1. In the navigation frame, choose Performance ®Tablespaces.
The Tablespace Snapshot screen appears.
2.
To display more detailed
information, select one or more tablespaces and choose
Details.
A detail Tablespace Snapshot screen appears.
3. Choose Extended Storage.
If you have selected more than one tablespace, you can use the page buttons on the screen to navigate between them.
|
Pool Data |
|
|
To Extended Storage |
Number of data pages copied from the buffer pool into extended storage to create space in the buffer pool |
|
From Extended Storage |
Number of data pages copied back from extended storage to the buffer pool because they are needed |
|
Pool Index |
|
|
To Extended Storage |
Number of index pages copied from the buffer pool into extended storage to create space in the buffer pool |
|
From Extended Storage |
Number of index pages copied back from extended storage to the buffer pool because they are needed |
By default, extended storage is not activated.
The number of storage segments is defined by database parameter num_estore_segs. The size of a segment is defined by the database parameter estore_seg_sz.
Before a buffer pool can use extended storage, you have to connect it to extended storage. For more information, see Maintaining Buffer Pools.

Use extended storage if sufficient memory is available.
