Using the 'oncheck' utility to check system catalog tables

Using the 'oncheck' utility to check system catalog tables

During this training we demonstrate how to use the 'oncheck' command line utility to provide information for database tables, columns, indexes, views, constraints, stored procedures and privileges from the database system catalog tables.

rate limit

Code not recognized.

About this course

Course Outcome:
The system catalogues consist of tables and views that describe the structure of the database and is typically known as the database 'data dictionary'. At the end of this training you will be able to implement the 'oncheck' command line utility to access the database data dictionary.
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:

Curriculum4 min

  • Using the 'oncheck' utility to check system catalog tables 3 min
  • Feedback
  • Take Course Survey 1 min

About this course

Course Outcome:
The system catalogues consist of tables and views that describe the structure of the database and is typically known as the database 'data dictionary'. At the end of this training you will be able to implement the 'oncheck' command line utility to access the database data dictionary.
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:

Curriculum4 min

  • Using the 'oncheck' utility to check system catalog tables 3 min
  • Feedback
  • Take Course Survey 1 min