Overview: PROC SPDO :: SAS® Scalable Performance Data Server 5.3: Administrator's Guide

The SPDO procedure is the operator interface for SPD Server. It is a SAS procedure and runs only on systems where SAS is installed.

Operator tasks for the server fall into the following categories:

ACL definition and management
row-level security definition and management
proxy management
server management
cluster table definition and management
general table management.

Here are examples of tasks that you might perform in each category:

ACL definition and management:

add, modify, list, and delete ACLs for server resources

Row-level security definition and management:

define, describe, and remove WHERE constraints on tables

Proxy management:

list all active users or all locking users
set a user for the user proxy process or user locking proxy thread
list the active librefs and open tables for the user
set operator mode and issue privileged operator commands.

Server management:

refresh domains and server parameters on a running server.

Cluster table definition and management:

create, list, modify, destroy, and undo dynamic cluster tables
add, remove, replace, and fix cluster table members.

General table management:

issue system commands on server nodes
truncate a table.

Many PROC SPDO statements require that the ACLSPECIAL= option is enabled in the SASSPDS engine LIBNAME statement. To enable ACLSPECIAL=, a server user ID must first have been granted special privilege in the password database. Then, the user can request special access for a specific server connection. For more information about SPD Server authorization levels, see Password Database Utility.

SPDO Procedure

Overview: SPDO Procedure