SAS Scalable Performance Data Server 4.5, Administrator'S Manual

Page: 225 / 271

Chapter 17
SPD Server Index Utility Ixutil
The Index Utility Ixutil . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 219
Ixutil Usage . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 219
Ixutil Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 220
Ixutil Examples . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 221
Create a Hybrid Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 221
Retrieve Disk Usage and Fragmentation Statistics . . . . . . . . . . . . . . . . . . . . . . . . . 222
Retrieve Index Distribution Statistics . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 223
Reorganize the Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 224
Review Disk Usage Statistics . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 224
Create a Join Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 225
Generate Join Index Statistics . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 225
Delete the Join Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 226
The Index Utility Ixutil
The ixutil utility supports reorganizing an SPD Server hybrid index to improve query
performance and minimize disk space. The utility also prints the disk usage statistics or the
contents of indexes.
Ixutil Usage
ixutil -crejidx
<data set1,column1> < data set2,column2> ...
<data set_n,column_n>
-libpath
<physical path>
-
joinparts
< number of parallel join work units > ;
Create a join index for a pair of data sets in the same domain that can be used by the
SPD Server Parallel Range Join optimization. The columns
must already be indexed.
The recommended number of parallel join work units is two times the number of
processors.
ixutil -deljidx
<data set1,column1> < data set2,column2> ...
<data set_n,column_n>
-libpath
<physical path> ;
Delete a join index.
ixutil -lstjidx -libpath
<physical path> [ -verbose ] ;
List the join indexes in a domain.
219