SAS Safety Scalable Performance Data Server 4.5 Manual Do Utilizador

Página de 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