Analyzing the Data Set Characteristics Report

If a file has a high EXCP count on either data or index portions, check the I/O Facility Usage report to get a further breakdown of access by unit and volume. If a file has CI or CA splits, consider increasing FREESPACE percentages.

If a sequential file has many EXCPs to its data portion, and few buffers, consider increasing data buffers or blocksize. If it also has high EXCPs to its index portion, the index CA size might be too small to accommodate sufficient pointers to the data. The SPACE parameter in the JCL controls index CA size. VSAM uses the smaller of the primary and secondary allocations (with a maximum of 1 cylinder) for the Index CA size.

If the access method for a data set is QSAM and the number of buffers is 5, you are using the default number of buffers for a QSAM file. This is normally not as efficient as is possible. Increase the number of buffers to 15 or 20 and remeasure. You should see a reduction in the number of physical I/Os and a decrease in the wait time for the file. The optimum number of buffers varies depending on your individual situation.

If the access method for a data set is VSAM INDX, and OPEN INTENT includes DYN or DIR, for optimum performance, ensure that you have allocated enough buffers to the index component. The minimum number of buffers you should allocate for an index component is the number of index levels plus one. You can determine the number of index levels by clicking the icon to the left of the file name.

If a randomly-accessed file has many EXCPs to its index portion, and few buffers, consider increasing index buffers.

For information on data set activity, review this and other reports that give data set information in addition to ddname information.

Because of the complexity of managing VSAM and DASD access, consult with your site's specialists on the results of your measurements and possible changes to your applications.