SQL/MP Installation and Management Guide

Querying SQL/MP Catalogs
HP NonStop SQL/MP Installation and Management Guide—523353-004
6-14
Using FILCHECK to Check Structural Consistency
Using FILCHECK to Check Structural Consistency
The FILCHECK utility checks the physical structure of a DP2 structured object and
reports any errors. The internal checks include:
•
Forward and backward pointers in blocks
•
Relative sector number and checksum of every block
•
Correct index levels
•
Data block and index block linkage and length
•
Block headers and rows in relative files
•
Offset pointers and order
FILCHECK does not correct any errors in the physical structure. If errors are detected,
you might want to use TMF file recovery to recover the object. Alternatively, contact
your service provider for other possible recovery methods. If you contact the Global
Customer Support Center (GCSC), have your FILCHECK output available and
determine whether full TMF recovery is a possibility.
You can request that the file information be displayed in brief format (a condensed
summary format) or in the detailed standard format.
This example shows a brief format listing for the EMPLOYEE table from the catalog
$VOL1.PERSNL:
14> FILCHECK $VOL1.PERSNL.EMPLOYEE, BRIEF ;
@@@@ CHECKING $VOL.PERSNL.EMPLOYEE
Time: 18:36:57 3/28/89
This is an audited table
SQL root table
SQL integrity constraints present.
Key-Sequenced file
>Begin Summary Report.
Data blocks checked : 5
Data records checked : 190
Index blocks checked : 1
Index records checked : 5
Free block checked : 0
Bitmap blocks checked : 1
Soft bitmap errors : 0
>End of summary report.