NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
F-12
BRIEF Display for SQL Objects and Guardian Files
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 NonStop
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 the following,
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 the following,
[\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 follows:
Open State The open state of the file is described by one or more
of the following codes:
B File is marked broken due to 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 NonStop TM/MP
Operations and Recovery Guide.
D An ALTER TABLE or ALTER INDEX
operation using the WITH SHARED
ACCESS option did not complete
successfully. To recover, use the RECOVER
INCOMPLETE SQLDDL OPERATION
option for the ALTER TABLE or ALTER
INDEX statement, followed by a FUP
RELOAD operation. For more information,
see the ALTER TABLE or ALTER INDEX
command or the WITH SHARED ACCESS
option.