Teradata Database, as we know, provides a layer of security to your data, and to maintain its integrity it provides various tools for our disposal. One such utility is scandisk, which helps in checking filesystem errors on the cylinder.Â
Let's understand it as a Windows defragment tool provided on any Windows machine. It runs through the system data file structure and finds inconsistencies within it. In this figure (only for representation purposes), the highlighted squares are the sector are being scanned and the unhighlighted ones are getting ready to be scanned:
Any table or sector reported to have inconsistencies should be rebuilt using the table rebuild utility, and Teradata site engineers should be notified.Â