SQL/MP Installation and Management Guide

Measuring Performance
HP NonStop SQL/MP Installation and Management Guide—523353-004
13-2
FILEINFO Utility
FILEINFO Utility
The SQLCI FILEINFO utility displays the physical characteristics of SQL tables,
indexes, views, collations, and programs. FILEINFO also displays information about
Enscribe files. You typically use FILEINFO to display the file label information of files.
For performance statistics, use the FILEINFO utility to determine the index levels and
extent and data block use of a table or index. You can improve application performance
by effectively using data and index blocks and by effectively using free space in these
blocks as follows:
•
Index levels
Index levels are a factor that the SQL compiler analyzes when determining the
best access path for a statement, because performance improves as the number of
levels decreases. You can obtain the index levels of an index by using the
FILEINFO index-file-name, the DETAIL command, or by querying the
INDEXES catalog table containing the description of the index.
•
Extent use
The EXTENTS option of the FILEINFO utility displays information about the
number and use of a file’s extents. You can use this information to monitor
available extents of a file or empty extents.
For distributed or partitioned tables or indexes, you can determine the extent
spread over the partitions.
•
Data block use
The STATISTICS option of the FILEINFO utility displays a map of the data blocks.
This information shows used blocks, free blocks, number of records in a file, and
slack information. As a file becomes full, the slack and free blocks decrease. With
less space, insert and update operations can cause block splits.
For OSS files, these considerations apply:
•
You cannot specify an OSS path name as input to the FILEINFO command, but
you can specify the Guardian ZYQ name associated with the OSS program.
•
The name of an OSS file is displayed in its Guardian file name equivalent and then
in its path name format. If there is more than one path name linked to the program,
only one path name is displayed (the first path name available to the current user).
•
Several informational items are not displayed because they do not apply to OSS
files. For example, the EXTENTS option displays a message that EXTENTS
information does not apply to an OSS file.
•
The owner and security are displayed as OSS.
•
The STATISTICS option is equivalent to the DETAIL option.
As an alternative, run FUP or an appropriate OSS utility to obtain information about an
OSS file.