|
|
|
The DBUTLTY RETIX function is used to rebuild a disabled, that is, not loaded, or damaged Index Area. This process accesses the data rows and rebuilds each of the index entries.
Typically, index entries become disabled when the database description has been changed and a change to the keys definition, the columns (fields), was made.
Rebuilding the Index Area is typically faster than reloading the data, which includes rebuilding the Index Area. For large database indexes, this could still be a significant time consuming effort.
The CA Datacom/DB has been updated to track what key IDs in the index are disabled, not loaded, or are invalid for some reason. You can now run the DBUTLTY RETIX function with the MINIMAL=YES parameter. This tells the DBUTLTY to only rebuild the invalid index entries.
Business Value
Using the RETIX with MINIMAL=YES can significant reduce the time it takes to rebuild a damaged or invalid index and greatly reduces the time it takes to get a database back online.
Additional Considerations
With multiple data set indexes, the RETIX function needs to be executed against each of the IXX and Inn data sets that have a disabled key ID. RETIX MINIMAL=YES is valid for multiple data set indexes.
| Copyright © 2012 CA. All rights reserved. | Tell Technical Publications how we can improve this information |