SAS Scalable Performance Data (SPD) Server Table List Utility spdsls

Description

Invoking Spdsls as a Standalone Utility

Usage

Options

Return Values

spdsls Examples

Use spdsls to List All Components in a Domain

Use spdsls to List Sizing Information and Table Information for a Domain

Description

The spdsls utility lists the contents of an SPD Server domain directory, or lists all other component files for a given SPD Server table component file. The list utility has three purposes:

furnish a complete list of tables for each SPD Server domain that you want to include in a backup
for a specified damaged or questionable component file, provide a list of all other component files for the table that might be affected
provide information about the size of SPD Server tables

Invoking Spdsls as a Standalone Utility

The following environment variables must be established for this utility to be invoked as a standalone utility. Note that these environmental variables are not needed if the utility is invoked in PROC SPDO via the spdscmd interface.

For UNIX:

INSTDIR=<!replace with SPD Server 5.2 Installation Directory!>
 SASVER=9.4 
 SASHOME=<!replace with SPD Server 5.2 Installation Directory!>
 LD_LIBRARY_PATH=$INSTDIR/bin:$SASHOME/SASFoundation/$SASVER/sasexe 
 export LD_LIBRARY_PATH
 LIBPATH=$INSTDIR/bin:$SASHOME/SASFoundation/$SASVER/sasexe
 export LIBPATH
 TKPATH=$INSTDIR/bin:$SASHOME/SASFoundation/$SASVER/sasexe:$SASHOME/SASFoundation
 /$SASVER/utilities/bin
 export TKPATH
 MSGPATH=$SASHOME/SASFoundation/$SASVER/misc/tkspddrv 
 export MSGPATH

For Windows:

SET SASROOT=<!replace with SPD Server 5.2 Installation Directory!>
SET INSTALLDIR=<!replace with SPD Server 5.2 Installation Directory!>
SET MSGPATH=@SASROOT@\tkspddrv\sasmisc 
SET TKPATH=@INSTALLDIR@\bin;@SASROOT@\core\sasext

Usage

spdsls -l [-i] [-o] [-a] [-s] [-v] [-v8] [-v6] [-aonly] <libpath> [Table...]
spdsls -c [-i] [-o] [-a] [-v] <ComponentPath>
spdsls -info [-o] [-v] [-verbose] [-n] [-s] [-v8] [-v6] <libpath> [Table...]

spdsls -l

lists all component files for a specified SPD Server table in the LIBNAME domain. If no table is specified, all tables in the LIBNAME domain are listed. You can use the output list with any system full backup utility.

spdsls -c

For a specified component file (which is identified by a complete path), lists all other component files for the table that contains the specified file. If you have an SPD Server table file that is corrupted or that has been deleted, use this option to find all related component files that might be affected.

spdsls -info

lists information about a specified SPD Server table in the LIBNAME domain. This option provides one line of information about the table as a whole rather than a listing for each component of the table.

Options

-a

includes the domain ACL files in the listing. The files contain the access control lists (ACLs) for any SPD Server table in the domain.

-aonly

includes only the domain ACL files in the listing.

-c

For a specified component file (identified with a complete path), lists all other component files for the table. If you have an SPD Server table file that is corrupted or that has been deleted, use this option to find all related component files that might be affected.

-help

prints a list containing the command-line usage and option switches for the spdsls utility.

-i

lists the index files.

-l

For a specified SPD Server table in the LIBNAME domain, lists all component files for the table. If there is no table specified, lists all tables in the LIBNAME domain. The output list can be used with any system full backup utility.

-n

lists the number of component files.

-o

lists the file owner.

-s

lists the size of the component file, in bytes. When you use this option with spdsls -info, the size of the accumulated component file is listed, in bytes.

-v

includes the version number in the listing.

-verbose

when specified with spdsls –info, the -verbose option includes detailed information about an SPD Server table. The information includes the number of observations in the table, the length of the observation, the size of the index segment, the partition size, and whether the table is compressed, encrypted, or is a cluster member.

-v6

lists only SAS 6.x data sets.

-v8

lists only SAS 8.x or SAS 9.x data sets.

complete path of an SPD Server LIBNAME directory.

complete path of a specified table component file.

[Table...]

specifies one or more tables to list. (If no table is specified, all tables in the LIBNAME domain are listed.)

Return Values

When spdsls exits, it generates a return value. If the return value is 0, the utility was successful. If the return value is 1, the utility completed normally.

spdsls Examples

Use spdsls to List All Components in a Domain

You can use the -l option of the spdsls command to display index, owner, and size information for component files in the domain /bigdisk/sas/data/public.

Use spdsls to List Sizing Information and Table Information for a Domain

You can use the -info option of the spdsls command to get size and verbose descriptive information about tables in the domain /bigdisk/sas/data/public.