Entering content frame

Background documentation Applications: 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 application(s), call transaction ST04.

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

    2. The Application Snapshot screen appears.

  2. To display more detailed information, select one or more application and choose This graphic is explained in the accompanying text Details.

    3. A detail Application Snapshot screen appears.

  3. Choose Extended Storage.

If you have selected more than one application, 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 storage with the following command:

ALTER BUFFERPOOL <name> EXTENDED STORAGE .

Recommendation

Use extended storage if sufficient memory is available.

 

 Leaving content frame