Show TOC Start of Content Area

Function documentation Catalog Buffer Monitor  Locate the document in its SAP Library structure

Use

The database catalog buffer caches metadata about tables that have been recently accessed using Open SQL. A single catalog buffer instance exists for each used database schema. Although it is possible to register several DataSource objects for a particular database schema, the same catalog buffer is used for the schema. You use the Catalog Buffer Monitor to obtain statistics about the status and the use of the catalog buffer.

Prerequisites

You are in Problem Management Database Open SQL Monitors Catalog Buffer Monitor.

Activities

On the Accessed Catalog Buffers screen, you can choose a catalog buffer instance that you want to monitor. A catalog buffer is displayed along with the following details:

Catalog Buffer Details

Parameter Name

Description

Buffer ID

A unique identifier for a catalog buffer instance within a cluster node. It is created by the concatenation of the database host, the database name and the database schema.

References

Current number of catalog readers associated to the catalog buffer instance

Max

Maximum number of entries in the buffer

Current

Current number of entries in the buffer

Free

Remaining free positions

Displacements

Number of displaced entries in the buffer

When you choose a catalog buffer from the list, the Buffered Catalog Tables screen area displays a list with tables for that buffer ID.

To view the catalog table columns, select a table from the list. The Catalog Table Columns screen area displays data for each column in the selected table.

End of Content Area