Static Hash Screen

The name of the DBEFileSet.

The keyword DETACHED means that the DBEFileSet is detached. The keywords DETACHED DBEFILES mean that the DBEFileSet is attached, but some of the DBEFiles within it are detached.

The name of each hashed table in the DBEFileSet.

The number of primary pages allocated for the hash structure. This value is equivalent to the PRIMPAGES column of SYSTEM.HASH and is specified by the UNIQUE HASH clause of the CREATE TABLE statement.

The number of primary pages that currently contain table data. This value is equivalent to the NPAGES column of SYSTEM.HASH.

The number of primary pages containing table data that have overflow pages. This value is equivalent to the NOVERFLOW column of SYSTEM.HASH.

The number of overflow pages allocated for the hash structure.

The maximum and average lengths of the overflow chains, displayed graphically. The maximum length is represented by full bright, inverse video bars. The average length is indicated by half bright, inverse video bars and is delimited on the right with an asterisk.

The length of the longest overflow chain in the table. This value is one less than the MAXLEN column of the SYSTEM.HASH pseudotable, because MAXLEN includes the primary page in the chain length.

The average length of the overflow chains, calculated as follows:

   AVGOVERFLOW = round (OVERPAGES / PRIMOVERF)