DSNT783I DBID PSID DBNAME IX-SPACE LVL PART SIZE(KB)

The DSNT783I message displays output from the DISPLAY STATS(INDEXMEMORYUSAGE) command. The output provides the following information about indexes for which fast index traversal (FTB) is being used:

DBID  PSID  DBNAME   IX-SPACE LVL PART SIZE(KB)
----- ----- -------- -------- --- ---- --------
00279 00005 DB1      IX1      003 0001 00000816
******* DISPLAY OF STATS ENDED **************

The lines of output are in descending order, from the index that uses the largest amount of memory for fast index traversal, to the index that uses the smallest amount of memory for fast index traversal.

DBID

The internal identifier of the database that contains the index.

PSID

The page set descriptor of the index space.

DBNAME

The name of the database that contains the index.

IX-SPACE

The name of the index space.

LVL

The number of index levels in the index for which fast index traversal is being used. The FTBs (fast traverse blocks) for fast index traversal contain information for root and non-leaf index pages, but not for leaf pages.

PART

The index partition number.

SIZE(KB)

The amount of memory that is used for fast index traversal, in kilobytes.

When n partitions of an index have identical memory usage statistics, a line is displayed for the first partition, and lines for the rest of the partitions are omitted from the output. Those lines are replaced with the following output:

-THRU n

n is the number of the last partition with identical memory usage statistics.

The output continues or ends with the following message:

******* DISPLAY OF STATS status ***********************************

status

Possible values are:

CONTINUED

Indicates that more information will be displayed.

TERMINATED

Indicates that all information has been displayed.