SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
F-12
BRIEF Display for SQL Objects and Guardian Files
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.
F
An ALTER TABLE or ALTER INDEX operation using
the WITH SHARED ACCESS option left unreclaimed
free space on disk.
To recover the free space, issue a FUP
RELOAD command.
For more information about FUP
RELOAD, see the File Utility Program (FUP)
Reference Manual.
S File is a shadow label, a temporary file label for an object that
has been dropped which exists until the transaction is
committed, aborted, or rolled back, or until a TMF file recovery
is performed. (Shadow labels are not listed if the fileset is
qualified by a catalog name.)
? File is in the crash-open or crash-label state. A file is in the
crash-label state if a file label operation was taking place at the
time of a total system crash or when the disk on which the file
is located becomes unavailable. A file is in the crash-open state
if it was open in the same circumstances. (Only the crash-label
state applies to views.)
blank File is not open, crashed, or broken.
CODE The file code, or “OSS” for an OSS file. The default Guardian file code of
0 is not displayed.
Guardian file codes 100 through 999 refer to specific types of files and are
reserved by the HP NonStop operating system. For the meanings of
reserved file codes, see the description of the FUP INFO command in the
File Utility Program (FUP) Reference Manual.
Letters that follow the file code have specific meanings:
A File is audited by the TMF subsystem.
L File is licensed by the super ID.
P PROGID security attribute of the file is on.
+ This partition is Format 2. If blank, this partition is Format 1.
EOF The number of bytes in the file. (Not used for views.)
LAST MODIF The date and time when the file was last modified. If the last modification
date is the current date, only the time of day is given. (Not used for views.)
OWNER The user ID of the file's owner.
RWEP The security string for the file.
Table F-1. FILEINFO BRIEF Display Information Line (page2of3)
Open State The open state of the file is described by one or more of these codes: