%RMMSBMCP

%RMMSBMCP Overview

The %RMMSBMCP macro reads the records from a BMC Perf Mgr file that was created with the DUMP HISTORY command and creates the appropriate table and column metadata for the SAS IT Resource Management BMC Perf Mgr adapter.

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

%RMMSBMCP Syntax

%RMMSDTPS(
LOGFILE=path-and-filename-to-BMC-Perf-Mgr-log
,METAPASS=user-password
,METASERVER=name-of-metadata-server
,METAUSER=user-ID
<,APPSERVER=name-of-application-server>
<,JOBID=metadata-id-of-staging-job>
<,CREATEMETADATA=Yes | No>
<,FILEDEVICE=type-of-device>
<,FILENOOFVOLUMES=number-of-volumes>
<,FILESPACEPRIMARY=primary-space-allocation>
<,FILESPACESECONDARY=secondary-space-allocation>
<,METAPORT=metadata-server-port>
<,METAREPOSITORY=name-of-metadata-repository>
);

%RMMSBMCP Required Arguments

LOGFILE=path-and-filename-to-BMC-Perf-Mgr-log: specifies the path to the BMC Perf Mgr log 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.

%RMMSBMCP Options

APPSERVER=name-of-application-server: specifies the name of the application server. The default value for this option is SASITRM.

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.

CREATEMETADATA=Yes | No: specifies that the macro is to create the metadata for the tables and columns in the log file.

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.

FILEDEVICE=type-of-device: specifies the type of device. This value is required only if the library and tables are going to 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.

METAPORT=metadata-server-port: specifies the port of the metadata server.

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.

%RMMSBMCP Example

This example reads the BMC Perf Mgr log file called c:\BMCPerfMgr\citra1_Windows_format2.dat and creates the metadata for the tables and columns defined in this log file.

%rmmsbmcp(createMetadata=Y
		,jobID=A5FWNTN9.BN0000RX
		,metapass=myPassword
		,metaserver=myServer
		,metauser=myUserid
		,logfile=c:\BMCPerfMgr\citra1_Windows_format2.dat
	);