beautypg.com

March Products 204 User Manual

Page 49

background image

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

File statistics definitions

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

MODPAGF

Total number of pages in the disk buffer pool currently occupied by

modified FCT pages from the database file. These pages must be

written to disk before they can be flushed from the buffer pool.

MODPAGL

Total number of pages in the disk buffer pool currently occupied by

modified table E pages from the database file. These pages must be

written to disk before they can be flushed from the buffer pool.

MSTRADD

Number of records added to table B. Same as the Model204 MSTRADD

parameter (rate or total).

MSTRDEL

Number of records physically deleted from table B. Same as the

Model204 MSTRDEL parameter (rate or total).

MVFPG

Number of Table A pages used for storing the values from "many

valued" coded fields.

NDPU

The current number of table D pages in use. Same as the Model204

DPGSUSED

parameter.

NPTA

Size of table A in pages. Same as ASIZE.

NPTB

Size of table B in pages. Same as BSIZE.

NPTC

Size of table C in pages. Same as CSIZE

NPTD

Size of table D in pages. Same as DSIZE.

NPTE

Size of table E in pages. Same as ESIZE.

NPTF

Size of FCT in pages.

NRECEXT

Number of extension records currently in table B.

NRECMAS

Number of master records currently in table B.

NRECOVF

Number of records currently in overflow areas in table B.

NRECSPL

Number of records currently in spill areas in table B.

NREQ

Current number of active transactions which reference the file.

NUPD

Current number of active transactions which update the file.

OIDEPTH

Number of Ordered Index B-tree levels (depth of the B-tree).

OILEAFP

Percentage of ordered index leaf pages that contain data. OILEAFP =

100 * (OINBYTS / OILEAVS) / PAGESZ. In general, the higher this

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

SirFile User's Guide

43