SQL/MX 2.x Reference Manual (H06.04+)

MXCI Commands
HP NonStop SQL/MX Reference Manual—540440-003
4-80
Considerations for SHOWLABEL
LastModTimestamp Date, time, and Julian timestamp indicating when the
object’s data was last modified.
LastOpenTimestamp Date, time, and Julian timestamp of last open time.
NEVER OPENED is generated if the object has never
been opened (for example, timestamp=0).
SMDtable Indicates whether the object is a system metadata
(SMD) table. User metadata tables are not SMD tables.
File Organization The file organization of the object (for example,
key-sequenced).
Block Length The length of a block.
File Code File code in the range 550 through 565.
AuditCompress Indicates if compressed audit-checkpoint messages are
generated for Disk Process 2 (DP2) files.
ClearOnPurge Indicates disk erasure when the file is dropped.
Audited Indicates whether the file is audited. If the value is F, a
utility operation is in progress or has failed.
Broken Indicates whether the broken bit is set.
Buffered Indicates whether the file is buffered
CrashOpen The file is in crash-open state.
CrashLabel The file is in crash-label state.
Corrupt The file is corrupt (the contents of the file are in
question). If the value is T, a utility operation is in
progress or has failed.
RollfwdNeeded Roll forward is needed.
RedoNeeded The file cannot be opened, and media recover (redo) is
needed.
UndoNeeded The file cannot be opened, and media recover (undo) is
needed.
IncompletePartBoundChg Indicates whether a partition boundary change is in
progress. If the value is T, a utility operation is in
progress or has failed.
UnreclaimedSpace Indicates whether discarded blocks need to be cleaned
up following a partition boundary change. If the value is
T, a utility operation is in progress or has failed.
Primary Extent Size Size of the primary extent in pages.
Secondary Extent Size Size of the secondary extents in pages.