User manual SAS 9.2 INTELLIGENCE PLATFORM ADMINISTRATION GUIDE SECOND EDITION

[. . . ] SAS 9. 2 Intelligence Platform System Administration Guide Second Edition ® The correct bibliographic citation for this manual is as follows: SAS Institute Inc. SAS ® 9. 2 Intelligence Platform: System Administration Guide, Second Edition. SAS® 9. 2 Intelligence Platform: System Administration Guide, Second Edition Copyright © 2010, SAS Institute Inc. , Cary, NC, USA All rights reserved. Produced in the United States of America. [. . . ] To minimize the impact of the character variable analysis on the SAS Metadata Server host, direct the backup copies that you want to analyze to a network-accessible drive, and execute %OMARUNAN on that computer. Note that %OMARUNAN must be executed in the same operating environment that was used to create the backups. It is not necessary to perform character variable analysis on a regular basis. Character variable usage is unlikely to change much unless you add or delete a significant percentage of metadata from the total metadata in a repository. Execute %OMARUNAN after metadata is first loaded in SAS Metadata Repositories and after significant updates are applied. Note: If you run %OMABAKUP on an analyzed backup location in restore mode before the optimizations are applied, the %OMARUNAN optimizations will be lost. The restore process deletes the DS_VCHAR data sets that contain the optimizations from the backup directories before restoring repositories to their registered locations. 4 Recovering Memory on the SAS Metadata Server The SAS Metadata Server supports two approaches for quickly recovering memory on a running server: 3 Issue a Pause action followed by a Resume action. The Pause action instructs the SAS Metadata Server to stop accepting new client requests and closes the repository containers. The Resume action resumes client activity. Repository containers are re-opened as clients request metadata from them. The Reset action pauses and resumes the metadata server in one step. Pause, Resume, and Reset actions can be issued in SAS Management Console. See "Use SAS Management Console to Stop, Pause, Resume, or Reset the SAS Metadata Server" on page 65. Pause and Resume actions can also be issued by using PROC METAOPERATE. See SAS Language Interfaces to Metadata. 178 179 PART 6 Deleting SAS Metadata Repositories 181 Managing SAS Metadata Repositories Chapter 15. . Creating, Registering, Moving, Copying, Renaming, and 180 181 CHAPTER 15 Creating, Registering, Moving, Copying, Renaming, and Deleting SAS Metadata Repositories About SAS Metadata Repositories 181 About SAS Metadata Repository Access Modes 182 Create a Custom Repository 183 Change the Properties of a Metadata Repository 184 Copying, Promoting, Importing, and Exporting Your Metadata 185 Tools for Copying, Promoting, Importing, and Exporting Metadata 185 About the Metadata Manager Import and Export Wizards 187 Moving a Metadata Repository to a New Location on the Same Metadata Server Porting a Metadata Repository to a Different Host Environment 189 About the %OMAPORT Macro 189 %OMAPORT Autocall Macro: Reference 189 Syntax 189 Syntax Description 189 Details 190 Registering a Metadata Repository 191 Unregistering a Metadata Repository 192 Deleting a Metadata Repository 193 188 About SAS Metadata Repositories A metadata repository is a physical location in which a collection of related metadata objects is stored. Metadata repositories are managed by a repository manager, which is a library of tables that define the set of repositories that can be accessed by a SAS Metadata Server. A metadata server cannot be started without a repository manager. Each metadata server can have only one repository manager. The SAS Metadata Server supports three types of metadata repositories: Foundation repositories are the required metadata stores for SAS Metadata Servers. Each metadata server has one foundation repository that is created by default when the metadata server is configured. [. . . ] The data is queried using the multidimensional expressions (MDX) language. SAS Open Metadata Architecture a general-purpose metadata management facility that provides metadata services to SAS applications. The SAS Open Metadata Architecture enables applications to exchange metadata, which makes it easier for these applications to work together. SAS Open Metadata Interface a set of methods that enable users to read metadata from or write metadata to the SAS Metadata Server. SAS Pooled Workspace Server a SAS Workspace Server that is configured to use server-side pooling. In this configuration, the SAS object spawner maintains a collection of workspace server processes that are available for clients. SAS Stored Process a SAS program that is stored on a server and defined in metadata, and which can be executed by client applications. Short form: stored process. SAS Stored Process Server a SAS IOM server that is launched in order to fulfill client requests for SAS Stored Processes. SAS system option an option that affects the processing of an entire SAS program or interactive SAS session from the time the option is specified until it is changed. [. . . ]