The oncheck Utility
Use the oncheck utility to check specified disk structures for inconsistencies, repair inconsistent index structures, and display information about disk structures.
The oncheck utility
requires sort space when examining an index. The amount of sort space
required is the same as that needed to build the index. For information
about calculating the amount of temporary space needed, see Estimating temporary space for index builds. If you receive the error "no
free disk space for sort," you must estimate the amount of
temporary space needed and make that space available.
You can use SQL administration API commands that are equivalent to some oncheck commands.