Use the ALTER DATAFS option when you want to enable the DATA FAST SEARCH feature.
Previously, each data area that contained a single table that was not compressed was searched for a record using a binary search. The ability to do the binary search was turned on at data load time if a physical block could contain 15 or more data rows. Otherwise, the blocks were searched in a sequential physical order. For large block sizes with small records, such a sequential search could become a significant percentage of MUF CPU usage. Using DATAFS, however, the last 16 bytes of each data block is used by the search algorithm to provide a faster method of finding individual data rows, especially for large block and small row sizes. Once created, these 16 end bytes are stored on DASD with the data.
Reporting DATAFS in Full CXX Report
A full CXX report includes information on DATA FAST SEARCH status, where status in the report is either YES or NO.
Security Considerations
This functions is secured in the DTUTIL resource class with a resource name ending in CXXMAINT.ALTEROP2. See the DBUTLTY Resource List section of the CA Datacom Security Reference Guide for details. No underlying table rights are checked.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|