User ManualTable of ContentsContents3Product Notes7SPD Server 4.5 Product Notes9Overview9What's New in SPD Server 4.5?9Overview of SPD Server 4.59SPD Server 4.5 Platform Support Changes10Installation11SPD Server Pre-Installation and System Requirements Guide13AIX Requirements and Tuning for 64-bit SPD Server13HP-UX Requirements and Tuning for 64-bit SPD Server13System Requirements13Kernel Tuning Requirements14Required Patches14Solaris on Sparc Requirements and Tuning for 64-bit SPD Server15System Requirements15Solaris on X64 Requirements and Tuning for 64-bit SPD Server15System Requirements15Linux on X64 Requirements and Tuning for 64-bit SPD Server15System Requirements15Windows Requirements and Tuning for 32-bit SPD Server16System Requirements16SPD Server 4.5 Client Requirements16System Requirements16SPD Server UNIX Installation Guide17SAS Scalable Performance Data Server 4.5 and SAS Deployment Wizard18Before You Install: Precautions and Required Permissions18Packing List for SPD Server Distribution19Directory Contents19Upgrading SPD Server 3.x to SPD Server 4.521Overview of Upgrading from SPD Server 3.x to SPD Server 4.521Upgrading SPD Server 4.x to SPD Server 4.522Overview of Upgrading from SPD Server 4.x to SPD Server 4.522Configuring SPD Server Host Software for Your Site22Verify That SPD Server 4.5 Is Running28Configuring SPD Server Client Software29Testing Your SPD Server Installation Using SAS30SPD Server Command Reference32SPD Server Name Server Commands32SPD Server Host Commands33SNET Server Commands35Password Utility Reference36Performance Server Reference36SPD Server 4.5 and the SAS Management Console Utility36SPD Server Lightweight Directory Access Protocol (LDAP) Authentication36Notes for SPD Server Administrators38UNIX User IDs38SPD Server User IDs39LDAP Password Authentication39Troubleshooting40Name Server Start-Up Failed40SPD Server Host Start-Up Failed40SAS LIBNAME Assignment Failed40Using SETINIT to Extend SPD Server Software42SPD Server Windows Installation Guide43SAS Scalable Performance Data Server 4.5 and SAS Deployment Wizard44Before You Install: Precautions and Required Permissions44Packing List for SPD Server Distribution44Directory Contents44Validating Default Port and Library Assignments47Initializing the Password Manager Database48Installing SPD Server as a Service48Configuring SPD Server Software on Your Windows Host50Upgrading SPD Server 3.x to SPD Server 4.552Overview of Upgrading52Upgrading SPD Server 4.4 to SPD Server 4.552Installing and Configuring SPD Server Clients52Testing Your SPD Server Installation Using SAS53SPD Server Command Reference54Name Server Commands55SPD Server Host Commands55SNET Server Commands57PSMGR Password Utility57SPD Server and the SAS Management Console57Lightweight Directory Access Protocol (LDAP) Authentication58Notes for SPD Server Administrators59SPD Server User IDs59Troubleshooting60Overview of Troubleshooting60Name Server Startup Failed60SPD Server Host Startup Failed60SAS LIBNAME Assignment Failed60Using SETINIT to Extend SPD Server Software62Migration63SPD Server 3.x to SPD Server 4.5 Conversion Utility65Introduction65Before You Convert65Overview of the SPDSCONV Utility66Using SPDSCONV67SPDSCONV Utility Examples68§68Converting a Simple Table68Converting Tables and Recreating Indexes69Configuration71Using the SPD Server Name Server to Manage Resources73Managing Computing Resources with a Name Server73Configuring SPD Server on a Corporate Network73Inventory Available Corporate Network Servers73Running the Name Server on Machine Namecpu74Configuring SPD Server on Worldcpu74Setting Up asiacpu, the Asia Departmental Server74Which SAS Program Statement Runs Where?75Administering and Configuring SPD Server Using the SAS Management Console77The SAS Management Console77Accessing the SPD Server Manager in SAS Management Console78Password Manager78Overview of the Password Manager78Connecting to an SPD Server79Users and Groups80ACL Manager83Overview of the ACL Manager83Listing ACL Resources84Adding an ACL Resource85Deleting an ACL Resource86Adding a User or Group to an ACL Resource86Changing Resource Permissions86Server Manager87Overview of the Server Manager87Refresh Domains87Refresh Parms88Perform Commands88SPD Process Profiler89Proxy Manager91Overview of the Proxy Manager91Proxy Refresh92Proxy Interrupt92Proxy Cancel93SPD Server SQL Query Rewrite Facility95Overview of the SQL Query Rewrite Facility95Configuring Storage Space for the SQL Query Rewrite Facility95SQL Query Rewrite Facility Options96_QRWENABLE Option:96_QRW Option:97Using SPD Server With Other Clients99Overview99Using Open Database Connectivity (ODBC) to Access SPD Server Tables100Why Use ODBC?100Installing OBDC Drivers on the Server101Configuring ODBC on the Client101Preparing your Client Machine for ODBC Installation102Two Types of ODBC Connections102Primary and Secondary LIBNAME Domains103Configuring an ODBC Data Source to Connect Directly to an SPD Server103Configuring an ODBC Data Source for SPD SNET104Editing the Services File on Your Machine - ODBC Details104Creating a Query Using an ODBC-Compliant Program105Using JDBC (Java) to Access SPD Server Tables105Why Would I Want to Use JDBC?105How Is JDBC Set Up on the Server?106How Is JDBC Set Up on the Client?106How Do I Use JDBC to Make a Query?106JDBC Code Examples and Tips107Limitations of Using JDBC with the SPD Server108Using htmSQL to Access SPD Server Tables108Why Would I Want to Use htmSQL?108How Is htmSQL Set Up on the Server?109How Is htmSQL Set Up on the Client?109How Do I Use htmSQL to Make a Query?110Examples of Setting Up an htmSQL Web Page110Using SQL C API to Access SPD Server Tables110Why Would I Want to Use SQL C API?110Configuring Disk Storage for SPD Server111Introduction111SPD Server Component File Types and Sizes111Creating SPD Server Component Files112Which Component Files Are Created for SPD Server Tables?112Which Component Files Are Created for Indexes on SPD Server Tables?112Configuring LIBNAME Domain Disk Space112Example 1: Primary File System Storage for All Component Files112Example 2: Using ROPTIONS= to Store SPD Server Table Data and Index Component Files in Other File Systems113Example 3: Adding More File Systems to a Path Option When Its File System Is Full114Recommended: Use ROPTIONS=114Setting Up SPD Server Parameter Files117Introduction118Syntax for the -PARMFILE Option118Syntax for the spdsserv.parm Options118spdsserv.parm Options119BINBUFSIZE=119FMTDOMAIN=119FMTNAMENODE=119FMTNAMEPORT=119GRPBYROWCACHE=119IDLE_TIMEOUT=120INDEX_MAXMEMORY=120INDEX_SORTSIZE=120LDAPSERVER=120LDAPPORT=121LDAPBINDMETH=121LDAPBINDDN=121MINPORTNO=/MAXPORTNO=121MAXGENNUM=121MAXSEGRATIO=122MAXWHTHREADS=122MINPARTSIZE=122[NO]BYINDEX122[NO]COREFILE122[NO]LDAP123[NO]NLSTRANSCODE123[NO]WHERECOSTING123RANDOMPLACEDPF123RANIOBUFMIN=124SEQIOBUFMIN=124SORTSIZE124SQLOPTS=124TMPDOMAIN=124WORKPATH=125SPD Server Parameter File Configurations for LDAP125LDAP Server That Is Running on an SPD Server Host125LDAP Server Running on SPD Server Host Using Port Other Than LOCAL_HOST125LDAP Server and SPD Server Host That Are Running On Different Machines125SPD Server User IDs and Passwords That Are Not In Their Default Location in the LDAP Database126SPD Server User IDs and Passwords That Are Not In Their Default Location in the LDAP Database and in the LDAP Server That Is Using TCPIP_PORT126SPD Server Parameter File Configurations for Auditing126[NO]WHEREAUDIT126WHAUDLEN=127SQLAUDLEN=127Setting Up SPD Server Libname Parameter Files129Introduction129Domain Naming Syntax for Libnames.parm130Domain Path Options130Overview of Data Path Options130DATAPATH=131INDEXPATH=131WORKPATH=131METAPATH=132Consistency in Nomenclature132Domain Access Options133OWNER=133LIBACLINHERIT=133DYNLOCK=136Organizing Domains for Scalability137Overview of Organizing Domains137Data Table Space137Index Table Space138Metadata Table Space138Work File Space138Domains and Data Spaces139Overview of Domains and Data Spaces139Permanent Table Space140Semi-Permanent Table Space141Temporary Table Space141Example Libname.parm File Configurations142Example 1: Minimum Configuration for Domain Declaration142Example 2: Specify Domain Paths for Data, Index, and Workspace Tables142Example 3: Query-Rewrite Domain Configuration143Example 4: Multiple Domain Types and Paths Configuration144Setting Up SPD Server Performance Server147Introduction147Starting the SPD Server Performance Server148Overview of Starting the Performance Server148Start Performance Server from Command Line149Start Performance Server from Rc.perf Script149Sample Rc.perf Script150Performance Server Log File152Security153ACL Security Overview155ACL Security Overview156SPD Server ACL Security Model156Overview of the ACL Security Model156Enabling ACL Security157Disabling ACL Security159Controlling SPD Server Resources with PROC SPDO and ACL Commands160Using PROC SPDO160Using ACL160ACL Concepts161Overview of the ACL Command Set163SET ACLTYPE memtype;164SET ACLUSER [name];164ADD ACL acl1 acl2... [C=cat T=type] [/options]164ADD ACL Examples165MODIFY ACL and MODIFY ACL _ALL_166MODIFY ACL Examples167LIST ACL and LIST ACL _ALL_168LIST ACL Examples169DELETE ACL and DELETE ACL _ALL_170DELETE ACL Examples170Symbolic Substitution171Symbolic Substitution Row Level Security171Symbolic Substitution Example171ACL Security Examples173DICTIONARY.PWDB and DICTIONARY.ACLS192Overview of Dictionaries192Example - Listing the Users in the Password Database using SQL Pass-Through193Example - Listing ACL Objects using SQL Pass-Through193Using SPD Server with an Internet Firewall194Overview of Using SPD Server with a Firewall194Assigning SPD Server Ports that Require Firewall Access194SPD Server Auditing195Overview of SPD Server Auditing195Proxy Auditing196WHERE Clause Auditing197SQL Query Auditing197Managing SPD Server Passwords, Users, and Table ACLs199Introduction199The Password Manager Utility psmgr199Overview of the psmgr Utility199Invoking the psmgr Utility200Converting to a psmgr 4.x Table200Adding New Users with psmgr201psmgr Commands203psmgr Command Details203Using a File as Input to psmgr209SAS Management Console210Overview of SAS Management Console210LDAP User Authentication210LDAP Authentication Notes210Overview of LDAP Authentication210Configuring LDAP Authentication211System Management213SPD Server Operator Interface Procedure (PROC SPDO)215Special SPDO Commands215Overview of SPDO Commands215SPDO Command Examples216LIBNAME Proxy Commands216Overview of Proxy Commands216LIBNAME Proxy Command Examples217Privileged OPER Commands219TRUNCATE Command and Example220Refreshing SPD Server Parameter and LIBNAME Files221The REFRESH Command221REFRESH Command Examples221Commands to Nonexistent Users222SPD Server Index Utility Ixutil225The Index Utility Ixutil225Ixutil Usage225Ixutil Options226Ixutil Examples227Create a Hybrid Index227Retrieve Disk Usage and Fragmentation Statistics228Retrieve Index Distribution Statistics229Reorganize the Index230Review Disk Usage Statistics230Create a Join Index231Generate Join Index Statistics231Delete the Join Index232SPD Server Table List Utility Spdsls233SPD Server Table List Utility Spdsls233Description233Usage233Options234Return Values235Spdsls Examples235SPD Server Backup and Restore Utilities237Introduction238Overview of the SAS Scalable Performance Data Server Backup and Restore Utilities238Using Utilities with SPD Server239SPD Server Utilities Path Requirements239Compatibility with Previous Versions239Privileged Access Protection239Spdsbkup - the Table Backup Utility240Description240Important Details about Full Backup240Important Details about Incremental Backup240Return Values240Backup Requirements241Client Access to an SPD Server Domain241LIBNAME Created with BACKUP= Option241Example Libnames.parm Statements241Backup Usage242Backup Options242Backup Return Values244Backup Data File244Backup Data File Nomenclature244Backup Data File Extensions245Backup Table of Contents File245Backup User Messages246Confirm Your Backup Job Status246Successful Backup246Warning: Table Cannot Be Backed Up246Failed Backup246Spdsrstr - the SPD Server Table Restore Utility246Restore Description246Restore Requirements247Restore Syntax247Restore Options247Restore Return Values249Restore User Messages249Restore Usage Examples249Using PROC SPDO to Back Up and Restore SPD Server Tables252Back Up and Restore Table Indexes using SPD Server Full Backups253Back Up and Restore SPD Server Table Indexes using System Full Backups254Back Up and Restore SPD Server Table Indexes Using System Full Backups254Method 1 – Restore the Index Dynamically254Method 2 – Recreate the Index after the Table Is Restored254SPD Server Directory Cleanup Utility257Introduction257Using the Directory Cleanup Utility Spdsclean258Spdsclean Wildcards and Pattern Matching258Spdsclean Options258Spdsclean Options That Define Actions258Spdsclean Options that Modify Behavior259Spdsclean Examples260Cleaning WORKPATH Files on Your Server260Cleaning Residual Temporary LIBNAME Domain Files261Cleaning Specific LIBNAME Domains261Cleaning Other LIBNAME Domain File Classes261Cleaning WORKPATH and LIBNAME Combinations261Cleaning Log Files262Cleaning WORKPATH, LIBNAME Domain and Log Files262Glossary262SPD Server Debugging Tools265Introduction265SPD Server 4.5 LIBNAME Statement Debug Options265DEBUG=265ALTPATH=266SPD Server 4.5 Server Parameter File Debug Options266ALTBINPATH=267RECORDFLAGS=267Size: 5.33 MBPages: 271Language: EnglishOpen manual
