SAS Scalable Performance Data Server 4.5 Service manual

SAS®Scalable Performance
Data Server® 4.5
Administrator’s Guide
TW10909_colortitlepg.indd 1 5/26/09 3:22:24 PM

The correct bibliographic citation for this manual is as follows: SAS Institute Inc. 2009. SAS®Scalable
Performance Data Server®4.5: Administrator’s Guide.Cary, NC: SAS Institute Inc.
SAS®Scalable Performance Data Server®4.5: Administrator’s Guide
Copyright © 2009, SAS Institute Inc., Cary, NC, USA
All rights reserved. Produced in the United States of America.
For a hard-copy book: No part of this publication may be reproduced, stored in a retrieval system, or
transmitted, in any form or by any means, electronic, mechanical, photocopying, or otherwise, without
the prior written permission of the publisher, SAS Institute Inc.
For a Web download or e-book: Your use of this publication shall be governed by the terms
established by the vendor at the time you acquire this publication.
U.S. Government Restricted Rights Notice: Use, duplication, or disclosure of this software and related
documentation by the U.S. government is subject to the Agreement with SAS Institute and the
restrictions set forth in FAR 52.227-19, Commercial Computer Software-Restricted Rights (June 1987).
SAS Institute Inc., SAS Campus Drive, Cary, North Carolina 27513.
1st electronic book, June 2009
SAS®Publishing provides a complete selection of books and electronic products to help customers use
SAS software to its fullest potential. For more information about our e-books, e-learning products, CDs,
and hard-copy books, visit the SAS Publishing Web site at support.sas.com/publishing or call 1-800-
727-3228.
SAS® and all other SAS Institute Inc. product or service names are registered trademarks or trademarks
of SAS Institute Inc. in the USA and other countries. ® indicates USA registration.
Other brand and product names are registered trademarks or trademarks of their respective companies.

Contents
PART 1Product Notes 1
Chapter 1 • SPD Server 4.5 Product Notes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3
Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3
What's New in SPD Server 4.5? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3
SPD Server 4.5 Platform Support Changes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4
PART 2Installation 5
Chapter 2 • SPD Server Pre-Installation and System Requirements Guide . . . . . . . . . . . . . . . . . 7
AIX Requirements and Tuning for 64-bit SPD Server . . . . . . . . . . . . . . . . . . . . . . . . . . . 7
HP-UX Requirements and Tuning for 64-bit SPD Server . . . . . . . . . . . . . . . . . . . . . . . . 7
Required Patches . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8
Solaris on Sparc Requirements and Tuning for 64-bit SPD Server . . . . . . . . . . . . . . . . . 9
Solaris on X64 Requirements and Tuning for 64-bit SPD Server . . . . . . . . . . . . . . . . . . 9
Linux on X64 Requirements and Tuning for 64-bit SPD Server . . . . . . . . . . . . . . . . . . . 9
Windows Requirements and Tuning for 32-bit SPD Server . . . . . . . . . . . . . . . . . . . . . 10
SPD Server 4.5 Client Requirements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10
Chapter 3 • SPD Server UNIX Installation Guide . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11
SAS Scalable Performance Data Server 4.5 and SAS Deployment Wizard . . . . . . . . . 12
Before You Install: Precautions and Required Permissions . . . . . . . . . . . . . . . . . . . . . . 12
Packing List for SPD Server Distribution . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13
Upgrading SPD Server 3.x to SPD Server 4.5 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15
Upgrading SPD Server 4.x to SPD Server 4.5 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16
Configuring SPD Server Host Software for Your Site . . . . . . . . . . . . . . . . . . . . . . . . . . 16
Verify That SPD Server 4.5 Is Running . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22
Configuring SPD Server Client Software . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23
Testing Your SPD Server Installation Using SAS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24
SPD Server Command Reference . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26
SPD Server 4.5 and the SAS Management Console Utility . . . . . . . . . . . . . . . . . . . . . . 30
SPD Server Lightweight Directory Access Protocol (LDAP) Authentication . . . . . . . . 30
Notes for SPD Server Administrators . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32
Troubleshooting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34
Chapter 4 • SPD Server Windows Installation Guide . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 37
SAS Scalable Performance Data Server 4.5 and SAS Deployment Wizard . . . . . . . . . 38
Before You Install: Precautions and Required Permissions . . . . . . . . . . . . . . . . . . . . . . 38
Packing List for SPD Server Distribution . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 38
Validating Default Port and Library Assignments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41
Initializing the Password Manager Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 42
Installing SPD Server as a Service . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 42
Configuring SPD Server Software on Your Windows Host . . . . . . . . . . . . . . . . . . . . . 44
Upgrading SPD Server 3.x to SPD Server 4.5 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 46
Upgrading SPD Server 4.4 to SPD Server 4.5 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 46
Installing and Configuring SPD Server Clients . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 46
Testing Your SPD Server Installation Using SAS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 47

