SAS Scalable Performance Data Server 4.5, Administrator'S Manual

Page: 227 / 271

-stats
<index,index...>
For each specified index, prints the index disk usage statistics and value segment list
statistics.
-runstats
< index,index...> [
For each specified index, print the "run" statistics. "Runs" are defined as successive
observations in a table that contain the same index value
-reorg
<index,index...>
For each index, reorganize the index to reclaim any unused disk space and coalesce
any fragmented value segment lists.
-joinparts
<number of parallel join work units>
Specifies the number of parallel join work units for a join index. Parallel join threads
will join the work units concurrently and then merge their partial results into the final
result.
-dsn
<data set name>
The SPD Server table that contains the index.
-libpath
<physical path>
The physical path of the domain containing the table.
-help
Prints the ixutil help menu.
Note: Index names are case sensitive and MUST be specified exactly as listed in the PROC
CONTENTS output.
Ixutil Examples
Create a Hybrid Index
Assume there is an SPD Server domain named my domain assigned to the directory
/
spds
on a machine named spot . A user has created a table with the following SAS program:
libname my_data sasspds 'mydomain'
server=spot.spdsname
user='anonymous';
data my_data.test(index=(x));
do i = 1 to 30000;
x = mod(i,3);
output;
end;
run;
data my_data.test1;
do i = 1 to 10000;
x = mod(i,2);
output;
end;
run;
PROC APPEND
Create a Hybrid Index
221