Contents
About
Title Page
Product Notes
SPD Server 4.5 Product Notes
Overview
What’s New in SPD Server 4.53?
What's New in SPD Server 4.52?
What's New in SPD Server 4.5?
Installation
SPD Server Pre-Installation and System Requirements Guide
AIX Requirements and Tuning for 64-Bit SPD Server
HP-UX Requirements and Tuning for 64-Bit SPD Server
Solaris on SPARC Requirements and Tuning for 64-Bit SPD Server
Solaris on X64 Requirements and Tuning for 64-Bit SPD Server
Linux on X64 Requirements and Tuning for 64-Bit SPD Server
Windows Requirements and Tuning for 32-Bit SPD Server
SPD Server 4.5 Client Requirements
SPD Server UNIX Installation Guide
Before You Install: Precautions and Required Permissions
Packing List for SPD Server Distribution
SAS Scalable Performance Data Server 4.5 and SAS Deployment Wizard
Upgrading and Reinstalling SPD Server
Configuring SPD Server Host Software for Your Site
Configuring the rc.spds File
Verify That SPD Server 4.5 Is Running
Configure SPD Server Client Software
Test Your SPD Server Installation Using SAS
SPD Server Command Reference
SPD Server 4.5 and the SAS Management Console Utility
SPD Server Lightweight Directory Access Protocol (LDAP) Authentication
Notes for SPD Server Administrators
Troubleshooting
SPD Server Windows Installation Guide
Before You Install: Precautions and Required Permissions
Packing List for SPD Server Distribution
SAS Scalable Performance Data Server 4.5 and SAS Deployment Wizard
Upgrading and Reinstalling SPD Server
Validate Default Port and Library Assignments
Verify the Name Server Port Assignment and TMP Path
Initialize the Password Manager Database
Install SPD Server as a Service
Start and Stop SPD Server
Configure SPD Server Software on Your Windows Host
Install and Configure SPD Server Clients
Use SAS to Test Your SPD Server Installation
SPD Server Command Reference
SPD Server and the SAS Management Console
SPD Server Lightweight Directory Access Protocol (LDAP) Authentication
SPD Server User IDs
Troubleshooting
Migration
SPD Server 3.x to SPD Server 4.5 Conversion Utility
Introduction
Before You Convert
Overview of the SPDSCONV Utility
Using SPDSCONV
SPDSCONV Utility Examples
Configuration
Using the SPD Server Name Server to Manage Resources
Managing Computing Resources with a Name Server
Configuring SPD Server on a Corporate Network
Administering and Configuring SPD Server Using the SAS Management Console
Overview of SAS Management Console
Accessing SPD Server Services in SAS Management Console
Connect to an SPD Server
Password Manager
ACL Manager
Server Manager
Process Profiler
Proxy Manager
SPD Server SQL Query Rewrite Facility
Overview of the SQL Query Rewrite Facility
Configuring Storage Space for the SQL Query Rewrite Facility
SQL Query Rewrite Facility Options
Using SPD Server with Other Clients
Introduction
Using Open Database Connectivity (ODBC) to Access SPD Server Tables
Using JDBC (Java) to Access SPD Server Tables
Using htmSQL to Access SPD Server Tables
Using the SQL C API to Access SPD Server Tables
Configuring Disk Storage for SPD Server
Introduction
SPD Server Component File Types and Sizes
Configuring LIBNAME Domain Disk Space
Setting Up SPD Server Parameter Files
Introduction
Syntax for the -parmfile Option
Syntax for the spdsserv.parm Options
Server Performance Levels
spdsserv.parm Options
SPD Server Parameter File Configurations for LDAP
SPD Server Parameter File Configurations for Auditing
Setting Up SPD Server Libname Parameter Files
Introduction
Domain Naming Syntax for libnames.parm
Domain Path Options
Consistency in Nomenclature
Domain Access Options
Controlling the Precedence of Permission Checks with the LIBACLINHERIT= Option
Dynamic Locking
Organizing Domains for Scalability
Domains and Data Spaces
Example libname.parm File Configurations
Setting Up SPD Server Performance Server
Introduction
Starting SPD Server Performance Server
Performance Server Log File
Security
ACL Security Overview
ACL Security Overview
SPD Server ACL Security Model
Controlling SPD Server Resources with PROC SPDO and ACL Commands
Symbolic Substitution
Symbolic Substitution
Managing SPD Server Passwords, Users, and Table ACLs
Introduction
The Password Manager Utility psmgr
SAS Management Console
LDAP Authentication Notes
DICTIONARY.PWDB and DICTIONARY.ACLS
DICTIONARY.PWDB and DICTIONARY.ACLS
Using SPD Server with an Internet Firewall
Using SPD Server with an Internet Firewall
SPD Server Auditing
SPD Server Auditing
SPD Server Table WHERE Constraints
SPD Server Table WHERE Constraints
System Management
SPD Server Operator Interface Procedure (PROC SPDO)
Special SPDO Commands
LIBNAME Proxy Commands
Privileged OPER Commands
TRUNCATE Command and Example
Refreshing SPD Server Parameter and LIBNAME Files
Commands to Nonexistent Users
SPD Server Index Utility Ixutil
The Index Utility Ixutil
Ixutil Examples
SPD Server Table List Utility Spdsls
SPD Server Table List Utility Spdsls
SPD Server Backup and Restore Utilities
Introduction
Overview of the SAS Scalable Performance Data Server Backup and Restore Utilities
Using Utilities with SPD Server
Compatibility with Previous Versions
Privileged Access Protection
Spdsbkup - The SPD Server Table Backup Utility
Backup Requirements
Backup Usage
Backup Options
Backup Return Values
Backup Data File
Backup Table of Contents File
Backup User Messages
Spdsrstr - The SPD Server Table Restore Utility
Using PROC SPDO to Back Up and Restore SPD Server Tables
Back Up and Restore Table Indexes Using SPD Server Full Backups
Back Up and Restore SPD Server Table Indexes Using System Full Backups
SPD Server Directory Cleanup Utility
Introduction
Using the Directory Cleanup Utility Spdsclean
Spdsclean Wildcards and Pattern Matching
Spdsclean Options
Spdsclean Examples
SPD Server Debugging Tools
Introduction
SPD Server 4.5 LIBNAME Statement Debug Options
SPD Server 4.5 Server Parameter File Debug Options
Product
Release
SAS Scalable Performance Data Server
4.53
Type
Administration
Copyright Date
July 2011
Last Updated
09Jul2011