SPD Server Command Reference . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 48
SPD Server and the SAS Management Console . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 51
Lightweight Directory Access Protocol (LDAP) Authentication . . . . . . . . . . . . . . . . . . 52
Notes for SPD Server Administrators . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 53
Troubleshooting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 54
PART 3Migration 57
Chapter 5 • SPD Server 3.x to SPD Server 4.5 Conversion Utility . . . . . . . . . . . . . . . . . . . . . . . . 59
Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 59
Before You Convert . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 59
Overview of the SPDSCONV Utility . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 60
Using SPDSCONV . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 61
SPDSCONV Utility Examples . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 62
PART 4Configuration 65
Chapter 6 • Using the SPD Server Name Server to Manage Resources . . . . . . . . . . . . . . . . . . . 67
Managing Computing Resources with a Name Server . . . . . . . . . . . . . . . . . . . . . . . . . . 67
Configuring SPD Server on a Corporate Network . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 67
Chapter 7 • Administering and Configuring SPD Server Using the SAS
Management Console . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 71
The SAS Management Console . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 71
Accessing the SPD Server Manager in SAS Management Console . . . . . . . . . . . . . . . . 72
Password Manager . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 72
ACL Manager . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 77
Server Manager . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 81
SPD Process Profiler . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 83
Proxy Manager . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 85
Chapter 8 • SPD Server SQL Query Rewrite Facility . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 89
Overview of the SQL Query Rewrite Facility . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 89
Configuring Storage Space for the SQL Query Rewrite Facility . . . . . . . . . . . . . . . . . . 89
SQL Query Rewrite Facility Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 90
Chapter 9 • Using SPD Server With Other Clients . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 93
Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 93
Using Open Database Connectivity (ODBC) to Access SPD Server Tables . . . . . . . . . 94
Using JDBC (Java) to Access SPD Server Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 99
Using htmSQL to Access SPD Server Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 102
Using SQL C API to Access SPD Server Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 104
Chapter 10 • Configuring Disk Storage for SPD Server . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 105
Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 105
SPD Server Component File Types and Sizes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 105
Creating SPD Server Component Files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 106
Configuring LIBNAME Domain Disk Space . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 106
Recommended: Use ROPTIONS= . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 108
Chapter 11 • Setting Up SPD Server Parameter Files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 111
iv Contents

Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 112
Syntax for the -PARMFILE Option . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 112
Syntax for the spdsserv.parm Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 112
spdsserv.parm Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 113
SPD Server Parameter File Configurations for LDAP . . . . . . . . . . . . . . . . . . . . . . . . . 119
SPD Server Parameter File Configurations for Auditing . . . . . . . . . . . . . . . . . . . . . . . 120
Chapter 12 • Setting Up SPD Server Libname Parameter Files . . . . . . . . . . . . . . . . . . . . . . . . . 123
Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 123
Domain Naming Syntax for Libnames.parm . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 124
Domain Path Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 124
Consistency in Nomenclature . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 126
Domain Access Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 127
Organizing Domains for Scalability . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 131
Domains and Data Spaces . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 133
Example Libname.parm File Configurations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 136
Chapter 13 • Setting Up SPD Server Performance Server . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 141
Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 141
Starting the SPD Server Performance Server . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 142
Performance Server Log File . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 146
PART 5Security 147
Chapter 14 • ACL Security Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 149
ACL Security Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 150
SPD Server ACL Security Model . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 150
Controlling SPD Server Resources with PROC SPDO and ACL Commands . . . . . . . 154
Symbolic Substitution . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 165
DICTIONARY.PWDB and DICTIONARY.ACLS . . . . . . . . . . . . . . . . . . . . . . . . . . . 186
Using SPD Server with an Internet Firewall . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 188
SPD Server Auditing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 189
Chapter 15 • Managing SPD Server Passwords, Users, and Table ACLs . . . . . . . . . . . . . . . . . 193
Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 193
The Password Manager Utility psmgr . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 193
SAS Management Console . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 204
LDAP Authentication Notes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 204
PART 6System Management 207
Chapter 16 • SPD Server Operator Interface Procedure (PROC SPDO) . . . . . . . . . . . . . . . . . . 209
Special SPDO Commands . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 209
LIBNAME Proxy Commands . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 210
Privileged OPER Commands . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 213
TRUNCATE Command and Example . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 214
Refreshing SPD Server Parameter and LIBNAME Files . . . . . . . . . . . . . . . . . . . . . . . 215
Commands to Nonexistent Users . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 216
Chapter 17 • SPD Server Index Utility Ixutil . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 219
The Index Utility Ixutil . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 219
Contents v

