There are a number of methods for defining IT Service Vision tables for SPECTRUM data. For instance,

• IT Service Vision supplies table definitions for many common SPECTRUM model types. You can use those table definitions directly (by adding them from the master data dictionary to the PDB's data dictionary). Or you can use those table definitions as templates for a table definition for a different model type.
• If a supplied table definition is not available for a model type whose data you want to use,
  
  
  1. you can create table definitions for the new model type by using the IT Service Vision server's interactive interface. After the table definition is created, you can use it as you would use any supplied table definition.
     
     
  2. you can use the IT Service Vision %CSATR2DD macro to create CPDDUTL control statements based on information that you export from SPECTRUM. When you run %CPDDUTL on the control statements, %CPDDUTL creates the corresponding table definition for that model type. After the table definition is created, you can use it as you would any supplied table definition.

This appendix describes a simplified version of the input, syntax, and parameters of the %CSATR2DD macro. If you need more information about the %CSATR2DD macro, see the Macro Reference documentation for IT Service Vision.

For information on %CPDDUTL, see the Macro Reference documentation for IT Service Vision.

Input Required to Run the %CSATR2DD Macro

To create CPDDUTL control statements, the %CSATR2DD macro requires the statistics data set (which you exported earlier in this chapter), the model data set (which you exported earlier in this chapter), the model type data set and the attributes data set (which you would need to export in the same way that you exported the other two data sets).

Using these data sets as input, %CSATR2DD writes CPDDUTL CREATE VARIABLE control statements for each variable in the statistics data set.

For more information on exporting data from SPECTRUM into SAS data sets, see Section 1, Task 2: Start Your Data Collection Software.

For information on %CPDDUTL, see the Macro Reference documentation for IT Service Vision.

Syntax of the %CSATR2DD Macro

The %CSATR2DD macro has the following keyword syntax

%CSATR2DD( MODTYP=,      ATTR=,        STAT=,        MODEL=,
           EXTATTR=,     OUTFILE=,     FORMATS=NO,   
           WHICHAID=,    WHICHMTH=,    WHICHTAB=NEW, WHICHVAR=ALL,
           BIGTEMP=,     DATSTAMP=YES, MAXNAMES=512);

The important parameters are described below. For information about the others, see the Macro Reference documentation for IT Service Vision. For the definition of the specgway libref, see Section 1, Task 3: Create a Test PDB and Process, Reduce, and Report on Your Data.

• MODTYP=

  This parameter identifies the model type data set that you exported using SPECTRUM. Use a two-level name in the form libref.datasetname, where the SPECTRUM default datasetname is modtyp whether you did the export with SDE (SPECTRUM version 4.x) or Gateway (SPECTRUM version 3.x). For example:

  MODTYP=specgway.modtyp

  where specgway is the library name that you defined, before running this macro, by using the libname statement. specgway should point to the directory to which you exported SPECTRUM data.

  Note: Each observation in the model type data set maps one model type handle to the corresponding model type name.

• ATTR=

  This parameter identifies the attributes data set that you exported using SPECTRUM. Use a two-level name in the form libref.datasetname, where the SPECTRUM default datasetname is attr if you did the export with SDE and attrdesc if you did the export with Gateway. For example:

  ATTR=specgway.attr

  Note: Each observation in the attr data set maps one attribute ID (in hex) to the corresponding attribute name.

• STAT=

  This parameter identifies the statistics data set that you exported using SPECTRUM. Use a two-level name in the form libref.datasetname, where the SPECTRUM default datasetname is stat whether you did the export with SDE or Gateway.

  STAT=specgway.stat

  Note: Each observation in the statistics data set contains the values of the attributes logged at a given time for a given model.

• MODEL=

  This parameter identifies the model data set that you exported using SPECTRUM. Use a two-level name in the form libref.datasetname, where the SPECTRUM default datasetname is model whether you did the export with SDE or Gateway. For example,

  MODEL=specgway.model

  Note: Each observation in the model data set maps one model handle (in hex) to the corresponding host name (which is the same as a value of the variable MACHINE in IT Service Vision).

• OUTFILE=

  This parameter is the name of the file containing the CPDDUTL control statements that are generated by %CSATR2DD. This file is a flat file suitable for use with the %CPDDUTL macro.

• FORMATS=NO

  Setting the value of this parameter to YES causes the macro to generate format definitions for user formats uucai2n, uucmt2m, and uucmt2x. These user formats are used only with previous releases of SAS/CPE; they are unnecessary with the current release.

• WHICHAID=

  This parameter is used to subset the data so that the resulting table definitions reflect only the attributes that you select.

  The value of this parameter is a list of the attribute ID values to be included in the table definition. For example:

  WHICHAID=attrid in (65134 65980 64900)

  selects only the variables with the indicated values of attrid.

• WHICHMTH=

  This parameter is used to subset the data so that the resulting table definitions reflect only the model types that you select.

  The value of this parameter is a list of the model types that should be used for creating tables. For example:

  WHICHMTH=mth in (65134 65132)

  selects only those device types for table creation. Records for models of other types will not be used to determine which attributes are included in the table.

• WHICHTAB=NEW

  This parameter is used to subset the data so that the resulting definitions reflect only the tables that are not already known to IT Service Vision. Setting this parameter to ALL will cause the macro to create CPDDUTL control statements for all the different tables (model types) encountered in the data sets.

  Leaving the value of this parameter equal to NEW will cause the macro to generate CPDDUTL statements only for model types that do not already have matching table definitions in IT Service Vision.

• WHICHVAR=ALL

  This parameter is used to subset the data so that the resulting table definitions reflect only the variables that you select.

  Leaving the value of this parameter equal to ALL will cause the macro to generate CPDDUTL control statements for all attributes encountered in the data sets.

  Setting this parameter to NEW will cause the macro to generate CPDDUTL control statements only for attributes that were not previously defined in IT Service Vision.

For example, this program (which you can type in and submit from the SAS PROGRAM EDITOR window) generates an IT Service Vision table definition that contains all the attributes exported into specgway.stat and lists the table definition in the SAS LOG window:

* Define the specgway libref;
   libname specgway '/usr/spectrum/export.output' ;

* Generate table definition statements;
%csatr2dd(modtyp=specgway.modtyp,
          attr=specgway.attr,
          model=specgway.model,
          stat=specgway.stat,
          outfile=/tmp/table.ddutl,
          whichtab=ALL,
          whichvar=ALL) ;

* Read table definition statements into %CPDDUTL;
%cpddutl (filename=/tmp/table.ddutl, list=y) ;

If you want to write the SAS log to an external file, see Prerequisite 1: You have a printed copy of the table definition(s) in Section 2, Task 1: Customize and Verify your Test PDB for the steps.