File Waits        (Overview)

DESCRIPTION
The number of "File Waits" represents the number of times application programs
have had to wait for a record in a dataset.  


VALUES
This value starts at zero and is incremented each time a transaction has to wait
for a dataset record.


INTERPRETATION
As application programs access records in a database, there may be times when 
one application program is accessing a particular record within the database and
another program requests the same record. When this situation occurs, the second
application program must wait until the first application program releases the 
record in question.


CONCLUSIONS
A large number of "File Waits" indicates that many user transactions are 
accessing the same records in the database. This could be a potential database 
design problem.