Ixutil Examples . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 221
Chapter 18 • SPD Server Table List Utility Spdsls . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 227
SPD Server Table List Utility Spdsls . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 227
Chapter 19 • SPD Server Backup and Restore Utilities . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 231
Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 232
Overview of the SAS Scalable Performance Data Server Backup
and Restore Utilities . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 232
Using Utilities with SPD Server . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 233
Compatibility with Previous Versions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 233
Privileged Access Protection . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 233
Spdsbkup - the Table Backup Utility . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 234
Backup Requirements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 235
Backup Usage . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 236
Backup Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 236
Backup Return Values . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 238
Backup Data File . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 238
Backup Table of Contents File . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 239
Backup User Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 240
Spdsrstr - the SPD Server Table Restore Utility . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 240
Using PROC SPDO to Back Up and Restore SPD Server Tables . . . . . . . . . . . . . . . . 246
Back Up and Restore Table Indexes using SPD Server Full Backups . . . . . . . . . . . . . 247
Back Up and Restore SPD Server Table Indexes using System Full Backups . . . . . . 248
Chapter 20 • SPD Server Directory Cleanup Utility . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 251
Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 251
Using the Directory Cleanup Utility Spdsclean . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 252
Spdsclean Wildcards and Pattern Matching . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 252
Spdsclean Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 252
Spdsclean Examples . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 254
Chapter 21 • SPD Server Debugging Tools . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 259
Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 259
SPD Server 4.5 LIBNAME Statement Debug Options . . . . . . . . . . . . . . . . . . . . . . . . 259
SPD Server 4.5 Server Parameter File Debug Options . . . . . . . . . . . . . . . . . . . . . . . . 260
vi Contents

Part 1
Product Notes
Chapter 1
SPD Server 4.5 Product Notes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3
1

2

Chapter 1
SPD Server 4.5 Product Notes
Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3
What's New in SPD Server 4.5? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3
Overview of SPD Server 4.5 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3
SPD Server 4.5 Platform Support Changes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4
Overview
This document summarizes enhancements and changes in SPD Server 4.5.
• The SPD Server 4.5 installation includes client modules that are compatible with SAS
9.2.
• SPD Server 4.5 is not compatible with SAS versions earlier than SAS 9.2. Refer to the
appropriate SPD Server UNIX or Windows installation guide for more information
about SAS software requirements for use with SPD Server 4.5.
What's New in SPD Server 4.5?
Overview of SPD Server 4.5
The operating system requirements for SPD Server 4.5 have changed from the operating
system requirements for SPD Server 4.4. For more detailed information about operating
system requirements for SPD Server 4.5, see the SPD Server Pre-Installation and System
Requirements Guide on page 7.
• SPD Audit logging has been enhanced to include the user LIBNAME in the proxy and
SQL audit logs. For additional information, see the section on SPD Server auditing in
“SPD Server Auditing” on page 189.
• You can now specify recycle times for the SPD Server Name Server log and the SPD
Server Snet log. For additional information about configuring SPD Server log cycle
times for Windows installations, see “Configuring SPD Server Software on Your
Windows Host” on page 44. For additional information about configuring SPD Server
log cycle times for UNIX installations, see “Configuring SPD Server Host Software
for Your Site” on page 16.
3

