The optional TARGETROOT parameter pertains only to variable length records stored CALC or as members of a sorted VIA set. It allows you to control the degree of fragmentation of these types of records if fragmentation is necessary.
Indicates that for CALC and sorted VIA records, CA IDMS/DB Reorg stores the record's root on the target page and fragment the rest of the record when the entire record will not fit on the target page. Minimally, the root is as large as the minimum ROOT defined in the new subschema and as large as can fit on the target page. This applies only to variable-length records.
TARGETROOT keeps the record's key on the target page, which makes it possible for CA IDMS to search the CALC or sorted set without having to access other database pages. This reduces the number of I/Os when the CALC or sorted VIA set is being searched.
|
Copyright © 2014 CA.
All rights reserved.
|
|