MVS Appendix 5: The Transition from MXG Software to IT Service Vision Software with MXG

Table Of ContentsIT Service Vision Help


You can make the transition from MXG alone to IT Service Vision with MXG without throwing away any existing data or report programs (report definitions). This appendix will walk you through the steps.

Running MXG (BUILDPDB) Directly

When you process data into an IT Service Vision PDB, as an early step in the processing, the IT Service Vision server invokes MXG software. More specifically, for each kept table in the IT Service Vision PDB or for each table in your supplied list (in the %CMPROCES macro), the IT Service Vision server invokes the MXG macro that builds the corresponding MXG data in a temporary (staging) data set. The data are then further processed into the IT Service Vision PDB.

You will probably want to continue to run both processes in parallel while you are getting acquainted with IT Service Vision. After a period of running in parallel, you can discontinue running BUILDPDB (the job that loads the MXG PDB).

Loading MXG PDBs into IT Service Vision

With maintenance level TS45501, a new macro called %CMEXTDET became available. It is designed to support the reduction of data that is currently held in a MXG PDB into an IT Service Vision PDB without having to re-process it. This also allows you to "import" MXG history (but not trend) data that may be held on tape. For more details, please see the Macro Reference documentation for IT Service Vision.

Running MXG Report Programs

If you generate MXG views in the IT Service Vision PDB, you can run existing MXG report programs against the data in the IT Service Vision PDB without modifying the programs.

Generating MXG Views in an IT Service Vision PDB

Your IT Service Vision PDB has MXG views by default. To check that the setting has not changed, follow this path from the IT Service Vision server's main menu:

PDB Admin -> Set Active PDB Options

The Provide PDB MXG Views selection should be set to Yes. If not, set it to Yes.

Generating Reports Based on the MXG Views

Once the MXG views have been built, you can run existing MXG report programs against your IT Service Vision PDB. An example of running the MXG grafrmfi member against the demonstration PDB follows:

   //LOAD     EXEC SAS,REGION=32M,WORK='2000,500',
   //PDB      DD,DISP=SHR
   //SOURCLIB DD DSN=mxg.userid.sourclib,DISP=SHR
   //         DD DSN=mxg.mxg.sourclib,DISP=SHR
   //SYSIN    DD *

    options sasautos=(sourcelib sasautos) mautosource noimplmac errorabend dquote ;

    options pagesize=60 linesize=132 ;
    %grafrmfi(pdb=PDB,device=IBM3179,company=Your Company,

The sasautos option concatenates your library of modified MXG macros and the library of unmodified MXG macros. The %GRAFRMFI macro produces graphs from the IT Service Vision table XRMFINT, which it sees by means of the IT Service Vision view RMFINTRV. These graphs will be put into a SAS catalog named DEMO in the library with libname PDB.

Generating a Menu Block to Display the Reports

You can put an icon in the IT Service Vision server's main menu to make it easy to view the graphs generated by your MXG report programs. See Section 1, Task 3: Create a Test PDB and Process, Reduce and Report on Your Data for an example of adding an icon to the IT Service Vision server's main menu for graphs generated by your IT Service Vision report definitions.

Reporting Against MXG PDBs using IT Service Vision


For data without a variable named DATETIME, you will need to define DATETIME. For example, the following program creates a data step view, which effectively copies the TYPE70 data set and creates the DATETIME variable. Minimal space is needed for this view because the view only copies the data when the view is invoked by, for example, a report.

   libname mxgpdb 'your.mxg.pdb' disp=shr;

   data sasuser.type70/view=sasuser.type70;
      format datetime datetime16.;
      set mxgpdb.type70;
      datetime = startime;
      drop startime;

Use the PF8 key (or whichever key is associated with the NEXT command) to cycle through the active SAS windows until the PROGRAM EDITOR window displays. Type in and submit this program. Check in the SAS log that there are no errors. Return to the CPE window by continuing to press PF8 or by typing CPE on the command line and pressing ENTER or RETURN.

Produce Reports

To continue the above example and produce a One Y-Axis Plot based on the view in the SASUSER library,

  1. Invoke the IT Service Vision server's interactive interface.
  2. From the main menu, follow this path:

    Reports -> DesignGraphRpt -> One Y-Axis Plot -> select level Other -> select library SASUSER

    Select the table icon (the icon in the upper left corner) and then select TYPE70. Select Y Variable and then PCTCPUBY. If you have more than one system, select By Variable and then SYSTEM. Select DateTime Range, Reset from PDB, and OK. On the main report definition window, select Actions and then Run Report.

Note: You use level "Other," above, instead of levels like detail, day, week, month, and year.