-
Using the 'oncheck' utility to verify the integrity of a table data. 6 min
- Feedback
-
Take Course Survey 1 min
Using the 'oncheck' utility to verify the integrity of a table data.
In this training session, we illustrate the utilization of the 'oncheck' command line utility to verify the integrity of data within a table, ensuring that no data inconsistencies have occurred. If any irregularities are detected, they must be rectified using either the oncheck utility's provided mechanisms or through a manual process.
Course Outcome:
The presence of inconsistent data in a table is likely to result in suboptimal access to the table data. A proficient Database Administrator (DBA) actively monitors the performance of the corporate database and takes a proactive approach by executing scripts to assess performance. By employing the oncheck command along with the specified parameters demonstrated in this video, your DBA will obtain the necessary information to verify the consistency of table data, ensuring an optimized database performance.
Course Style:
The training is provided in a step by step style providing you with best practice advice and guidance.
Audience:
For System or Database Administrators who have responsibility for maintaining the Corporate OneDB database estate.
Prerequisites:
- You are using the minimum version of Database software which is: OneDB 2.0.1.3 and/or HCL Informix 14.10.FC10
- You have a basic understanding of a OneDB installation
Supplementary Resources:
|
Product Documentation:
|
|
|
Actian Community:
|
|
|
Software Download:
|