The -cc option checks all system catalog tables for the specified database. If you do not specify a database, it checks all system catalog tables for all databases. Before you execute oncheck, execute the SQL statement UPDATE STATISTICS to ensure that an accurate check occurs.
To check a table, oncheck compares each system catalog table to its corresponding entry in the tblspace. (See Structure of the Tblspace Tblspace.) The -pc option performs the same checks and also displays the system catalog information, including the physical address, type of locking used, row size, number of keys, extent use, the number of pages allocated and used, tblspace partnum, and index use for each table.
oncheck -cc oncheck -cc superstores_demoHome | [ Top of Page | Previous Page | Next Page | Contents | Index ]