DB2:getMemoryPoolInfo

Retrieves metrics from the memory pools contained within a memory set.

Note: This method can be used IF-AND-ONLY-IF you have access and privileges to execute SYSPROC database objects.

Type

SYNC, IMPACT_INFO

Arguments

Name

Type

Description

Database Name

String

Database Name.

Returns

Name

Type

Description

Host Name

String

Host Name

Database Name

String

Database Name.

Set Type

String

Set Type is one of: DBMS ==> Database Manager Memory Set, FMP ==> Fenced Mode Process Memory Set, PRIVATE ==> Private Memory Set, DATABASE ==> Database Memory Set, APPLICATION ==> Application Memory Set, FCM ==> Fast Communication Manager Memory Set, NULL ==> All sets at instance and database level.

Pool Type

String

Memory pool type.

Memory Pool Used (Bytes)

Big Integer

Amount of memory pool in use.

High Water Mark (Bytes)

Big Integer

Memory pool high water mark.

Usage Notes

Invoking this method returns information about the memory pool in a memory set.