Database: Extended Storage (DB2 UDB for UNIX and Windows) 

To display information on extended storage, call the DBA Cockpit.

...

       1.      In the navigation frame, choose Performance ®Database.

The Database Snapshot screen appears.

       2.      Choose Extended Storage.

 

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

We recommend that you only use extended storage if sufficient memory is available.