Buffer Pools: Extended Storage (DB2 UDB for UNIX and Windows) 

To display information on extended storage for your selected buffer pool(s), call the DBA Cockpit.

...

       1.      In the navigation frame, choose Performance ®Buffer Pools.

The Buffer Pool Snapshot screen appears.

       2.      To display more detailed information, select one or more buffer pools and choose  Details.

A detail Buffer Pool Snapshot screen appears.

       3.      Choose Extended Storage.

If you have selected more than one buffer pool, you can use the page buttons on the screen to navigate between them.

Field	Description
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. For more information, see Maintaining Buffer Pools.

Use extended storage if sufficient memory is available.