SQL/MP Reference Manual
HP NonStop SQL/MP Reference Manual—523352-013
F-23
Examples—FILEINFO
This 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
...
This command displays DETAIL information for the file PARTLOC:
>> FILEINFO $VOL1.INVENT.PARTLOC, DETAIL;
$VOL1.INVENT.PARTLOC 13 Jun 1995, 12:32
SQL BASE TABLE
CATALOG $VOL1.INVENT
VERSION 1
TYPE K
FORMAT 1
EXT ( 16 PAGES, 64 PAGES, MAXEXTENTS 160 )
REC 10
PACKED REC 9
BLOCK 4096
KEY ( COLUMN 0, OFFSET 0, LENGTH 3, ASC,
COLUMN 1, OFFSET 4, LENGTH 2, ASC )
PART ( 0, $VOL1, 16 PAGES, 64 PAGES, MAXEXTENTS 160, FORMAT 1, ([0],0) )
PART ( 1, $WHS2, 16 PAGES, 64 PAGES, MAXEXTENTS 160, FORMAT 1, ("G00",0))
AUDIT
BUFFERED
AUDITCOMPRESS
OWNER 1,74
SECURITY (RWEP): GUUU
MODIF: 12 Jun 1995, 20:12
CREATION DATE: 10 Jun 1995, 20:01
REDEFINITION DATE: 12 Jun 1995, 20:01
LAST OPEN: 13 Jun 1995, 18:44
EOF 12288 (0.1% USED)
EXTENTS ALLOCATED: 1
INDEX LEVELS: 1
PARTITION ARRAY EXTENDED
If you request the STATISTICS display, the additional information appears below
EXTENTS ALLOCATED instead of the INDEX LEVELS:
TOTAL TOTAL AVG # AVG AVG %
LEVEL BLOCKS RECS RECS SLACK SLACK PART
1 1 1 1.0 4065 99 $VOL1
DATA 1 15 15.0 3899 95
FREE 0
BITMAP 1
1 1 1 1.0 4065 99 $WHS2
DATA 1 31 31.0 3723 89
PVIEW A partitioned protection view that depends on PARTLOC
PROG12 An SQL object program file
SVIEW A shorthand view