NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
F-29
Filesets
The columns FILENAME through RECORDSIZE (1 through 19) were created in
version 1. The column AUDITCOMPRESS (20) was added in version 2. The column
PARTITIONARRAY (21) was added in version 320.
Guardian names in the FILES table are fully qualified and use uppercase characters.
Filesets
A fileset is a set of objects and files specified as a Guardian name that optionally
includes the following wild-card characters in the volume, subvolume, or file-id
portions of the name:
*VOL* matches NEWVOL, OLDVOL1, VOL45, and so forth.
13 SERIALWRITES CHAR(1) Y if serial mirror writes
N if parallel
14 VERIFIEDWRITES CHAR(1) Y if disk read follows each disk write
N if not
15 BUFFERED CHAR(1) Y if writes to disk are buffered
N if not
16 NOPURGEUNTIL LARGEINT
SIGNED
Julian timestamp of earliest time file can
be purged; 0 if file can be purged any
time
17 EOF INTEGER
SIGNED
Relative byte address of first unused
byte of last block in partition or file;
updated by UPDATE STATISTICS
18 NONEMPTYBLOCKCOUNT LARGEINT
SIGNED
Number of blocks that contain at least
one row of data; updated by UPDATE
STATISTICS
19 RECORDSIZE SMALLINT
SIGNED
Maximum length of packed record
20 AUDITCOMPRESS CHAR(1) Y if AUDITCOMPRESS
N if not
21 PARTITIONARRAY CHAR (30) STANDARD if the type of partition
array is that used by default
EXTENDED if the type of partition
array is extended and supports additional
partitions
? matches any single character.
For example, TBL? matches TBL1 or TBLX but not TBL48.
* matches any 0 to 8 characters.
For example, * matches any 0 to 8-character name.
Column Name Data Type Description
* Indicates primary key