SAS Safety Scalable Performance Data Server 4.5 Manual Do Utilizador
-stats
<index,index...>
For each specified index, prints the index disk usage statistics and value segment list
statistics.
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
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.
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.
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';
server=spot.spdsname
user='anonymous';
data my_data.test(index=(x));
do i = 1 to 30000;
x = mod(i,3);
output;
end;
run;
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;
do i = 1 to 10000;
x = mod(i,2);
output;
end;
run;
PROC APPEND
Create a Hybrid Index
221