• Contents
  • About
  • Product Notes
    • What’s New in SAS Scalable Performance (SPD) Server 5.1
      • What’s New in SPD Server 5.1?
  • SAS Scalable Performance Data (SPD) Server Installation
    • SAS Scalable Performance Data (SPD) Server Pre-Installation and System Requirements Guide
      • Operating System Requirements and Tuning for 64-Bit SPD Server
      • SPD Server Operating System Resource Configuration
    • Installing SAS Scalable Performance Data (SPD) Server on UNIX
      • Before You Install: Precautions and Required Permissions
      • SPD Server UNIX Installation Packing List
      • SPD Server Quick UNIX Installation Guide
      • Configuring SPD Server Host Software for Your Site
      • Completing the Quick Start Configuration
      • Testing the SPD Server Quickstart Installation
      • Potential Problems with Test Verification
      • Customizing Your SPD Server Installation
      • Notes for SPD Server Administrators
      • Troubleshooting
      • Renewing Your SPD Server License
      • Upgrading and Reinstalling SPD Server
    • Installing SAS Scalable Performance Data (SPD) Server on Windows
      • Before You Install: Precautions and Required Permissions
      • SPD Server Windows Installation Packing List
      • SPD Server Quick Windows Installation Guide
      • Configuring SPD Server Host Software for Your Site
      • Completing the Quick Start Configuration
      • Testing the SPD Server Quickstart Installation
      • Potential Problems with Test Verification
      • Customizing Your SPD Server Installation
      • Notes for SPD Server Administrators
      • Troubleshooting
      • Renewing Your SPD Server License
      • Upgrading and Reinstalling SPD Server
  • Migration
    • Using Earlier Version Tables with SAS Scalable Performance Data (SPD) Server 5.1
      • Introduction
      • Converting SPD Server 3.x Tables to SPD Server 4.x Tables
      • Converting SPD Server 4.x 32-Bit Windows Tables to SPD Server 5.1 64-Bit Windows Tables
  • Configuration
    • Using the SAS Scalable Performance Data (SPD) Server Name Server to Manage Resources
      • Managing SPD Server Computing Resources with a Name Server
      • Configuring SPD Server on a Corporate Network
    • Administering and Configuring SAS Scalable Performance Data (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
    • SAS Scalable Performance Data (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 SAS Scalable Performance Data (SPD) Server with Other Clients
      • Overview of Using SPD Server with Other Clients
      • Using Open Database Connectivity (ODBC) to Access SPD Server Tables
      • Using JDBC (Java) to Access SPD Server Tables
    • Configuring Disk Storage for SAS Scalable Performance Data (SPD) Server
      • Introduction
      • SPD Server Component File Types and Sizes
      • Configuring LIBNAME Domain Disk Space
    • Setting Up SAS Scalable Performance Data (SPD) Server Parameter Files
      • Overview of the spdsserv.parm File
      • Syntax for the -parmfile Option
      • Syntax for the spdsserv.parm Options
      • Server Performance Levels
      • SPD Server Parameter File Options
      • SPD Server Parameter File Configurations for LDAP
      • SPD Server Parameter File Validation
      • Pathname Substitution
      • SPD Server Parameter File Configurations for Auditing
    • Setting Up SAS Scalable Performance Data (SPD) Server Libname Parameter Files
      • Overview of the libnames.parm File
      • Domain Naming Syntax for libnames.parm
      • LIBNAME Domain Path Options
      • Path Substitution
      • Verification of libnames.parm File
      • Domain Access Options
      • Controlling the Precedence of Permission Checks with the LIBACLINHERIT= Option and the OWNER= Option
      • Dynamic Locking
      • Organizing Domains for Scalability
      • Domains and Data Spaces
      • Example libname.parm File Configurations
    • Setting Up SAS Scalable Performance Data (SPD) Server Performance Server
      • Overview of SPD Server Performance Server
      • Starting SPD Server Performance Server
      • Performance Server Log File
  • SAS Scalable Performance Data (SPD) Server Security
    • ACL Security Overview
      • SPD Server ACL Security Overview
      • SPD Server ACL Security Model
      • Controlling SPD Server Resources with PROC SPDO
      • Using the ACL Command Set
      • ACL Security Examples
    • Symbolic Substitution
      • SAS Scalable Performance Data (SPD) Server SQL Symbolic Substitution
    • Managing SAS Scalable Performance Data (SPD) Server Passwords and Users
      • Introduction
      • The Password Manager Utility psmgr
      • SAS Management Console
      • LDAP Authentication
      • Enabling 32 Groups for Selected SPD Server Users
    • DICTIONARY.PWDB and DICTIONARY.ACLS
      • DICTIONARY.PWDB and DICTIONARY.ACLS
    • Using SAS Scalable Performance Data (SPD) Server with an Internet Firewall
      • Using SAS Scalable Performance Data (SPD) Server with an Internet Firewall
    • SAS Scalable Performance Data (SPD) Server Auditing
      • SAS Scalable Performance Data (SPD) Server Auditing
    • SAS Scalable Performance Data (SPD) Server Table WHERE Constraints
      • SAS Scalable Performance Data (SPD) Server Table WHERE Constraints
  • SAS Scalable Performance Data (SPD) Server System Management
    • SAS Scalable Performance Data (SPD) Server Operator Interface Procedure (PROC SPDO)
      • Special SPDO Commands
      • LIBNAME Proxy Commands
      • Privileged OPER Commands
      • TRUNCATE Command and Example
      • The REFRESH Command
      • Commands to Nonexistent Users
    • SAS Scalable Performance Data (SPD) Server Index Utility Ixutil
      • The Index Utility ixutil
      • Ixutil Examples
    • SAS Scalable Performance Data (SPD) Server Table List Utility Spdsls
      • SAS Scalable Performance Data (SPD) Server Table List Utility spdsls
    • SAS Scalable Performance Data (SPD) Server Backup and Restore Utilities
      • Overview of the SPD Server Backup and Restore Utilities
      • Path Requirements for SPD Server Utilities
      • Compatibility with Previous Versions
      • Privileged Access Protection
      • The SPD Server Table Backup Utility spdsbkup
      • Backup Requirements
      • spdsbkup Usage
      • spdsbkup Options
      • Backup Data File
      • Backup Table of Contents File
      • spdsbkup User Messages
      • The SPD Server Table Restore Utility spdsrstr
      • spdsbkup and spdsrstr Usage Examples
      • Use 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
    • SAS Scalable Performance Data (SPD) Server Directory Cleanup Utility
      • Overview of the SPD Server Directory Cleanup Utility spdsclean
      • Using the Directory Cleanup Utility spdsclean
      • spdsclean Wildcards and Pattern Matching
      • spdsclean Options
      • spdsclean Examples
    • SAS Scalable Performance Data (SPD) Server Debugging Tools
      • Overview of SPD Server Debugging Tools
      • SPD Server 5.1 LIBNAME Statement Debug Option
      • SPD Server 5.1 Server Parameter File Debug Option


ProductRelease
SAS Scalable Performance Data Server5.1
Type
Administration
Copyright Date
December 2013
Last Updated
17Dec2013