A table-specific disk I/O integrity checksum for detection of hardware read errors. The checksum level setting applies to primary data rows, fallback data rows, and all secondary index rows for the table.
For a system-defined join index, the integrity checking setting you specify for a base table also applies to any system-defined join indexes defined on that table. You cannot specify integrity checking for a system-defined join index directly.
If you do not specify a value, the system assumes the system-wide default value for this table type. This is equivalent to specifying DEFAULT.
The HIGH, MEDIUM, LOW settings are deprecated and are equivalent to
specifying ON.
- ON
- Calculate checksums using the entire disk block. Sample 100% of the disk blocks to generate a checksum. ON is equivalent to ALL, which is deprecated.
- OFF
- Disables checksum disk I/O integrity checks. OFF is equivalent to NONE, which is deprecated.
- DEFAULT
- The default setting is the current DBS Control checksum setting specified for this table type.