File Utility Programming (FUP) Reference Manual

FUP Commands
File Utility Program (FUP) Reference Manual—523323-015
2-110
INFO DETAIL Listing Format
If all extents were allocated, the percent-used parameter is the amount of
available file space currently used based on available space.
17. Aggregate EOF: For the disk objects, the end-of-file value of the file. For a
partitioned file where the entire file has been opened, the end-of-file value of
the entire file is returned.
If all extents were allocated, the percent-used parameter is the amount of file
space currently used based on available space.
18. FILE LABEL is the number of bytes currently used for the file label and the
percentage of the maximum file label it uses. If this is close to 100 percent, the file
cannot add any new extents.
19. EXTENTS ALLOCATED is the number of extents currently allocated for the file.
20. Indicates the number of index levels used for index blocks (for key-sequenced
files).
Example 2-7 shows the format used by the FUP INFO command (with the DETAIL
option) for SQL views:
The DETAIL listing format for SQL/MP views contains the same type of information as
the other DETAIL listing format. The BASE TABLE field indicates the name of the
underlying table (for protection views), and the PART and REDEFINITION DATE fields
also appear for protection views only. If the partition is on the current node, the node
name does not appear. The LABEL QUESTIONABLE and DEFINITION INVALID fields
are open states.
The DETAIL listing format for SQL/MX objects contains the same type of information
as for SQL/MP objects except:

object-type differentiates between different SQL/MX objects including ANSI
tables, ANSI indexes, and metadata tables.
Example 2-7. DETAIL Format for SQL/MP View
filename date-and-time
object-type
CATALOG catalog-name
BASE TABLE base-table-name
PART ( [ \node.] $volume )
.
.
OWNER group-id,user-id
SECURITY (RWEP): rwep
LABEL QUESTIONABLE
DEFINITION INVALID
CREATION DATE: creation-date
NOPURGEUNTIL: expire-time
REDEFINITION DATE: redefinition-date