Performance: Database Snapshot (DB2 UDB for UNIX and Windows) 

The Database Snapshot screen provides an overview of the following critical database performance indicators:

·        Buffer Pool

·        Cache

·        Asynchronous I/O

·        Direct I/O

·        Extended Storage

·        Locks and Deadlocks

·        Logging

·        Calls

·        Sorts

You can access the Database Snapshot screen by calling the DBA Cockpit and choosing Performance ® Database in the navigation frame of the DBA Cockpit. The Database Snapshot screen is the initial screen of the SAP database monitor for DB2 UDB for UNIX and Windows.

The system displays values collected since the database was started. If the database is shut down, the values are deleted.

The values displayed are not really meaningful until the database has been running for some time. The longer the database has been running, the more useful the values.

To access more detailed information, you can choose any of the following entries under Performance in the navigation frame:

·        Schemas

·        Buffer Pools

·        Tablespaces

·        Tables

·        Applications

·        SQL Cache

·        Lock Waits

·        Deadlocks