Contents
About
Title Page
Product Notes
SPD Server 4.5 Product Notes
Overview
What's New in SPD Server 4.52?
What's New in SPD Server 4.5?
SPD Server 4.5 Platform Support Changes
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
Required Patches
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
SAS Scalable Performance Data Server 4.5 and SAS Deployment Wizard
Before You Install: Precautions and Required Permissions
Packing List for SPD Server Distribution
Upgrading SPD Server 3.x to SPD Server 4.5
Upgrading SPD Server 4.x to SPD Server 4.5
Configuring SPD Server Host Software for Your Site
Verify That SPD Server 4.5 Is Running
Configuring SPD Server Client Software
Testing 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
SAS Scalable Performance Data Server 4.5 and SAS Deployment Wizard
Before You Install: Precautions and Required Permissions
Packing List for SPD Server Distribution
Validating Default Port and Library Assignments
Initializing the Password Manager Database
Installing SPD Server as a Service
Configuring SPD Server Software on Your Windows Host
Upgrading SPD Server 3.x to SPD Server 4.5
Upgrading SPD Server 4.4 to SPD Server 4.5
Installing and Configuring SPD Server Clients
Testing Your SPD Server Installation Using SAS
SPD Server Command Reference
SPD Server and the SAS Management Console
SPD Server Lightweight Directory Access Protocol (LDAP) Authentication
Notes for SPD Server Administrators
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
The SAS Management Console
Accessing the SPD Manager in SAS Management Console
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
Overview
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 SQL C API to Access SPD Server Tables
Configuring Disk Storage for SPD Server
Introduction
SPD Server Component File Types and Sizes
Creating SPD Server Component Files
Configuring LIBNAME Domain Disk Space
Recommended: Use ROPTIONS=
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
Organizing Domains for Scalability
Domains and Data Spaces
Example Libname.parm File Configurations
Setting Up SPD Server Performance Server
Introduction
Starting the 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 Ùsing 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
Type
Administration
Last Updated
18May2010