SPD Server Table List Utility Spdsls

Description

Spdsls lists the contents of an SPD Server domain directory, or given an SPD Server table component file, lists all other component files for the table. There are three purposes of the list utility:

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

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

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.

spdsls -c

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

spdsls -info

For a specified SPD Server table in the LIBNAME domain, list information about the table. 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

Will include the domain ACL files in the listing. The files contain the ACLs (Access Control Lists) for any SPD Server table in the domain.

-aonly

Will include only the domain ACL files in the listing.

-c

-help

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

-i

Lists the index files.

-l

-n

Lists the number of component files.

-o

Lists the file owner.

-s

Lists the size of the component file in bytes. When used with spdsls -info, lists the size of the accumulated component file in bytes.

-v

Includes the version number in the listing.

-verbose

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

-v6

Only lists SAS 6.x data sets.

-v8

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

The complete path of an SPD Server LIBNAME directory.

The complete path of a specified table component file.

[Table...]

The table(s) 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 spdsls return value is 0, the utility was successful. If the spdsls return value is 1, the utility was unable to complete 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 domain /bigdisk/sas/data/public as follows:

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.