Overview of SPD Server Maintenance Tools

The SPDO procedure is the operator interface for SPD Server. Available only on systems where SAS is installed, this procedure can be used to define and manage SPD Server Access Control Lists (ACLs), define row-level security for tables, manage proxies, define and manage cluster tables, refresh server parameters and server domains, perform table management functions such as truncating tables, and execute SPD Server utilities from a central point. For more information, see SPDO Procedure.

The password database utility psmgr creates and manages the password database that enables access to SPD Server. Use this facility to define and manage users, groups, and group memberships, as well as to change user privileges and performance levels.

The table list utility spdsls lists the contents of an SPD Server domain directory, or lists all other component files for a given SPD Server table component file. This utility can also be used to learn the size of a server table. For more information, see Domain List Utility.

The index utility ixutil enables you to reorganize an SPD Server hybrid index to improve query performance and minimize disk space. The utility also prints the disk usage statistics and the contents of indexes, and enables you to create, list, and delete join indexes. For more information, see Index Utility.

The standard file system backup and restore facilities that native operating systems provide are generally inadequate for backing up and restoring SPD Server tables. Server tables can be enormous in size, surpassing the file size limits maintained by some operating environments. The spdsbkup utility can be used to perform an initial full backup of server tables followed by incremental backups of changed files only. The spdsrstr utility restores server tables incrementally. For more information, see Backing Up and Restoring SPD Server Data.

The directory cleanup utility spdsclean can be used to perform routine maintenance functions on permanent, working, and temporary directories used by SPD Server. For more information, see Directory Cleanup Utility.