SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
F-19
DETAIL Display for Objects (Except Views) and
Guardian Files
18. This section lists dates and times of file activity. MODIF indicates when the file was
last modified and one of more of these open states, if applicable:
For more information, see the discussion of the Open State field under BRIEF
Display for SQL Objects and Guardian Files on page F-11.
19. For unstructured files, EOF is the end-of-file pointer containing the relative
byte address of the byte after the last significant data byte.
For structured files, EOF is the relative byte address of the first byte of the next
available block.
percent-used is the percent of available file space currently used based on
available space if all extents are allocated.
20. EXTENTS ALLOCATED is the number of extents currently allocated. This
information is supplied only for Guardian files.
21. For key-sequenced files, INDEX LEVELS indicates the number of index levels
used for index blocks.
BROKEN File is marked as broken.
CORRUPT Error occurred during a utility operation such as
restoring or duplicating.
DEFINITION INVALID Data or definition of the object is invalid.
LABEL
QUESTIONABLE
File is in a crash-label state.
OPEN File is open.
QUESTIONABLE File is in a crash-open state.
RECOVERY NEEDED File cannot be opened; volume recovery is needed
(TMF2 files only).
REDO NEEDED File cannot be opened; TMF redo file recovery is
needed.
UNDO NEEDED File cannot be opened; TMF undo file recovery is
needed.
CREATION DATE Indicates the date the table or index was created.
REDEFINITION TIME Indicates when a change to the table or index caused
an SQL program to be recompiled.
LAST OPEN Indicates the last time the table or index was opened.