%RMMSSCOM :: SAS(R) IT Resource Management 3.3: Administrator's Guide

%RMMSSCOM

%RMMSSCOM reads a management pack file in XML format and creates table and column metadata and formats for the SAS IT Resource Management SCOM adapter. If the management pack is sealed, you need to unseal it first to get the XML file.

Note: Run this program only after you have created an IT data mart and a job that contains an SCOM transformation.

%RMMSSCOM Syntax

%RMMSSCOM(
MPFILE=path-and-filename-of-the-management-pack
,METAPASS=user-password
,METASERVER=name-of-metadata-server
,METAUSER=user ID
,OUTPUTFILEPATH=path-of-output-text-file
,<APPSERVER=name-of-application-server>
,<FILEDEVICE=type-of-device>
,<FILENOOFVOLUMES=number-of-volumes>
,<FILESPACEPRIMARY=primary-space-allocation>
,<FILESPACESECONDARY=secondary-space-allocation>
,<JOBID=metadata-id-of-staging-job>
,<CREATEMETADATA=Yes | No>
,<METAPORT=metadata-server-port>
,<METAREPOSITORY=name-of-metadata-repository>
);

%RMMSSCOM Required Arguments

MPFILE=path-and-filename-of-the-management-pack

specifies the path to the management pack.
METAPASS=user-password

specifies the password that is associated with the metauser ID.

Note: The password can be in plain text or encoded. You can use PROC PWENCODE to encode the password.
METASERVER=name-of-metadata-server

specifies the name of the metadata server.
METAUSER=user-ID

specifies the user ID that is to access the metadata server. The user must be able to read and write metadata in the IT data mart.
OUTPUTFILEPATH=path-of-output-text-file specifies the path for a temporary text file called Temp_RMMSCOM.txt. This file will contain the data that is retrieved from the management pack.

%RMMSSCOM Options

APPSERVER=name-of-application-server

specifies the name of the application server.

The default value for this option is SASITRM.
CREATEMETADATA=Yes | No

specifies that the macro is to create the metadata for the staging tables.

The default value for this option is No, which means do not create the metadata. The value No only produces a report of the metadata that would have been created.
FILEDEVICE=type-of-device

specifies the type of device. This value is required only if the library and tables will be stored on z/OS with a traditional file system.
FILENOOFVOLUMES=number-of-volumes

specifies the number of volumes. This value is required only if the library and tables are going to be stored on z/OS with a traditional file system.
FILESPACEPRIMARY=primary-space-allocation

specifies the primary space allocation. This value is required only if the library and tables are going to be stored on z/OS with a traditional file system.
FILESPACESECONDARY=secondary-space-allocation

specifies the secondary space allocation. This value is required only if the library and tables are going to be stored on z/OS with a traditional file system.
JOBID=metadata-id-of-staging-job

specifies the metadata ID of the staging job. The metadata-ID should be in the format Axxxxxxxx .Zyyyyyyyy and follow these specifications:
- Axxxxxxxx is any set of eight alphanumeric characters preceded by the character “A.”
- Z is any alphabetic character.
- yyyyyyyy is any set of eight alphanumeric characters.
Note: This option is required if CREATEMETADATA is set to Yes.
METAPORT=metadata-server-port

specifies the port of the metadata server.

The default value for this option is 8561.
METAREPOSITORY=name-of-metadata-repository

specifies the name of the metadata repository that contains the IT data mart.

The default value for this option is Foundation.

%RMMSSCOM Example

This example reads the Microsoft SQL Server 2008 R2 management pack in XML format and creates table and column metadata and formats for the SCOM adapter.

%rmmsscom(createMetadata=Y
         ,jobID=A5016lHR.BP0001MU
         ,metapass=myPassword
         ,metaserver=myServer
         ,metauser=myUserid
         ,mpfile=c:\msscom\SQLServer2008R2.xml
         ,outputfilepath=c:\temp
         );