%RMMSDTPS

%RMMSDTPS Overview

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

%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. 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. The default value for this option is Foundation. Do not enclose the value for this parameter in quotation marks.

%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,
		       logfile=c:\DTPerfSentry\arlington-1.smf
          metapass=myPassword,
		       metaserver=myServer,
		       metauser=myUserid,
		     	);