Configuration Guide--SAS® 9.4 Foundation for UNIX ...

1 Configuration guide for SAS Foundation for unix Environments Copyright Notice The correct bibliographic citation for this manual is as follows: SAS Institute Inc. 2017. Configuration guide for SAS Foundation for unix Environments, Cary, NC: SAS Institute Inc. Configuration guide for SAS Foundation for unix Environments Copyright 2017, 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.

2 The scanning, uploading, and distribution of this book via the Internet or any other means without the permission of the publisher is illegal and punishable by law. Please purchase only authorized electronic editions and do not participate in or encourage electronic piracy of copyrighted materials. Your support of others rights is appreciated. Government Restricted Rights Notice: Use, duplication, or disclosure of this software and related documentation by the government is subject to the Agreement with SAS Institute and the restrictions set forth in FAR , Commercial Computer Software-Restricted Rights (June 1987). SAS Institute Inc., SAS Campus Drive, Cary, North Carolina 27513. September 2017 SAS Publishing provides a complete selection of books and electronic products to help customers use SAS software to its fullest potential.

3 For more information about our e-books, e-learning products, CDs, and hard-copy books, visit the SAS Publishing web site at 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. Configuration guide for SAS Foundation for unix Environments i 11 December 2017 Table of Contents Chapter 1 Introduction .. 1 Audience .. 1 Understanding This Book .. 1 Contacting SAS .. 1 Accessing Release Documentation .. 2 Additional Resources .. 2 Configuring Hadoop-related Software .. 2 Configuring your IO Subsystem .. 2 Troubleshooting System Performance Problems.

4 2 Chapter 2 Restricted Options .. 3 Global Restrictions .. 3 Group Restrictions .. 3 User Restrictions .. 3 Additional information .. 3 Chapter 3 Post-Installation Configuration for User Authentication and 5 Overview .. 5 Configuring User Authentication .. 6 Configuring sasauth .. 7 AIX-specific Options for Password Validation .. 9 Configuring PAM Authentication for Use with sasauth .. 10 Using the sasauth LDAP Authentication Method .. 11 Configuring the sasauth LDAP Authentication Method .. 12 Installing and Configuring LDAP/s Certificates .. 14 Example: Settings for LDAP/s .. 17 AIX: Using System LDAP Authentication with sasauth .. 17 Solaris: LDAP and Numeric User Names .. 17 Customizing Authentication and Identification .. 17 Chapter 4 Configuring Integrated Windows Authentication.

5 19 Prerequisites for Integrated Windows Authentication on unix .. 20 After Configuring Your Deployment .. 22 Logins for Users Who Participate in Integrated Windows Authentication .. 22 Using Custom Service Principal Names .. 23 Additional Documentation .. 23 Chapter 5 Post-Installation Configuration for Remote Browsing .. 25 Configuring a Host with a Fully Qualified Domain Name .. 26 Chapter 6 Supporting 64 KB pages on AIX Machines .. 27 Configuration guide for SAS Foundation for unix Environments ii Chapter 7 Post-Installation Configuration for National Language Support (NLS) .. 29 Introduction .. 29 SAS Invocation Scripts .. 29 SAS Configuration Files .. 30 Selecting a Locale during SAS Foundation Deployment .. 30 Chinese, Japanese, and Korean DBCS Support .. 31 Setting System Fonts with X Resource Files.

6 31 Asian Font Catalogs .. 32 Specifying the Font Catalog in the Configuration File for Traditional Chinese Fonts .. 32 Specifying the Font Catalog in a SAS Session for Traditional Chinese Fonts .. 32 Chinese Localizations .. 33 Chapter 8 Configuring SAS Analytics Accelerator for Teradata .. 35 UDF Installation Step Requires LATIN1 .. 35 Database Permission for Registering the UDFs .. 35 Database Requirements and Configuration .. 35 Registering the UDFs .. 36 Alternative to PROC FedSQL .. 37 Re-enable the Default HTML ODS Destination .. 37 Documentation for Using the UDFs .. 37 Chapter 9 Post-Installation Configuration for SAS/ACCESS Software .. 39 SAS/ACCESS Interface to Amazon Redshift .. 39 SAS/ACCESS Interface to Aster .. 43 Installing and Configuring the ODBC Driver and Bulk Loader.

