Waits             (VSAM)

DESCRIPTION
"Waits" represent the number of times application programs have to wait for a 
record of a particular "Dataset" because another application program has already
obtained the record.


VALUES
Sun MTP initializes the number of "Waits" to zero at system initiation. Sun MTP
increments the number upon every record contention for a particular dataset.


INTERPRETATION
A large number of "Waits" indicates that many user transactions are accessing 
the same data for a particular "Dataset".  This could indicate a possible 
database design problem.


CONCLUSIONS
When application programs must wait on a resource, like a record in a dataset, 
the entire application's performance degrades. If the application's performance
appears to slump after reaching a certain transaction rate, analyze the "Waits"
value to see if the number is increasing. If so, there may be a database design 
flaw or it just may be that a bad mix of application programs are running at the
same time. They may all be trying to access the same records in the same 
"Dataset".
