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. 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. [. . . ] %OMABAKUP also creates the OMA_Varan. sas7bcat catalog that is used by %OMARUNAN. The creation of this catalog has two implications for running %OMARUNAN: 3 The catalog is created to the specifications of the host operating environment; therefore, you need to execute %OMARUNAN in the same operating environment in order to be able to read the catalog. That is, if the backups are created on a UNIX host, then you need to execute %OMARUNAN from another UNIX host. 3 The information in OMA_Varan. sas7bcat reflects the last backup that was made. That is, if a full backup was made, then OMA_Varan. sas7bcat contains information to analyze all repositories that are registered on the SAS Metadata Server. Because %OMARUNAN does not interact directly with the SAS Metadata Server, no special user IDs or server privileges are required to execute the macro. However, the user executing the macro needs full operating system access to the SAS Metadata Server backup destination path and all subdirectories. Managing Metadata Server Performance 4 Recovering Memory on the SAS Metadata Server 177 %OMARUNAN Autocall Macro: Reference The %OMARUNAN macro analyzes SAS metadata repositories for information to optimize their memory usage. Syntax %OMARUNAN(DESTINATIONPATH="pathname") Syntax Description DESTINATIONPATH specifies the path to a SAS Metadata Server backup directory. %OMARUNAN reads a VarAnalyzeAll source entry in an OMA_Varan. sas7bcat catalog in this directory to locate and analyze the repository backups in the specified location. Details The %OMARUNAN macro must be executed on a computer that has SAS software installed. 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. Repository containers are re-opened as clients request metadata from them. 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. [. . . ] The SAS Metadata Server uses the Integrated Object Model (IOM), which is provided with SAS Integration Technologies, to communicate with clients and with other servers. SAS OLAP Cube Studio a Java interface for defining and building OLAP cubes in SAS System 9 or later. Its main feature is the Cube Designer wizard, which guides you through the process of registering and creating cubes. SAS OLAP Server a SAS server that provides access to multidimensional data. 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. [. . . ]