DB2:getSpaceUsage

Get tablespace usage information.

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

Schema Name

String

Schema Name.

Table Name

String

Table Name

Returns

Name

Type

Description

Schema Name

String

Name of the operating system.

Table Name

String

Version number of the operating system.

Table Type

String

Release number of the operating system.

Partition

String

Host Name

Availability

String

Total number of physical CPUs on the system.

Occupied Size

String

Number of configured physical CPUs on the system.

Index Type

Big Integer

Total amount of memory on the system (in megabytes).

Load Status

Integer

Current status of a load operation against the table. The status can be one of the following values: IN_PROGRESS, NULL, PENDING

Dictionary Size

String

Size of the table dictionary, in bytes, used for row compression if a row compression dictionary exists for the table. If a historical dictionary exists, this value is the sum of the current and historical dictionary sizes.

Usage Notes

Invoking this method displays summarized information about tablespace usage with respect to size and other characteristics.