7 43 SAS/ACCESS Interface to DB2 .. 45 SAS/ACCESS Interface to Greenplum .. 45 Bulk Load .. 48 SAS/ACCESS Interface to Hadoop .. 49 SAS/ACCESS Interface to HAWQ .. 49 Bulk Load .. 51 SAS/ACCESS Interface to Impala .. 52 SAS/ACCESS Interface to Informix .. 53 SAS/ACCESS Interface to Microsoft SQL Server .. 53 SAS/ACCESS Interface to MySQL .. 57 SAS/ACCESS Interface to Netezza .. 58 SAS/ACCESS Interface to ODBC .. 58 SAS/ACCESS Interface to Oracle .. 59 SAS/ACCESS Interface to PC Files .. 60 SAS/ACCESS Interface to the PI System .. 61 Multi-byte Character Sets .. 61 Host Name and Port Number .. 62 Time Zone Settings .. 62 SSL Certificate .. 62 Kerberos-only Web API Configuration .. 63 SAS/ACCESS Interface to PostgreSQL .. 63 SAS/ACCESS Interface to R/3 .. 63 Configuration guide for SAS Foundation for unix Environments iii SAS/ACCESS Interface to SAP ASE.

8 63 Installing SAP ASE Procedure .. 64 Adding Shared Libraries .. 64 SAS/ACCESS Interface to SAP HANA .. 64 Bulk Load .. 66 SAS/ACCESS Interface to SAP IQ .. 66 SAS/ACCESS Interface to Teradata .. 66 Access to Shared Libraries .. 66 Teradata Parallel Transporter .. 66 TPT or Legacy Teradata Utility (FastExport and Multiload) .. 67 Legacy Teradata Utility Configuration .. 67 FastExporting .. 67 MultiLoad .. 68 SAS/ACCESS Interface to Vertica .. 68 Chapter 10: Configuring and Administering SAS In-Database Products .. 71 Configuring and Administering SAS In-Database Technologies for Hadoop and SAS Data Loader for Hadoop .. 71 The Data Loader for Hadoop 72 Chapter 11 Post-Installation Configuration for SAS/ASSIST .. 73 Adding a Master Profile .. 73 Chapter 12 Post-Installation Configuration for SAS/CONNECT.

9 75 Storing and Locating SAS/CONNECT Script Files .. 75 Configuring the SAS unix Spawner Program .. 75 Chapter 13 Post-Installation Configuration for SAS/GRAPH .. 77 Loading SAS Fonts to Your X Display Server .. 77 Making System Fonts Available to SAS .. 77 Chapter 14 Post-Installation Configuration for SAS/IntrNet .. 79 Overview .. 79 Installing and Configuring SAS/IntrNet .. 80 Install Your Web Server Software .. 80 Install Your SAS Software .. 80 CGI Tools Installation Dialog Boxes .. 80 Installing CGI Tools and SAS Foundation on Machines with Different Operating Systems .. 82 Test the Web Server .. 83 Test the Application Broker .. 83 Configure a Socket Service .. 84 Starting the Socket Service .. 84 Testing the Socket Service .. 85 Configure Additional Services .. 86 Chapter 15 Post-Installation Configuration for SAS/SECURE.

10 87 SAS/SECURE Client for Windows .. 87 SAS/SECURE Client for Java .. 87 FIPS-Compliant Encryption .. 87 Configuration guide for SAS Foundation for unix Environments iv Chapter 16 Post-Installation Configuration for SAS/SHARE .. 89 User Authentication .. 89 System Configuration for the TCP/IP Communications Method (Optional) .. 89 Client Components .. 89 SAS/SHARE Data Provider .. 89 SAS ODBC Driver .. 89 SAS/SHARE Driver for JDBC .. 90 SAS/SHARE SQL Library for C .. 90 NLS Information .. 90 Chapter 17 Using Host Sort Routines .. 91 Making Host Sort Routines Available .. 91 For AIX .. 91 For HP-UX, Linux, and Solaris .. 91 Using Host Sort Routines in a SAS Session .. 91 Configuration guide for SAS Foundation for unix Environments Page 1 Chapter 1 Introduction Audience This document is intended for the SAS Installation Representative, designated as the person responsible for installing and maintaining SAS software for unix systems at your site.