NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
F-23
Examples—FILEINFO
Examples—FILEINFO
For the following examples, assume that the subvolume $VOL1.INVENT contains only
catalog files and the following files and that all SQL objects are defined in the catalog
$VOL1.INVENT:
•
The following command displays information for all the objects on
$VOL1.INVENT (including the catalog tables) in the default BRIEF format:
>> FILEINFO $VOL1.INVENT.*;
CODE EOF LAST MODIF OWNER RWEP TYPE REC BLOCK
$VOL1.INVENT
BASETABS 572A 12288 3Jan93 11:53 1,205 NCNC K Ta 90 4096
COLUMNS 575A 32768 3Jan93 11:53 1,205 CCCC K Ta 206 4096
COMMENTS 582A 12288 3Jan93 11:53 1,205 CCCC K Ta 202 4096
CONSTRNT 580A 0 3Jan93 11:52 1,205 CCCC K Ta 3068 4096
ESTABLE 10 8192 1Feb93 12:30 1,74 GUUU E Ta 80 2048
...
PARTLOC O A 16384 1Feb93 9:45 1,74 GUUU PK Ta 12 4096
PARTLOCI O A 16384 1Feb93 9:45 1,74 GUUU K In 14 4096
PROG12 100P 19386 9Jan93 14:12 1,74 NUNU Pg
PROGRAMS 581A 12288 3Jan93 11:53 1,205 CCCC K Ta 3096 4096
PVIEW 1,74 NNUU P PVi
SVIEW 1,74 GUUU SVi
...
PART For partitioned files, the volume name of the partition
associated with the entry.
FREE TOTAL BLOCKS For key-sequenced files, the total number of unused blocks
from the beginning to the EOF.
FREE TOTAL RECS For relative files, the total number of empty records from the
beginning to the EOF.
BITMAP TOTAL
BLOCKS
For relative and key-sequenced files only, the number of
bitmap blocks.
ESTABLE An unpartitioned, entry-sequenced table
PARTLOC A partitioned, key-sequenced table
PARTLOCI An index defined on PARTLOC
PVIEW A partitioned protection view that depends on PARTLOC
PROG12 An SQL object program file
SVIEW A shorthand view