%RMMSDTPS

%RMMSDTPS Overview

The %RMMSDTPS macro reads the header records from a DT Perf Sentry log file and creates the appropriate table and column metadata for the SAS IT Resource Management DT Perf Sentry adapter.

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

%RMMSDTPS Syntax

%RMMSDTPS(
LOGFILE=path-and-filename-to-DT-Perf-Sentry-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>
);

%RMMSDTPS Required Arguments

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

%RMMSDTPS 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 produces only 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.

%RMMSDTPS Example

This example reads the DT Perf Sentry log file called c:\DTPerfSentry\arlington-1.smf and creates the metadata for the tables and columns defined in this log file.

%rmmsdtps(createMetadata=Y
		,jobID=A5016lHR.BP0001MU
		,metapass=myPassword
		,metaserver=myServer
		,metauser=myUserid
		,logfile=c:\DTPerfSentry\arlington-1.smf
	);