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.

Copyright© 2018 HCL Technologies Limited