%RMMSSNMP

%RMMSSNMP Overview

The %RMMSSNMP macro 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 that is associated with the metauser ID.

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.

%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.

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.

%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
         );