NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
F-13
BRIEF Display for SQL Objects and Guardian Files
F An ALTER TABLE or ALTER INDEX
operation using the WITH SHARED
ACCESS option left unreclaimed free space
on disk, run FUP RELOAD. 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 NonStop kernel.
See the description of the FUP INFO command in the
File Utility Program (FUP) Reference Manual for the
meanings of reserved file codes.
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.
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.
TYPE A six-character code that identifies the file type and
SQL object type in the following form:
Character positions -> 1 2 3 4 56