SAS Scalable Performance Data Server 4.5, Administrator'S Manual

Page: 258 / 271

Using the Directory Cleanup Utility Spdsclean
The spdsclean program is a command-line utility. It supports a set of command-line options
and parameters you use to specify the location and names of tables to convert, and behaviors
that you want to control during the conversion process.
The command line is as follows:
spdsclean
<-options>
The order of options on the command line does not matter. All options are global in scope.
Spdsclean Wildcards and Pattern Matching
Some spdsclean options, such as –DOMAINS use wildcards and pattern matching
functions. The spdsclean utility uses the following wildcard and pattern matching rules:
• Character strings must match the LIBNAME domain name from the libname file. The
match is not case sensitive.
• Using ' . ' or a ' ? ' characters in the search pattern will wildcard match any single character
in a LIBNAME domain name in the libname file.
• The ' * ' character terminates the pattern and wildcard matches all remaining characters
in the LIBNAME domain name in the libname file.
For example, the -domains pattern ' ?test* ' will match the domains ' ATEST1 ',
' ATEST123 ', ' ATESTXYZ ', ' CTEST1 ', and so on, from a libname file. The -domains
pattern ' test* ' will match only the domain name ' TEST ' from the libname file.
Note: When you use wildcard characters in a -domains pattern, follow the rules for your
command shell (such as ksh) to ensure that these characters are passed to the spdsclean
command. For example, a ksh command shell user would need to enclose the wildcard
pattern in quotation marks. The question marks ensure that the wildcard pattern matching
occurs relative to the spdsclean command.
spdsclean -domains "?test*"
You can also disable command shell globbing for the execution of the spdsclean command.
Spdsclean Options
Spdsclean options fall into two classes. The first class of spdsclean options are options
that define actions. The second class of spdsclean options are options that modify behavior.
Examples for both classes of spdsclean options follow.
Spdsclean Options That Define Actions
The spdsclean utility uses the following option settings to define specific actions:
252
Chapter 20 • SPD Server Directory Cleanup Utility