%RMMSSNMP

%RMMSSNMP Overview

%RMMSSNMP reads a management information base (MIB) definition and creates the appropriate table and column metadata and formats for the SAS IT Resource Management SNMP adapter.

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

%RMMSSNMP Syntax

%RMMSSNMP(
MIBFILE=path-and-filename-of-the-MIB-definition
,METAPASS=user-password
,METASERVER=name-of-metadata-server
,METAUSER=user-ID
<,APPSERVER=name-of-application-server>
<,FORMATLIBPATH=path-to-library-for-formats>
<,JOBID=metadata-id-of-staging-job>
<,KEEPRECOMMENDEDDONLY=Yes | No>
<,CREATEMETADATA=Yes | No>
<,METAPORT=metadata-server-port>
<,METAREPOSITORY=name-of-metadata-repository>
);

%RMMSSNMP Required Arguments

MIBFILE=path-and-filename-of-the-MIB-definition

specifies the path to the management information base (MIB) definition file.

METAPASS=user-password

specifies the password to use in authenticating the user ID to the metadata server. Do not enclose the value for this parameter in quotation marks.

You can use the PWENCODE form of the password. For more information about the PWENCODE procedure, see the Base SAS Procedures Guide.

Tip

If you use the form of the password, be sure to handle embedded braces ({}) carefully. Do not confuse them with square brackets ([]).

METASERVER=name-of-metadata-server

specifies the name of the metadata server. Do not enclose the value for this parameter in quotation marks.

METAUSER=user-ID

specifies the user ID that is to access the metadata server. Do not enclose the value for this parameter in quotation marks.

%RMMSSNMP 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 MIB tables.

The default value for this option is N, which means do not create the metadata. The value N only produces a report of the metadata that would have been created.

FORMATLIBPATH=path-to-library-for-formats

specifies the path to the library where the formats for this macro are to be stored.

The default value for this option is the WORK library.

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 Y

KEEPRECOMMENDEDDONLY=Yes | No

specifies that the macro should keep only the recommended tables and columns.

The default value for this option is N, which means that all tables and columns are to be kept, including the tables and columns that are deprecated or obsolete, and columns whose Max-Access attribute has a value of not-accessible.

METAPORT=metadata-server-port

specifies the port of the metadata server.

The default value for this option is 8561. Do not enclose the value for this parameter in quotation marks.

METAREPOSITORY=name-of-metadata-repository

specifies the name of the metadata repository that contains the IT data mart. Do not enclose the value for this parameter in quotation marks.

The default value for this option is Foundation.

%RMMSSNMP Example

This example reads the BGP-4-MIB definition and creates the metadata for the recommended tables and columns that are in the MIB definition.

%rmmssnmp(
          createMetadata=Y,
          formatLibPath=c:\mibFormats,
          jobID=A5016lHR.BP0001MU,
          keepRecommendedOnly=Y,
          metapass=myPassword,
          metaserver=myServer,
          metauser=myUserid,
          mibfile=c:\mibs\BGP4-MIB.my
         );