Entering content frame

Background documentation Tablespaces: Extended Storage (DB2 UDB for UNIX and Windows) Locate the document in its SAP Library structure

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 This graphic is explained in the accompanying text 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.

Recommendation

Use extended storage if sufficient memory is available.

 

Leaving content frame