• SPD Server now supports user formats with the put() function that are greater than 8
characters in length. An SPD Server host can read user format catalog files that were
created by SAS running on Windows, or on the same machine as the SPD Server host.
The spdsls list utility has been enhanced to add a -verbose option. The -verbose
option provides information such as the number of observations, observation length,
index segment size, partition size, and whether the table is compressed, encrypted, or
is a member of a cluster. For more information about SPD Server list utilities, see “SPD
Server Table List Utility Spdsls” on page 227.
• SAS implicit pass-through SQL now permits SQL queries to SPD Server that include
supported SPD Server functions. The "SPD Server SQL Features" chapter of the SAS
Scalable Performance Data Server 4.5: User's Guide contains a section, "Differences
between SAS SQL and SPD Server SQL," that lists the functions that SPD Server
supports via implicit pass-through SQL.
• The installation and delivery of the SPD Server 4.5 client components for SAS is now
part of your SAS installation. For more detailed information about installing SPD
Server 4.5 on a Windows platform, see “Before You Install: Precautions and Required
Permissions” on page 38. For more detailed information about installing SPD Server
4.5 on a UNIX platform, see “ Before You Install: Precautions and Required
Permissions” on page 12.
• The installation and delivery of SAS Management Console components for SPD Server
4.5 is now part of your SAS Management Console installation. For more detailed
information about installing SAS Management Console components for SPD Server
4.5 on a Windows platform, see “Before You Install: Precautions and Required
Permissions” on page 38. For more detailed information about installing SAS
Management Console components for SPD Server 4.5 on a UNIX platform, see
“ Before You Install: Precautions and Required Permissions” on page 12
SPD Server 4.5 Platform Support Changes
SPD Server 4.5 now supports the Linux x64 platform.
4Chapter 1 • SPD Server 4.5 Product Notes

Part 2
Installation
Chapter 2
SPD Server Pre-Installation and System Requirements Guide . . . . . . 7
Chapter 3
SPD Server UNIX Installation Guide . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11
Chapter 4
SPD Server Windows Installation Guide . . . . . . . . . . . . . . . . . . . . . . . . . . 37
5

6

