beautypg.com

March Products 204 User Manual

Page 45

background image

——————————————————————————————————————————

File statistics definitions

——————————————————————————————————————————

CFRCDEX

Conflicts on the "DIRECT" and "EXISTS" critical file resources (rate or

total). Equal to CFRCDIR+CFRCEXS.

CFRCDIR

Conflicts on the "DIRECT" critical file resource (rate or total). This

resource protects the integrity of Table B.

CFRCEXS

Conflicts on the "EXISTS" critical file resource (rate or total). This

resource protects the integrity of the existence bit map.

CFRCIND

Conflicts on the "INDEX" critical file resource (rate or total). This

resource protects the integrity of the database indexes.

CFRCONF

Conflicts on all critical file resources (rate or total).

CFRCREC

Conflicts on the "RECENQ" critical file resource (rate or total). This

resource protects the integrity of the record enqueuing tables.

CFRQDEX

Number of users waiting for either the "DIRECT" or "EXISTS" critical file

resource. Equal to CFRQDIR+CFRQEXS.

CFRQDIR

Number of users waiting for the "DIRECT" critical file resource. This

resource protects the integrity of table B.

CFRQEXS

Number of users waiting for the "EXISTS" critical file resource. This

resource protects the integrity of the existence bit map.

CFRQIND

Number of users waiting for the "INDEX" critical file resource. This

resource protects the integrity of the database indexes.

CFRQREC

Number of users waiting for the "RECENQ" critical file resource. This

resource protects the integrity of the record enqueuing tables.

CFRQUEU

Number of users waiting for any critical file resource.

COMMITS

Number of committed update units since the file was opened. The stat

begins incrementing when the file is first opened, and is reset to 0 when

the last user closes it. If the file is reopened the incrementing begins

again from 0. (rate or total.)

CSIZE

Size of table C in number of pages.

DFULLP

Percentage of table D that is full. This statistic is equal to the number of

table D pages currently in use (DPGSUSED) divided by the total number

of table D pages (DSIZE).

DHIGHPG

The current table D high water mark. Same as the Model204 DHIGHPG

parameter.

DIRRCD

Number of records scanned in direct searches (rate or total).

——————————————————————————————————————————

SirFile User's Guide

39