SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
F-21
BRIEF and DETAIL Display for OSS Files
LABEL QUESTIONABLE, DEFINITION INVALID, REDO NEEDED, and UNDO
NEEDED are open states. See the description of the MODIF field of the DETAIL format
for tables, indexes, collations, and Guardian files in the preceding list (item 17).
BRIEF and DETAIL Display for OSS Files
For OSS files, both the BRIEF and DETAIL displays include the ZYQ name, the
pathname (wrapped over multiple lines, if necessary), the code (OSS), the EOF
location, the last modification date, the owner, and the OSS security information.
FILEINFO displays the owner and security information beneath the pathname for the
file, because it occupies more space in the display than the corresponding Guardian
security information
In the BRIEF display, the display heading line is identical to the one for Guardian files,
because only one heading line appears in the display, although the display can include
both types of files. The headings match the columns for Guardian files, not OSS files.
Not all headings apply to OSS files.
The DETAIL display for OSS files also includes the creation date and the last open
date. Other fields described for the DETAIL FILEINFO display for Guardian files do not
apply to OSS files.
EXTENTS Display
This figure shows the EXTENTS display.
The first line in the EXTENTS display is the same as the first line in the DETAIL display
for tables, indexes, and Guardian files. The other fields are:
file-name date-and-time
EXTENT # OF PAGES STARTING PAGE [ PART ]
extent-num num-pages start-page [ name ]
...
extent-num The ordinal extent number of the entry. The first extent is 0. NONE
indicates no extents are allocated.
num-pages The number of disk pages (2048-byte units) in the extent.
start-page The absolute page address of the first page of the extent.
name For partitioned files, the partition name associated with the entry.