Chat now with support
Chat with Support

Spotlight on DB2 6.9.3 - User Guide

Spotlight on IBM DB2 LUW (Linux, Unix, and Windows)
New in This Release Getting started with Spotlight on IBM DB2 LUW Desktop features specific to Spotlight on IBM DB2 LUW Spotlight on IBM DB2 LUW drilldowns
About Spotlight on IBM DB2 LUW drilldowns Buffer Pool Analysis drilldown Client Application Analysis drilldown Database Analysis drilldown Database Manager Summary drilldown Diagnostic Log drilldown FCM Analysis drilldown Tablespace Analysis drilldown Top SQL drilldown Operating System drilldown Workload Management Analysis drilldown
Spotlight on IBM DB2 LUW alarms Spotlight on IBM DB2 LUW Options Tuning SQL statements in Spotlight on IBM DB2 LUW
Spotlight Basics
Spotlight Connections Monitor Spotlight Connections Alarms Charts, Grids And Home Page Components View | Options Troubleshooting
Spotlight History Spotlight on Windows
Connect to Windows Systems Background Information Home Page Alarms Drilldowns View | Options Troubleshooting
Spotlight on Unix About us Third-party contributions Copyright

Memory Pool types

The database manager controls all shared memory usage on the system through the following top down hierarchy:

  • Database manager global shared memory. Also known as instance shared memory, this is the primary memory allocation that the database manager uses when assigning memory for databases and applications. It is allocated when DB2 starts and is not deallocated until DB2 is stopped.
  • Database global shared memory. Database global memory is allocated by the database manager whenever a database is activated or connected to for the first time, and it is used for all applications that connect to the database. The size of this space is controlled by the database_memory parameter.
  • Application global shared memory. This memory is allocated to applications under the following conditions:

    • In a partitioned environment
    • In a non-partitioned environment with intra-partition parallelism turned on
    • In an environment that has a connection concentrator enabled, you can assign several applications to an application group for the purpose of sharing memory. The database manager assigns each application group its own allocation of shared memory. This sharing improves system performance by reducing the possibility of unnecessarily over-allocating memory.

    The size of Application global shared memory is controlled by the Application Control Heap Size (APP_CTL_HEAP_SZ) parameter.

  • Agent Private Memory. Agent private memory is allocated when a connect request or a new SQL request is made in a parallel environment. It contains memory allocations used for this specific agent only. Examples of agent private memory are the sort heap and the application heap.
  • Agent/Application Shared Memory. This memory is used for SQL request and response communications between an agent and its client application.

Memory Pool tabs

The Spotlight drilldowns that contain tabs for memory pools are as follows:

  • Database Manager Summary
  • Databases
  • Client Applications

The following table lists the different memory allocations, the DB2 parameter used to control and adjust their sizes, and the most likely drilldown where information about a particular heap can be found. It is important to keep in mind that information for any of the heaps can be displayed in any of drilldowns listed. What this chart does is list the drilldown that most commonly displays the statistics for a particular memory segment.

Name

DB2 parameter

Associated drilldown

Application Heap

APPLHEAPSZ

Client Application Analysis

Database Heap

DBHEAP1

Databases

Application Control Heap

APP_CTL_HEAP_SZ

Databases

Lock Manager Heap

LOCKLIST

Databases

Backup/Restore/Utility Heap

UTIL_HEAP_SZ

Databases

Statistics Heap

STAT_HEAP_SZ

Client Application Analysis

Package Cache Heap

pckcachesz

Databases

Catalog Cache Heap

catalogcache_sz

Databases

Query Heap

QUERY_HEAP_SZ

Client Application Analysis

Database Monitor Heap

mon_heap_sz

Database Manager Summary

Statement Heap

stmtheap

Client Application Analysis

FCMBP Heap

fcm_num_buffers2

Database Manager Summary

1 Nearly all buffer pool memory is sized automatically by the Database Manager and is allocated out of database shared memory. This reduces the need for increasing dbheap when buffer pools grow larger.

2 FCM memory requirements are either allocated from the FCM Buffer Pool, or from both the Database Manager Shared Memory and the FCM Buffer Pool, depending on whether or not the partitioned database system uses multiple logical partitions.

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating