SAS Scalable Performance Data Server 4.5, Administrator'S Manual

Page: 226 / 271

ixutil -statjidx
<data set1,column1> < data set2,column2> ...
<data set_n,column_n>
-libpath
<physical path> ;
Gather statistics about the join index parts. Pay attention to the average join row
percentage, which indicates the average number of rows that are read by a parallel join
work unit. For example, a percentage of 75 indicates the parallel join work unit will
use 75 percent of the rows it must read. The closer the percentage is to 100, the better
the performance. The percentage will increase as the distribution of the data for the join
column becomes more sorted.
ixutil -stats
< indx1,indx2,...>
-dsn
<data set>
-
libpath
<physical path> [
-dist
] ;
For a specified set of indexes that belong to a given table, print the disk usage statistics
and segment list fragmentation statistics. Each value in the index has a segment list. A
value's segment list can become fragmented when the index is updated. An index that
is highly fragmented can degrade query performance and waste disk space. To improve
performance and reclaim the wasted disk space, the index should be reorganized using
the
-reorg
option of ixutil.
ixutil -runstats
<indx1,indx2,...>
-dsn
< data set name>
-
libpath
<physical path> [
-maxruns
<number>] ;
For a specified set of indexes that belong to a given table, print the run statistics for
each index. Run statistics give an indication of how the values of a particular index are
sorted in relation to their observation numbers. By default, ixutil run stats displays the
ten longest runs in the data set. A run is defined as the number of successive observations
that contain the same index value. The optional [
-maxruns <number>] argument can
be used to change from the default setting of 10 runs to any integer between 1 and 100.
Ixutil run stats can be useful in constructing more efficient BY- and WHERE-clause
constructs for the data set.
ixutil -reorg
<index1,index2,...>
-dsn
< data set name>
-libpath
<physical path> ;
Reorganize the specified set of indexes in a table to reclaim wasted disk space and to
aggregate the per-value segment lists. Reorganizing an index results in optimal disk
usage and query performance.
ixutil -fixclustmem -dsn
<data set name>
-libpath
< physical path>
Make cluster member tables accessible, if the CDF metadata is corrupted or deleted.
Run this command for each member table in the cluster, and then remove the .cdf file
from the directory path.
ixutil -help
Print the help menu.
Ixutil Options
-crejidx
<data set1,column1> < data set2,column2> ... <data set_n,column_n>
Create a join index for SPD Parallel Join use.
-deljidx
<data set1,column1> < data set2,column2> ... <data set_n,column_n>
Delete a Join index.
-dist
Include the distribution statistics with the index statistics.
-lstjidx-libpath
<library path>
List the join indexes for a domain.
-statjidx
< data set1,column1> <data set2,column2> ... < data set_n,column_n>
Get statistics about a join index.
220
Chapter 17 • SPD Server Index Utility Ixutil