March Products 204 User Manual

Page 44

Advertising
background image

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

File statistics definitions

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

BREUSED

The number of records added to the file that reused the record number

of a previously deleted record. Same as the Model204 BREUSED

parameter.

BSIZE

Size of table B in number of pages.

BUFPAGA

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

A pages from the database file.

BUFPAGB

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

B pages from the database file.

BUFPAGC

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

C pages from the database file.

BUFPAGD

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

D pages from the database file.

BUFPAGE

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

pages from all tables in the database file. Equal to BUFPAGA +

BUFPAGB + BUFPAGC + BUFPAGD + BUFPAGF + BUFPAGL.

BUFPAGF

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

pages from the database file.

BUFPAGL

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

Table E pages from the database file.

BXCHNG

New segments of records starting or local lists deleted in the ordered

index (rate or total).

BXDELE

Removals from tree structure in the ordered index. (rate or total).

BXFIND

Searches to locate FIELD NAME = VALUE pairs in the ordered index

(rate or total).

BXFREE

Nodes emptied in the ordered index (rate or total).

BXINSE

New records inserted with an unused FIELD NAME = VALUE pair in the

ordered index (rate or total).

BXNEXT

FIELD NAME = VALUE pairs touched in the ordered index during range

retrievals (rate or total).

BXRFND

Calls for range retrieval from the ordered index (rate or total).

BXSPLI

Node splits in the ordered index (rate or total).

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

38

SirFile User's Guide

Advertising