Section 1, Task 3: Create a Test PDB and Process, Reduce, and Report on Data Action 3: Process your data into a test PDB Step c: Tailor this step for your collector

Use part of the LOAD job step in member CMJCLLD in your CPMISC PDS, and edit it as follows:

//LOAD   EXEC SAS,COND=(0,LT,BACKUP),                            #1 
//       WORK='10500,2000',                                      #2
//       CONFIG='your.sasitsv.CPMISC(CMCONFIG)'                  #3
//SMF     DD DSN=your.smf.data,DISP=SHR                          #4
//SYSIN   DD DATA,DLM='$$'

  *------------------------------------------------------------*
  * You must execute %CPSTART to run IT Service Version.  This *
  * macro initiates IT Service Vision and allocates the PDB.   *
  * The MXGLIB= parameter is required whenever your PDB        *
  * contains tables processed with MXG.  The MXGSRC= parameter *
  * is required only if you use %CMPROCES with MXG in this     *
  * job step.  The ROOTSERV= and SHARE= parameters should only *
  * be used if SAS/SHARE is being used with IT Service Vision. *
  * If the _RC= parameter is nonzero from %CPSTART,            *
  * check the explanatory message in the SAS log.              *
  *------------------------------------------------------------* ;

  /* verify root= pdb= mxglib= mxgsrc= in the following macro */
     %CPSTART(MODE=BATCH,                                        #5
              SYSTEM=MVS,                                        #6
              ROOT=your.sasitsv.,                                #7
              ROOTSERV=,                                         #8
              PDB=your.newpdb.,                                  #9
              DISP=OLD,                                          #10
              SHARE=N/A ,                                        #11
              MXGLIB=mxg.mxg.formats,                            #12
              MXGSRC=('mxg.userid.sourclib' 'mxg.mxg.sourclib'), #13
              _RC=cpstrc                                         #14
             );

     %PUT CPSTART return code is &cpstrc;                        #15

  *------------------------------------------------------------*
  * The %CMPROCES macro processes data into the PDB that was   *
  * established by the %CPSTART macro above.                   *
  * As no table list is specified as the second parameter all  *
  * the tables in the PDB for this collector with a table kept *
  * indicator of YES will be processed.                        *
  * TOOLNM=SMF and COLLECTR=MXG parameters must be specified.  *
  * If the _RC= parameter is nonzero from %CMPROCES,           *
  * check the explanatory message in the SAS log.              *
  *------------------------------------------------------------* ;

     %CMPROCES(,                                                #16
               COLLECTR=SMF,                                    #17  
               TOOLNM=MXG,                                      #18 
               _RC=cmprrc                                       #19 
              );

     %PUT CMPROCES return code is &cmprrc;

Notes:

1. Invokes the SAS software in batch mode by using a cataloged procedure. Drop

   COND=(0,LT,BACKUP),

   from this job step card if you have removed the BACKUP job step.

2. The values in the space allocation for WORK are specified as blocks.
   
   
3. The config member contains all the required and recommended SAS options for the optimal execution of IT Service Vision. The config member is located in the CPMISC PDS.
   
   
4. The SMF DD statement points to your SMF-style data, which is probably on tape. You will need to customize the dataset name and possibly the UNIT= parameter to meet your site's requirements.
   
   
5. The %CPSTART macro can invoke IT Service Vision in foreground or in batch mode. Here we specify that we are invoking it in batch mode. For the complete syntax of the %CPSTART macro, see the Macro Reference documentation for IT Service Vision.
   
   
6. IT Service Vision is an application that can run under more than one operating system. This identifies the operating system on which it runs.
   
   
7. The high-level qualifiers of your IT Service Vision program library (PGMLIB).
   
   
8. The ROOTSERV= parameter was used originally to specify a SAS/SHARE server for the IT Service Vision PGMLIB. This parameter is no longer supported and is specified only for compatibility. You can leave the parameter or remove it. In either case, it is not active.
   
   
9. The high-level qualifiers of your PDB (the one created in the ALLOC job step).
   
   
10. To update the PDB (by adding tables, processing data into them, and reducing the data), DISP=OLD must be specified.
    
    
11. The SHARE= parameter is used when the PDB is to be accessed through a SAS/SHARE server. Here, SAS/SHARE is not used.
    
    
12. The MXGLIB= parameter specifies MXG.MXG.FORMATS, the MXG supplied SAS library that contains SAS formats.
    
    
13. The MXGSRC= parameter is shown with a concatenation of MXG.USERID.SOURCLIB and MXG.MXG.SOURCLIB. MXG searches them in the order listed and takes the first copy of a member that it finds, so be sure that the PDS with your customized MXG members is listed before the PDS with the original MXG members.
    
    
14. The _RC= parameter specifies that a macro variable, in this case CPSTRC, is to contain the value of the return code from the %CPSTART macro.
    
    
15. This statement prints the value of the macro variable that contains the return code for this invocation of the %CPSTART macro.
    
    
16. In this step of the job, IT Service Vision uses MXG to transform data from the SMF files into temporary (staging) SAS data sets and then IT Service Vision processes the staged data into the PDB. For the listed tables XDBSTA1 (DB2 interval statistics) and XDBTATB (DB2 interval statistics: buffer pools), IT Service Vision automatically adds the table definitions from the master data dictionary to the PDB's data dictionary because the tables are listed in the macro and are not in the PDB's data dictionary.
    
    
17. The value SMF for the COLLECTR= parameter means that data were collected by SMF (after being logged by DB2).
    
    
18. The TOOLNM= parameter specifies that MXG software will transform the logged data and place it into intermediate (staging) SAS data sets from which the %CMPROCES macro processes the data into the detail level of the DB2 test PDB.
    
    
19. The _RC parameter specifies that a macro variable, in this case CMPRRC, is to contain the value of the %CMPROCES macro's return code on completion.

    For the complete syntax of the %CMPROCES macro, see the Macro Reference documentation for IT Service Vision.