DB2:getDictionaryInfo

View a report of the dictionary information of tables in the specified schema.

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

Returns

Name

Type

Description

Table Name

String

Table Name

Schema Name

String

Schema Name

Table Name

String

Table Name

Object Type

String

The type of the object. Output can be one of the following values: 'XML', 'DATA'

Partition

Big Integer

Database partition number.

Compressed?

String

The state of the COMPRESS attribute on the table which can be one of the following values: 'Y' = Row compression is set to yes, 'N' = Row compression is set to no

Dictionary Size

Big Integer

Total physical size of the dictionary in bytes.

Sampled Row Count

Integer

Number of records that contributed to building the dictionary.

Percent Saving in Pages

Integer

Percentage of pages saved from compression.

Percent Saving in Bytes

Integer

Percentage of bytes saved from compression.

Avg Compressed Record

Integer

Average compressed record length of the records contributing to building the dictionary.

Usage Notes

Invoking this method displays summarized information of the dictionary of tables in the database used.