SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013

F-7

File Attributes of SQL Objects

ALLOCATE Controls amount of disk space allocated. Default is to allocate

space as needed.

AUDIT Controls TMF auditing. Default is AUDIT.

AUDITCOMPRESS Controls whether unchanged columns are included in audit

records. Default is to include only changed columns.

BLOCKSIZE Sets size of data blocks. Default is 4096.

BUFFERED Turns buffering on or off. Default is on.

CLEARONPURGE Controls disk erasure when file is dropped. Default is no

erasure.

DCOMPRESS Controls key compression in data blocks. Default is no

compression.

DSLACK Sets percent of slack in data blocks. Default is value of the

SLACK attribute.

EXTENT Sets extent sizes. Default is 16 pages for the first extent, 64 for

others.

FORMAT Controls whether a partition is Format 1 or Format 2.

ICOMPRESS Controls key compression in index blocks. Default is no

compression.

ISLACK Sets percent of slack in index blocks. Default is value of the

SLACK attribute.

LOCKLENGTH Sets number of bytes in key to use for generic locks. Default is

entire key.

MAXEXTENTS Sets maximum extents. Default is 160.

NOPURGEUNTIL Sets date after which drop is allowed. Default allows immediate

drop.

OWNER Specifies owner. Default is creator.

PROGID Determines the PAID of a process started from the file. Default

is NO PROGID.

RECLENGTH Sets bytes reserved for a relative-file row. Default is total

column lengths.

RESETBROKEN Resets BROKEN flag. No default.

SECURE Sets Guardian security string. Default is creator's default

security string.

SERIALWRITES Specifies serial or parallel writes. Default is SERIALWRITES.