Chapter 2
SPD Server Pre-Installation and
System Requirements Guide
AIX Requirements and Tuning for 64-bit SPD Server . . . . . . . . . . . . . . . . . . . . . . . . 7
HP-UX Requirements and Tuning for 64-bit SPD Server . . . . . . . . . . . . . . . . . . . . . 7
System Requirements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7
Kernel Tuning Requirements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8
Required Patches . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8
Solaris on Sparc Requirements and Tuning for 64-bit SPD Server . . . . . . . . . . . . . 9
System Requirements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9
Solaris on X64 Requirements and Tuning for 64-bit SPD Server . . . . . . . . . . . . . . . 9
System Requirements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9
Linux on X64 Requirements and Tuning for 64-bit SPD Server . . . . . . . . . . . . . . . . 9
System Requirements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9
Windows Requirements and Tuning for 32-bit SPD Server . . . . . . . . . . . . . . . . . . 10
System Requirements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10
SPD Server 4.5 Client Requirements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10
System Requirements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10
AIX Requirements and Tuning for 64-bit SPD
Server
For complete information about AIX tuning for SAS SPD Server, see the white paper
selection available on SAS Institute's external Web site at: www.sas.com/partners/
directory/ibm/papers.html
HP-UX Requirements and Tuning for 64-bit SPD
Server
System Requirements
• Required OS level: HP-UX 11i 64-bit OS (HP-UX 11.11 for PA-RISC or HP-IA64 64-
bit OS (HP-UX 11i v2, HP-UX 11.23 for Itanium)
7

• Minimum System Configuration: HP-PA 2.0 server system with minimum 2Gb
memory.
Kernel Tuning Requirements
The following kernel parameters are for HP-UX 11.11 and HP-UX 11.23. They need to be
adjusted on the HP server system where you will run SPD Server.
After you make these kernel parameter changes, be sure to reboot the system before you
attempt to use the SPD Server. In the following, MAX(a,b) means to take the maximum
of the values a or b.
•
dcb_max_pct = 10%
dcb_min_pct = 2%
max_thread_proc = 512
maxdsiz_64 = 1Gb + MAX(SORTSIZE, INDEX_SORTSIZE)
maxuprc = 4 + #concurrent SPD Server users
nproc = current nproc value + 4 + #concurrent SPD Server users
•
Note: SORTSIZE and INDEX_SORTSIZE are SPD Server parameters from the
spdsserv.parm file. Increasing these SPD Server parameters may require adjusting
the HP-UX kernel parameters accordingly. For more information on SPD Server
parameters consult the “SPD Server UNIX Installation Guide ” on page 11
• Other HP-UX kernel parameters that may need to be increased depending on the way
you use the SPD Server include:
•ninode= Maximum open inodes in memory. Adjust for the maximum number of
concurrently open SPD tables multiplied by the maximum number of partitions in
an SPD Server table.
•nfile= System-wide open file limit. Adjust for the maximum number of
concurrently open SPD Server tables multiplied by the maximum number of
partitions in an SPD Server table.
•nflocks= System-wide file lock limit. Adjust for the maximum number of
concurrently open SPD Server tables.
•maxfiles_lim = Process hard limit for open files. Adjust for the maximum number
of concurrently open SPD Server tables multiplied by the maximum number of
partitions in an SPD Server table. The minimum recommended setting is 8192
Required Patches
The following HP-UX 11.23 for Itanium (IA-64) patches should be applied for SPD Server
4.4:
• PHCO_30543 s700_800 11.23 Pthread library cumulative patch
• PHCO_30531 s700_800 11.23 libc cumulative patch
• The HP September 2004 Base Patch Bundle for HP-UX 11.23
8Chapter 2 • SPD Server Pre-Installation and System Requirements Guide

Solaris on Sparc Requirements and Tuning for 64-
bit SPD Server
System Requirements
The following kernel parameter needs to be adjusted on Solaris server systems where you
will run SPD Server.
•rlim_fd_max = Process limit for open files. Adjust the parameter to accommodate the
maximum number of the number of concurrently open SPD tables multiplied by the
maximum number of partitions in an SPD Server table. The minimum recommended
setting is 8192
• Required OS level: Solaris Version 5.9
Solaris on X64 Requirements and Tuning for 64-bit
SPD Server
System Requirements
The following kernel parameter needs to be adjusted on Solaris server systems where you
will run SPD Server.
•rlim_fd_max = Process limit for open files. Adjust the parameter to accommodate the
maximum number of the number of concurrently open SPD tables multiplied by the
maximum number of partitions in an SPD Server table. The minimum recommended
setting is 8192
• Required OS level: Solaris Version 5.10, Update 3
Linux on X64 Requirements and Tuning for 64-bit
SPD Server
System Requirements
• Required OS level: Red Hat Enterprise Linux 4 and 5, SuSE Linux Enterprise
Server 9 and 10.
System Requirements 9

Windows Requirements and Tuning for 32-bit SPD
Server
System Requirements
• Required OS level: Windows NT 4.0 Service pack 3 or greater
• Minimum System Configuration: NT server system.
SPD Server 4.5 Client Requirements
System Requirements
• Required SAS level: SPD Server 4.5 requires SAS 9.2.
10 Chapter 2 • SPD Server Pre-Installation and System Requirements Guide

Chapter 3
SPD Server UNIX Installation
Guide
SAS Scalable Performance Data Server 4.5 and SAS Deployment Wizard . . . . . . 12
Before You Install: Precautions and Required Permissions . . . . . . . . . . . . . . . . . . . 12
Packing List for SPD Server Distribution . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13
Directory Contents . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13
Upgrading SPD Server 3.x to SPD Server 4.5 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15
Overview of Upgrading from SPD Server 3.x to SPD Server 4.5 . . . . . . . . . . . . . . 15
Upgrading SPD Server 4.x to SPD Server 4.5 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16
Overview of Upgrading from SPD Server 4.x to SPD Server 4.5 . . . . . . . . . . . . . . 16
Configuring SPD Server Host Software for Your Site . . . . . . . . . . . . . . . . . . . . . . . 16
Verify That SPD Server 4.5 Is Running . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22
Configuring SPD Server Client Software . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23
Testing Your SPD Server Installation Using SAS . . . . . . . . . . . . . . . . . . . . . . . . . . . 24
SPD Server Command Reference . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26
SPD Server Name Server Commands . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26
SPD Server Host Commands . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27
SNET Server Commands . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29
Password Utility Reference . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30
Performance Server Reference . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30
SPD Server 4.5 and the SAS Management Console Utility . . . . . . . . . . . . . . . . . . . 30
SPD Server Lightweight Directory Access Protocol (LDAP) Authentication . . . . 30
Notes for SPD Server Administrators . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32
UNIX User IDs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32
SPD Server User IDs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33
LDAP Password Authentication . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33
Troubleshooting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34
Name Server Start-Up Failed . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34
SPD Server Host Start-Up Failed . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34
SAS LIBNAME Assignment Failed . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34
Using SETINIT to Extend SPD Server Software . . . . . . . . . . . . . . . . . . . . . . . . . . . 36
11

SAS Scalable Performance Data Server 4.5 and
SAS Deployment Wizard
SAS Scalable Performance Data Server (SPD Server) 4.5 can be installed as part of your
initial SAS 9.2 installation. Or, SPD Server 4.5 can be installed as an add-on product to an
existing SAS 9.2 installation. In either case, the SPD Server 4.5 installation is facilitated
by the SAS Deployment Wizard. The SAS Deployment Wizard installs SPD Server to the
following location on your computer: <SASROOT>/
SASScalablePerformanceDataServer/4.5/.
Note: <SASROOT> is a placeholder for the full path specification to the base directory of
your SAS 9.2 installation.
Before You Install: Precautions and Required
Permissions
Note: Before you install, see “SPD Server 4.5 Product Notes ” on page 3 for important
information about features in this release.
Review the following precautions and required permissions:
• Read “SPD Server Pre-Installation and System Requirements Guide ” on page 7 .
• SPD Server 4.5 is distributed only as a 64-bit environment application for Solaris by
Sun, AIX by IBM, Linux by SUSE or Red Hat, and HP-UX by Hewlett-Packard.
• SAS recommends that you use a UNIX user ID other than root to run your production
SPD Server environment. Although there are no known security or integrity problems
with SPD Server 4.5, root access is not required to run SPD Server. After you correctly
configure UNIX directory ownership and you set permissions on your LIBNAME
domains, there is no real need or benefit for root access to SPD Server. For more
information and a list of options to use when configuring SPD Server, see“Notes for
SPD Server Administrators” on page 32 .
• SAS recommends that you install SPD Server in a location that is adequately mirrored
and backed up to assure reliability. The SPD Server installation location should use
system space in which the SPD Server Administrator has full rights.
• General familiarity with the UNIX language is required to install SPD Server 4.5. At
a minimum, installers should be familiar with basic UNIX shell entities (such as sh,
csh, and ksh), Bourne shell scripts, the UNIX tar command, and how to modify files
using a UNIX text editor.
• You need appropriate access permissions to create the installation directory for SPD
Server on the file system where you install the server software. The owner of the SPD
Server installation directory should be the UNIX user ID of the SPD Server
administrator. For more information, see“Notes for SPD Server Administrators” on
page 32 .
• You need Write access to your server machine's /etc/inet/services or /etc/
services file, if you want SPD Server clients to connect to the SPD Server host using
name services instead of specifying port numbers at invocation. Name services require
you to define registered ports that use the services file appropriate to your machine.
12 Chapter 3 • SPD Server UNIX Installation Guide

• If your SPD Server clients access the SPD Server host using name services instead of
specifying port numbers, you need Write access to the services files on the clients, in
the path /etc/services or /etc/inet/services
For Windows, the path is C:\winnt\system32\drivers\etc\services
• Insert the WORKPATH= server option in your spdsserv.parm file. Use the
WORKPATH= option to configure your server to use a high-performance file system.
Ideally this system has RAID-structured volumes with sufficient disk space to
accommodate the transient storage needs for Server. The spdsserv.parm file is located
in the root directory of your SPD Server host installation. For more information about
the WORKPATH= option and configuring servers for performance, see the SAS
Scalable Performance Data (SPD) Server 4.5: User's Guide.
Packing List for SPD Server Distribution
Directory Contents
Directory names in the packing list are subdirectories of your SPD Server host installation
directory, whose path is represented by InstallDir/.
Note: InstallDir/ represents the root directory where SPD Server is installed.
The bin/ subdirectory contains the following binary files:
•spdsnsrv is the SPD Server Name Server.
•spdsservis the SPD Server host.
•spdsbase is the LIBNAME proxy.
•spdslog is the message logger.
•spdsaud is the audit logger.
•spdseng is the SQL Pass-Through engine.
•ixutil is the data set index utility .
•psmgr is the password file utility.
•spdssnet is the ODBC, JDBC, and htmSQL gateway,
•spdsperf is the Performance server.
•spdsls gives physical file listings for a LIBNAME domain.
•spdsbkup performs full or incremental table backups.
•spdsrstr restores full or incremental table backups
•spqldrive is a stand-alone SQL Pass-Through driver.
•spdsconv is the SPD Server 3.x to SPD Server 4.x table conversion utility.
•spdsclean is the SPD Server disk cleanup utility.
•dulibv3 is the SPD Server 3.x 64-bit version of the shared library used by spdsconv.
The dulibv3 file is included only if your system previously supported SPD Server 3.x
tables.
•spdsbased is the debug version of spdsbase.
•spdsengd is the debug version of spdseng.
Directory Contents 13

•spdsnlslib is the NLS library.
•spdsnlslibd is the debug version of spdsnlslib.
•spdsiotest is the stand alone SPD Server I/O scalability test.
The lib/ subdirectory contains the following SPD Server library files:
•spdslib is the run-time library that performs SQL Pass-Through from C and C++
applications to SPD Server.
•spds.dll is the application extension library that is accessed via the SAS ODBC Driver.
The samples/ directory contains the following files of interest:
•auditraw.sasis used to read proxy audit files that do not include WHERE clause
auditing.
•auditwh.sasis used to read proxy audit files that include WHERE clause auditing.
•audit.sql.sasis used to read an SQL audit file.
•libnames.parm is a sample SPD Server host LIBNAME configuration file. Use with
the -libnamefile option for the spdsserv command.
•libsamp.parm is a more advanced example of a LIBNAME configuration file.
•pwdb is a script to start the Password Manager executable.
•spdsserv.parm is a sample SPD Server host parameter file. It sets the defaults for SPD
Server options. Use this file with the -PARMFILE option for the spdsserv command.
•rc.spds is a Bourne shell script to start a standard SPD Server environment.
•rc.perf is a Bourne shell script to start a standard Performance Server.
•killspds is a shell script that kills all processes for a UNIX user beginning with the
letters spds. Do not use the killspds script if you have any processes running in UNIX
that do not belong to SPD Server, but whose executable names begin with the letters
spds.
•killrc is a shell script that kills all processes related to a run of rc.spds. The killrc script
is selective. It does not kill SPD Server processes that are not related to core processes
started by rc.spds. Those core processes are initially started when rc.spds runs. The core
processes are typically spdsnsrv, spdsserv, spdsbase, spdslog, and spdssnet, based on
the rc.spds script the /samples directory.
•doc_examples.sas contains sample SAS code that is used in the SAS Scalable
Performance Data (SPD) Server 4.5: User's Guide documentation. This guide provides
SPD Server LIBNAME and data set usage and syntax options.
•verify.sas is a SAS installation verification job. You should run it after you install SPD
Server.
•spdsinst.sas demonstrates the simple use of WHERE clauses and WHERE planner
output.
•passthru.sas demonstrates SQL Pass-Through usage. It gives examples of simple,
single-level Pass-Through and secondary libref and connection scenarios.
•tempwork.sas demonstrates temporary LIBNAME domain support. Files created in a
temporary LIBNAME domain are automatically deleted when the SAS session ends.
•paraload.sas shows how to perform parallel loads from an existing table into an SPD
Server table. This technique exploits a parallel load capability in the LIBNAME proxy.
•aclcolrw.sas shows the use of ACL row and column security features.
14 Chapter 3 • SPD Server UNIX Installation Guide