Performance: Schemas (DB2 UDB for UNIX and Windows) (SAP Library

Performance: Schemas (DB2 UDB for UNIX and Windows)

If more than one SAP component is installed within the same database, this overview screen provides a selection of performance data that is related to these components. You can use the information displayed to identify performance-critical components and the workload distribution among the components.

You can access the Performance: Schema Overview screen by calling the DBA Cockpit and choosing Performance ®Schemas in the navigation frame of the DBA Cockpit.

For each component (and partition if you are using a multi-partition database), the following information is displayed:

Column	Description
Partition	Number of the selected partition (only displayed in a multi-partitiond database)
User	Name of connect user to identify the component
SAP Component	Indicates if the connect user is related to a SAP component or another user that is just connected to the database
Data Logical Reads	Number of read accesses to data in the buffer pool
Data Logical Reads (%)	Indicates the percentage of logical data read accesses for the component (and partition if you are using a multi-partition database)
Index Logical Reads	Number of read accesses to index data in the buffer pool
Index Logical Reads (%)	Indicates the percentage of index logical data read accesses for the component (and partition if you are using a multi-partition database)
Data Physical Reads	Number of read accesses to data on disk (I/O). The value includes the number of physical reads that were performed synchronously (by the database manager agents) and asynchronously (by the I/O servers).
Data Physical Reads (%)	Indicates the percentage of physical data read accesses for the component (and partition if you are using a multi-partition database)
Index Physical Reads	Number of read accesses to index data on disk (I/O). Since index data is only read by the database manager agents, this value includes the number of synchronously read index pages.
Index Physical Reads (%)	Indicates the percentage of index physical read accesses for the component (and partition if you are using a multi-partition database)