SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
F-11
Considerations—FILEINFO
Considerations—FILEINFO

FILEINFO without the STATISTICS option has no authorization requirements. With
the STATISTICS option, FILEINFO requires read authority for the files for which
information is displayed.

FILEINFO returns error -9132 if it encounters an SQL object (but not an SQL
program or catalog) that has a version greater than the version of the SQL/MP
software on the node from which you issued the FILEINFO command. Use a later
version of FILEINFO (that is, a later version of NonStop SQL/MP) to display
information about such an object.
FILEINFO returns error -9133 if it encounters an SQL object (but not an SQL
program or catalog) that has a version greater than the version of the SQL/MP
software on the node on which the object resides. No version of FILEINFO can
access such an object, which might exist because of a fallback situation.
BRIEF Display for SQL Objects and Guardian Files
The BRIEF display for SQL objects and Guardian files includes three types of lines:

A heading line, such as,
CODE EOF LAST MODIF OWNER RWEP TYPE REC BLOCK

A line that names the node, volume, and subvolume for the files that follow in the
report, such as,
[\node.]$volume.subvol

An information line that provides information about a specific file.
The information line begins with the unqualified name and the open state of the table,
index, collation, or file. The remainder of the line includes information that corresponds
to each of the fields in the heading line, as described in Table F-1.
:
Table F-1. FILEINFO BRIEF Display Information Line (page1of3)
Open State The open state of the file is described by one or more of these codes:
B File is marked broken because of a detected inconsistency in
the file structure. (Not used for views.)
C Either the data or the definition of the object is corrupt. (DETAIL
display shows which one is corrupt.)
O File is open. (Not used for views.)
R Recovery is needed. See the TMF Operations and Recovery
Guide.