Contents
About
Title Page
About This Book
Introduction
General Overview
Introduction to SAS IT Resource Management
Architecture and Basic Principles for Data Administrators
How to Locate Documentation
National Language Support (NLS)
Terminology Changes
Accessibility
Preparing to Work with the SAS IT Resource Management Client
Working with SAS Management Console
Working with SAS Enterprise Guide
Working with Metadata
Additional Requirements for z/OS
Working with the SAS IT Resource Management Client
Overview of the SAS IT Resource Management Client
Features of the SAS IT Resource Management Client
Working with Wizards
SAS IT Resource Management Transformations
Icons for SAS IT Resource Management Objects
Accessing and Processing IT Data
IT Data Mart
About the IT Data Mart
Working with IT Data Marts
Importing, Exporting, and Promoting Metadata
Adapters
About Adapters
Working with Template Tables
Maintaining Template Tables and Staged Tables Based on Adapter Changes
Formulas
About Formulas
Working with Formulas
Staging the Data
About Staging the Data
Working with Staging Transformations
Working with Staged Tables
Columns in Staged Tables
Computed Columns in Staged Tables
Staging VMware Data Using Local Time
Creating Views for MXG Tables
Understanding External Names of Staged Tables and Columns
Insufficient Disk Space
Aggregating the Data
Overview of the Aggregation Transformation
About Aggregation Tables
Preparing to Create an Aggregation Table
Creating an Aggregation Table with the Simple Aggregation Table Wizard
Creating Aggregation Tables with the Summarized Aggregation Table Wizard
Creating Aggregation Tables with the Aggregation through the Template Wizard
Cloning an Aggregation Table
Adding a New Column to an Aggregation Table
Deleting an Aggregation Table
Editing or Modifying an Aggregation Table
Publishing an Aggregation Table as Template
Purging Contents of an Aggregation Table
Renaming an Aggregation Table
Indexing an Aggregation Table
Create a View of a Simple Aggregation Table for Source Tables Supported by MXG
Working with Aggregation Transformations
Working with Aggregation Transformation Filters
Adapter Setup Wizard
About the Adapter Setup Wizard
Using the Adapter Setup Wizard
What Does the Adapter Setup Wizard Create?
Domain Categories
Deploy and Run Jobs That the Adapter Setup Wizard Creates
Information Maps
About Information Maps
About Information Map Transformations
User-Specified Information Map Transformations
Information Map Objects That Are Generated by the Adapter Setup Wizard
Working with Information Map Filters
Using SAS Information Map Studio
Troubleshooting Information Maps Problems
User-Written Staging Code
User-Written Staging Transformations
What Are the Properties of the User-Written Staging Transformation?
Guidelines for Processing Data with User-Written Staging Transformations
Working with User-Written Staging Transformations
Using the Additional Generated Code
Jobs
Jobs That Process IT Data
Working with Jobs
Running Jobs
Appendixes
SAS IT Resource Management Components
Data Sources Supported by SAS IT Resource Management Adapters
Data Sources Supported by SAS IT Resource Management Adapters
Supported Adapters
MXG Adapters — Accessing Raw Data
BMC Perf Mgr — Accessing Raw Data
CSV — Accessing Raw Data
DT Perf Sentry — Accessing Raw Data
HP Perf Agent — Accessing Raw Data
RRDtool — Accessing Raw Data
SAR — Accessing Raw Data
SNMP — Accessing Raw Data
Web Log — Accessing Raw Data
Database Adapters: SAP ERP, HP Reporter, MS SCOM, and VMware
Working with Custom Tables
Working with MXG Code to Stage Data
How MSU and MIPS Columns Are Included in Staged Tables for the SMF Adapter
VMware vCenter Data Acquisition Jobs
Staging Parameters
Staging Parameters
Staging Parameters for Supported Adapters
User-Written Staging Parameters
Jobs That the Adapter Setup Wizard Creates for Domain Categories
Duplicate-Data Checking
Duplicate-Data Checking Overview
How Is Data Checked for Duplicates?
Control Data Sets for Duplicate-Data Checking
Working with Duplicate-Data Checking Macros
How to Implement Duplicate-Data Checking from a Staging Transformation
Additional Details for SAP ERP, MS SCOM, and HP Reporter Adapters
Duplicate-Data Checking for User-Written Staging Code
Examples
Data Model
Overview of the SAS IT Resource Management Data Model
Data Model Adapter and Domain Category Specifications
What Are Key Metrics?
Key Metrics for the Server Performance Domain Category
Naming Standards
About Naming Standards for SAS IT Resource Management Objects
Naming Standards and Location of Objects
Macros
Introduction to the Macros in SAS IT Resource Management
%RMDELETE
%RMDELPVT
Duplicate-Data Checking Macros
%RMMSBMCP
%RMMSDTPS
%RMMSSCOM
%RMMSSNMP
%RMPROINT
%RMRUNETL
%RMVINST
Backup and Recovery Macros
Best Practices and Troubleshooting Tips
How to Back Up SAS IT Resource Management
Debugging Problems in SAS IT Resource Management
Tips for Working with SAS IT Resource Management Client
Tips for Working with the IT Data Mart
Tips for Working with Aggregations
Tips for Working with Information Maps
Tips for Installing and Configuring SAS IT Resource Management
Handling Holidays
Performance Issues
Statistics
Recommended Reading
Product
Release
SAS IT Resource Management
Type
Administration
Copyright Date
June 2012
Last Updated
23Aug2013