Contents
About
Title Page
What's New in System Administration for the SAS 9.3 Intelligence Platform
Getting Started
Introduction to the SAS Intelligence Platform: System Administration Guide
About the SAS Intelligence Platform: System Administration Guide
Prerequisites for Using the SAS Intelligence Platform: System Administration Guide
Accessibility Features in the SAS Intelligence Platform Products
Understanding the State of Your System
Overview of the State of Your System
Overview of SAS Management Console
Overview of SAS Deployment Manager and SAS Web Administration Console
Overview of the SAS Metadata Server and Its Initial Configuration
Overview of SAS Application Server Components and Their Initial Configuration
Overview of Other SAS Servers and Spawners
Overview of Ports
Overview of the Configuration Directory Structure
Overview of Configuration Files
Overview of Initial Roles, Groups, and Users
Who Can Do What: Credential Requirements for SAS Management Console Tasks
About Security for System Administration Tasks
Who Can Do What in the Metadata Manager Plug-in
Who Can Do What in the Server Manager Plug-in
About Adding Users to the SAS Administrators Group
Requirements for Accessing a Standard Workspace Server
Clearing the Credentials Cache
What to Do Next: Administration Tasks
Overview of Administration Tasks
First-Priority Setup Tasks
Standard Setup Tasks
Optional Setup Tasks
Ongoing System Administration Tasks
Best Practices for Ensuring the Integrity of Your System
Starting, Stopping, and Checking the Status of Servers
Operating Your Servers
Overview of Server Operation
Running Servers as Windows Services
Starting and Stopping SAS Servers on z/OS
Using the sas.servers Script on UNIX or z/OS to Start or Stop All Servers
Running Servers as UNIX Daemons
Using Scripts to Operate SAS Servers Individually
Using SAS Management Console to Operate SAS Servers
Starting and Stopping Web Application Servers
Checking the Status of Servers
About Checking the Status of Servers
Use a Server Script to Display the Status of a Server or Spawner
Checking the Access State and Other Properties of the SAS Metadata Server
Checking the Access State of Metadata Repositories and the Repository Manager
Check the Status of the Object Spawner
Validate the SAS Metadata Server, SAS Workspace Servers, SAS Pooled Workspace Servers, SAS Stored Process Servers, and SAS OLAP Servers
Validate the SAS Content Server and the SAS Framework Data Server
Using the Deployment Tester
Deployment Tester Overview
Prerequisites for Using the Deployment Tester
Deployment Tester Test Suites: Descriptions and Requirements
Adding Tests to the Deployment Tester
Using the Deployment Tester Interactively from SAS Management Console
Using the Deployment Tester Batch Client
System Monitoring and Logging
Monitoring the Activity of SAS Servers
About SAS Server Monitoring
Using SAS Management Console to Monitor SAS Servers
Using the Server Performance Counters and Information Fields
Using the SAS OLAP Server Monitor
Using Third-Party Products to Monitor SAS Servers
Administering Logging for SAS Servers
About Server Logging
About Metadata Server Loggers
Enabling Server Logging
Initial Logging Configuration for SAS Servers
Modifying Your Server Logging Configurations
Enable More Detailed Logging for Server Troubleshooting
Create a Log File for Workspace Server Troubleshooting
Enable More Detailed Logging for SAS Object Spawner Troubleshooting
Collecting ARM Log Information for SAS Data Integration Studio Jobs
Collecting ARM Log Information in SAS OLAP Servers
Audit Server Logging Level Changes That Originate in Client Applications
Capture Metadata Server Management Events in the System Facility Appender
Capture XML Information in the SAS Metadata Server Log
Configuring and Running Job Statistics Reports for SAS Data Integration Studio
About SAS Data Integration Studio Job Statistics Reports
Configure Job Statistics Reporting for SAS Data Integration Studio
Creating Job Statistics for the SAS Data Integration Studio Job Statistics Reporting Package
Accessing the SAS Data Integration Studio Job Statistics Reports
Removing Historical Data from the Job Statistics Library
Backing Up and Restoring Your SAS Content
Best Practices for Backing Up and Restoring Your SAS Content
About Backups and Restores
About the Metadata Server Backup Facility
Using Operating System Commands to Back Up the Metadata Server
About Using the Export SAS Package Wizard to Back Up Specific SAS Folders
Best Practices for Backing Up Your SAS Content
Best Practices for Restoring Your SAS Content
Backing Up and Recovering the SAS Metadata Server
About the SAS Metadata Server Backup and Recovery Facility
SAS Metadata Server Backup Tasks
Recovering the SAS Metadata Server
Viewing Backup and Recovery History
What to Do If the SAS Metadata Server Is Unresponsive
What to Do If the SAS Metadata Server Is Unresponsive
Administering the SAS Metadata Server
Metadata Server Configuration Tasks
Overview of SAS Metadata Server Configuration
Configuring the Number of Threads Used by the Metadata Server
Configuring Metadata Server Journaling
Managing Alert E-mail Options for the SAS Metadata Server
Managing Metadata Server Memory
Setting the Server's MEMSIZE Parameter
Input and Output Balancing
Configuring Concurrent Queries and Clients
Note to Users of 32-Bit Windows Systems
Using optimizeIMDB to Optimize and Report on Metadata Server Memory Usage
Recovering Memory on the SAS Metadata Server
Managing SAS Metadata
Managing SAS Metadata Repositories
About SAS Metadata Repositories
About SAS Metadata Repository Access Modes
Create a Custom Repository
Change the Properties of a Metadata Repository
Copying, Promoting, Importing, Exporting, and Analyzing Your Metadata
Moving a Metadata Repository to a New Location on the Same Metadata Server
Registering a Metadata Repository
Unregistering and Re-registering a Metadata Repository
Deleting a Metadata Repository
Analyzing and Repairing Metadata
Working with SAS Folders
About the SAS Folder Structure
Using Search Folders and Favorites Folders
Best Practices for Managing SAS Folders
Best Practices for Maintaining Associations among Objects in SAS Folders
Using the BI Lineage Plug-in
Customizing Your Folder Structure
Using the Promotion Tools
Promotion Tools Overview
Introduction to the Promotion Tools
Features of the Promotion Tools
Preparing to Use the Promotion Tools
About the Promotion Tools Documentation
Using the Export SAS Package and Import SAS Package Wizards
About the Export SAS Package and Import SAS Package Wizards
Accessing the Export SAS Package and Import SAS Package Wizards
Example Usage Scenario for Export SAS Package and Import SAS Package Wizards
Using Advanced Features of the Import and Export Wizards
Using the Batch Export and Import Tools
About the Batch Export and Import Tools
Preparing to Use the Batch Export Tool or the Batch Import Tool
Accessing the Batch Export and Import Tools
Using the Batch Export Tool
Using the Substitution Properties File
Using the Batch Import Tool
Viewing the Batch Export or Import Log
Using the Batch Import Tool to Import a Package That Was Created by the Export SAS Package Wizard
Using the Import SAS Package Wizard to Import a Package That Was Created by the Batch Export Tool
Using the Batch Import Tool to Import a Package That Was Created in SAS 9.1.3
Reference Information for Promotion Tools
About the Reference Information for Promotion Tools
Promotion Details for Specific Object Types
Types of Physical Content That Are Promoted with Metadata Objects
Special Considerations for Promoting Content to SAS 9.3 from an Earlier SAS Version
Troubleshooting the Promotion Tools
Appendixes
Default SAS Ports
Overview
Default Port Numbers for SAS Servers and Spawners
Default Port Numbers for SAS Middle-Tier Applications
Default Port Numbers for Third-Party Software
Port Numbering in a Multiple-Level Environment
Reference: Configuration Directories
Introduction to the Configuration Directory Reference
Contents of the Levn Subdirectory
Contents of the Metadata Server Subdirectory (SASMeta)
Contents of the Application Server Subdirectory (SASApp or SASMain)
Contents of the Web Subdirectory
Default Locations for Server Logs
Default Locations for Server Logs
Configuration Files
Reference: Configuration Files for SAS Servers
Reference Information for omaconfig.xml
Options for the Metadata Server Invocation Command
Modifying the Metadata Server Invocation Options
Recommended Parameters
Optional Parameters
Using the SAS Deployment Manager to Update Host Name References
Overview of Updating Host Name References
Process for Updating Host Name References
Troubleshooting the Update Host Name References Tool
Example Scenarios for Updating Host Name References
Performing SAS 9.3 to SAS 9.3 Migration
About Using the SAS Migration Utility to Copy an Existing Deployment
About the SAS Migration Utility
Overview of the SAS 9.3 to SAS 9.3 Migration Process
Step 1: Design Your Migration
Step 2: Perform Pre-migration Tasks
Step 3: Run the SAS Deployment Wizard and Migrate Your SAS Content
Step 4: Complete Manual Migration Steps
Step 5: Validate the New Environment
Step 6: Maintain and Update the New Environment
Recommended Reading
Glossary
Product
Release
SAS Enterprise BI Server
9.3
SAS BI Server
9.3
SAS Enterprise Data Integration Server
9.3
SAS Data Integration Server
9.3
SAS Metadata Server
9.3
Type
Administration
Copyright Date
August 2012
Last Updated
26Mar2013