SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
F-18
DETAIL Display for Objects (Except Views) and
Guardian Files
If a file uses multibyte characters, the FIRST KEY value might contain characters
unsupported by your terminal, causing unpredictable results in the screen display.
15. This section describes file attributes and flags:
16. OWNER is the user ID of the file's owner. This section also displays the security
string of the file, indicates whether the PROGID and CLEARONPURGE attributes
are set, and indicates the time after which you can purge the file. LICENSE
indicates a licensed file; asterisks (*) indicate a file protected by the Safeguard
security product.
17. SECONDARY PARTITION indicates the file is a secondary partition.
ODDUNSTR Enscribe odd unstructured file.
REFRESH File label is updated when file control block
changes.
AUDIT File is audited.
BUFFERSIZE Default internal transfer size of unstructured
file.
BUFFERED Writes to file are buffered.
AUDITCOMPRESS Compressed audit-checkpoint messages are
generated for files.
VERIFIEDWRITES Writes to file are verified.
SERIALWRITES Serial mirror writes are done.
INCOMPLETE SQLDDL
OPERATION
An ALTER TABLE or ALTER INDEX operation
with the WITH SHARED ACCESS option is in
process or has failed. If the operation has
completed and the flag remains, recovery is
needed. To recover the file, use the
PARTONLY RECOVER INCOMPLETE
SQLDDL OPERATION option for the ALTER
TABLE or ALTER INDEX statement, then do a
FUP RELOAD operation. For more information
about FUP RELOAD, see the File Utility
Program (FUP) Reference Manual.
UNRECLAIMED FREESPACE A DDL operation with 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.