IBM 000-8697 Using the tbcheck Commands tbcheck -cr, tbcheck -cc, tbcheck -ce

Data Consistency, Recovery, and Migration 4-7
Using the tbcheck Commands
tbcheck -cr
Executetbcheck -cr to validate the OnLine reserved pages that reside at the
beginning of the initial chunk of the root dbspace. These pages contain the
primary OnLine control information. If this command detects errors (not
warnings),perform a data restore from archive. (Refer to page 2-95 for more
details about the reserved pages.)
tbcheck -cc
Executetbcheck -cc to validate the system catalog for each of the databases
thatOnLine manages. Each database contains its own system catalog, which
contains information on the database tables, columns, indexes, views,
constraints, stored procedures, and privileges.
Ifa warning appears after you execute tbcheck -cc, its only purpose is to alert
you that no records of a specific type were found. These warnings do not
indicateany problem with your data, your system catalog, or even with your
database design. For example, the following warning might appear if you
executetbcheck -cc on a database that has no synonym names defined for
any table:
WARNING: No syssyntable records found.
Thismessage indicates only that no synonym exists for any table; that is, the
system catalog contains no syssyntable records.
However, if an error message is returned fromtbcheck -cc, the situation is
quitedifferent. To correctthe situation, you must perform a data restore from
archive.
tbcheck -ce
Executetbcheck -ce to validate the extents in every OnLine database. It is
important that extents do not overlap. If this command detects errors,
perform a data restore from archive.