File Utility Programming (FUP) Reference Manual

FUP Commands
File Utility Program (FUP) Reference Manual—523323-015
2-89
INFO
EXTENTS
provides a listing of extent allocation by file (except SQL/MP and SQL/MX views).
If specified, views are skipped.
STAT[ISTICS]
provides all the DETAIL information and statistical data on blocks and records for
Enscribe-structured files, SQL/MP and SQL/MX tables, and indexes. Statistics
information does not appear for unstructured Enscribe files, SQL/MP and SQL/MX
program files, views, or shadow labels.
PARTONLY
limits the information to any partitions that you specify explicitly in
fileset-list. For example, if you specify only a secondary partition of an
SQL table, statistical information about the primary partition (or any other
secondary partition) does not appear.
PARTONLY is implied (for Enscribe files) if you specify a secondary partition
because secondary partitions do not contain information about other partitions.
If you omit PARTONLY and specify the primary partition of an Enscribe file (or
specify any partition of an SQL/MP and SQL/MX object), the STAT[ISTICS]
option provides information about all partitions of the file.
PARTIAL num
specifies the percentage of the file used (read) to generate the statistics. You
specify the percentage (num) of the file (from 0 through 100) that FUP reads
and analyzes.
If PARTIAL is not specified (or if num is 0 or 100), FUP reads all the file.
Because FUP reads the file in increments of 56 KB, the actual percentage
used might be higher than the percentage requested.
USER
restricts the display to files in fileset-list owned by the user identified by
groupnum,usernum or by groupname.username. If you include USER but omit
groupnum,usernum and groupname.username, the display is restricted to the
files in fileset-list that you own.
Note. The DETAIL information is not provided if the CONFIG STATONLY option is
specified. For more information, see CONFIG[URE]
on page 2-28.
Note. Super-group users (255, n) do not have automatic access to OSS files.