IT Service Vision 2.2.1 Collector Updates


Contents:

Updates to the Enhanced NTSMF Support

NTSMF Support Description

Support for Cabletron Spectrum 5.0

IT Service Vision 2.2 Updates


Updates to the Enhanced NTSMF Support

Important Note: When using the Enhanced NTSMF support it is recommended that you do NOT :-

  1. use wildcards in the RAWDATA parameter of %cpproces.
  2. concatenate NTSMF smf files into one file for processing.

For further information into the above issues please refer to the Macro Reference guide under the documentation for the %cpproces macro and NTSMF Appendix 1: NTSMF Support Description in the Setup Guide.

Overview

New NTSMF Metrics

After Maintenance Pack 1 as been applied the following new metrics will be available in the supplied dictionary.

Table Name Variable Name Description
NTSSTM ACTVSSN Total number of active (logged on) sessions.
INCTSSN Total number of inactive (not logged on)
sessions.
TPRTBSC Total number of bytes transferred in the system as
a result of session communication.
NTPRCS IDLOGON ID Logon
IDUSER ID User

 

%cpcat;
cards4;
maintain table name=_all_
  report
  scope=newvars
  update;
;;;;
%cpcat(cat=work.temp.temp.source);
%cpddutl(entrynam=work.temp.temp.source);

Updates to NTPRCS table

At present there is a risk that PROCESS data will be incorrectly treated at duplicate data and deleted before being staged into the NTPRCS table due to the IDPRCS variable not being kept in the NTPRCS table. The NTPRCS table definition supplied in Maintenance Pack 1 marks the IDPRCS variable as kept and also adds it to the BY list for this table.

Applying maintenance pack 1 will migrate the necessary table changes into your supplied dictionary (stored in PGMLIB). If you add the table to your PDB the updated definition will be used, however, if you already have the NTPRCS table added to your PDB, submit the following from your program editor when the appropriate PDB is active (in write mode) to apply the updates..

%cpcat;
cards4;
    SET TABLE NAME=NTPRCS;
    UPDATE VARIABLE NAME=IDPRCS
      KEPT=YES
      LENGTH=8;
 /*--------------------------------------------------------------*
  | By, Class, ID, and Index variable lists for table: NTPRCS
  *--------------------------------------------------------------*/
  UPDATE TABLE NAME= NTPRCS
    DETAIL =( BYVARS= 'DOMAIN MACHINE PROCESS IDPRCS DATETIME HOUR SHIFT' );
;;;;
%cpcat(cat=work.temp.temp.source);
%cpddutl(entrynam=work.temp.temp.source);

Ability to change BY list for a NTSMF table

A restriction of NTSMF in previous versions has been that the BY lists for the NTSMF tables could not be changed from the supplied defaults. This restriction has now been removed.

Performance Improvements in Processing

Important Note: It is recommended that you do NOT use wildcards in the RAWDATA parameter of %cpproces when processing NTSMF data on a NT platform, instead you should point to the directory that contains the individual NTSMF smf files. See the documentation on the %cpproces macro in the macro reference and NTSMF Appendix 1: NTSMF Support Description in the Setup Guide for further  information.

The Enhanced NTSMF support uses the NTSMF Discovery Records of each NTSMF smf file to construct the staging code which reads in the raw data into the detail level of the PDB. To ensure data integrity the staging code is built for each NTSMF smf file. When processing a large number of NTSMF smf files the overhead in building the staging code can be hours.

Maintenance Pack 1 now pre-processes the NTSMF smf files and groups them by common sets of Discovery records meaning that the staging code only needs to be constructed once per group. Tests have shown significant performance improvements in elapsed processing time.


NTSMF Support Description

Overview

The following description of the NTSMF processing assumes that you are running IT Service Vision Release 2.2 with Maintenance Pack 1 installed or higher.

This document walks through the process of recording Demand Technology's NTSMF data into IT Service vision. The following stages will be covered along with working examples.

Prerequisites

NTSMF Data Requirements

NTSMF data requirements :-

Creating a PDB and adding tables

  There are three approaches you can use when starting out with NTSMF data.

%cpstart(pdb=pdb-name,root=root-location,access=write,mode=batch,_rc=cpstrc);

%put 'CPSTART Return Code is ' &cpstrc;

%cpcat;
cards4;
add table name=ntcache;
add table name=ntlgdsk;
;;;;
%cpcat(cat=work.cpddutl.add.source);
%cpddutl(entrynam=work.cpddutl.add.source);

For MVS use the following %cpstart.

%cpstart(pdb=pdb-name,
root=root-location,
disp=new,
mode=batch
_rc=cpstrc);

Once the tables have been added, dictionary characteristics (age limits, variables kept status) can be modified either using the interactive interface or the %CPDDUTL macro.

Processing and Reducing Data into the PDB

The NTSMF data can be processed on any platform, MVS, UNIX or Windows NT Server, irrespective of which platform it originated. Once that data is moved to the appropriate platform the processing is identical.

Enhanced NTSMF support is different from the original support that was provided in IT Service Vision Release 2.1 in that it dynamically builds the necessary code to process NTSMF smf files. It uses the NTSMF Discovery records at the head of each file to provide the information on the layout of the NTSMF data records. Different versions of the same software can produce different format NTSMF records, counters are inserted, deleted and appended and the only way to ensure the data is processed correctly is to use the Discovery record. Worse case, each machine on which NTSMF is logging could have different NTSMF record layouts due to different versions of the same software.

If multiple NTSMF smf files are to be passed to IT Service Vision and they all have different layouts, then staging code is built for each separate file. This ensures data integrity, however it also increases the processing time of the data. Fortunately, this is not typically the case, normally organizations have some control over the software and software versions that are installed on the monitored machines and as a result it is possible to group the NTSMF smf files according to common Discovery records. If several NTSMF smf files have the same Discovery record layouts then these can be processed using the same staging code.

To improve processing performance by reducing the number of times the staging code is built IT Service Vision performs an initial scan of all the NTSMF smf files and groups them according to common Discovery record layouts. Once completed each group of files is processed as a single file and the staging code is built only once per group (See note below for information on large volumes of data)..

The following should be considered when processing NTSMF smf files :-

Transferring the Data

For the Enhanced NTSMF support that is provided in IT Service Vision Release 2.2 or higher it is recommended that each NTSMF smf file is maintained as a separate smf file, that is, we do not recommend that they are concatenated together.

Transfer the file to the appropriate platform so that it retains it's text format.

Unix and PC: Place all the NTSMF smf files in a single directory which will be pointed to by the %cpproces macro. No other files or sub-directories should be in this directory.

MVSPlace each smf file in its own PDS member with the following DCB attributes DSORG=PO,RECFM=VB,LRECL=32756,BLKSIZE=32760. By specifying the PDS name in the %cpproces macro, each member will be picked up and processed.

Input Filtering

If you decide to use Input Filtering, we recommend that you do the following before running your first %CPPROCES :-

  1. Bring up your NTSMF PDB interactively.
  2. Copy pgmlib.ntsmf.cpdupchk.source to admin.ntsmf.cpdupchk.source.
    To do this, submit the following code from your program editor.

    proc catalog cat=pgmlib.ntsmf;
    copy out=admin.ntsmf;
    select cpdupchk.source;
    quit;

  3. Review and update if necessary the following parameters for the %CPDUPCHK macro invocation contained in admin.ntsmf.cpdupchk.source. To do this type note admin.ntsmf.cpdupchk.source on the command line (or from the command box) make the necessary updates and SAVE and END out of the notepad window.

If you do not do the above, the first run of %cpproces with Input Filtering active will copy the default %CPDUPCHK invocation into the admin library automatically, and you will receive the following warning message recommending that you review the %CPDUPCHK parameter values.

WARNING: *** WARNING *** WARNING *** WARNING *** WARNING *** WARNING *** WARNING
WARNING: DO NOT OVERLOOK THIS IMPORTANT WARNING - IT WILL NOT APPEAR AGAIN.
WARNING: A sample invocation of the %CPDUPCHK macro has been copied to
your ADMIN library. You should review its contents before the
next execution. To do so, start IT Service Vision with this
PDB in update mode and type "NOTE ADMIN.NTSMF.CPDUPCHK.SOURCE"
on the SAS command line. The only parameter values you need to
review and probably change are the RANGES=, SYSTEMS=, and KEEP=
settings. Review the comments therein for guidance and the
documentation on input filtering for more details.
WARNING: *** WARNING *** WARNING *** WARNING *** WARNING *** WARNING *** WARNING

If you require more information on Input Filtering please refer to the How To/Macro section from the online help for IT Service Vision.

Processing and Reducing the Data

The following process example should be run a %CPSTART. For the purpose of this example I have included input filtering in this process run. The rawdata parameter on the %CPPROCES macro should point to a directory (on Unix and PC) which contains the NTSMF logs to be processed and a PDS (on MVS).

%cpproces(,collectr=ntsmf,rawdata=filename,toolnm=sasds,dupmode=discard,_rc=cpprc);

%put 'CPPROCES return code is ' &cpprc;

%CPREDUCE(,_RC=cprrc);

%put 'CPREDUCE return code is ' &cprrc;

 

In the SAS log you can expect to see the following :-

+-----------------------------------------------------------------------------------------+
| IT Service Vision input data duplication check report                            |
| =================================================== |
|                                                                                                                          |
| NOTE: All input records for new machine nightingale will be added. |
|                                                                                                                          |
+-----------------------------------------------------------------------------------------+

The above message will only appear when Input Filtering is active. The message shown will depend on whether the input data is considered duplicate.

==========================================================
The following objects were not kept to be processed but
existed in the input file.

Object Name = FTP Server
Object Name = MSExchangeWEB
Object Name = Memory
Object Name = Paging File
Object Name = PhysicalDisk
Object Name = Process
Object Name = Server
Object Name = Server Work Queues
Object Name = System
Object Name = WINS Server

A record is not processed for the following reasons :-

1 - The ITSV table for this object was not specified
in the PROCESS macro.
2 - The ITSV table for this object is marked KEPT=N
in the PDB.
3 - The object is a new object for which a table
definition needs to be built (see GENERATE SOURCE).
==========================================================

This report is always produced when processing NTSMF data. It reports the objects that were found in the rawdata that were not processed. If an object appears in this report for which you want to collect the data for, then you should add the appropriate table to the PDB. If you do not want to keep the data for an object, you can update your collection process to no longer keep the history data. If an object appears for which there is no supplied table, then one can be constructed using the GENERATE SOURCE function of the %CPDDUTL macro and an INTYPE= parameter of NTSMF.

Occasionally, you may see messages appear in the SAS log similar to the ones below. These messages are produced when new NTSMF counters appear in an NTSMF object that are not defined in the IT Service Vision data dictionary.

WARNING: Process discovery record contains unrecognized metric label: ID Logon .
WARNING: Process discovery record contains unrecognized metric label: ID User .

To stop these warning messages appearing you need to add these metrics to the table definition. Cut and paste the NTSMF discovery record for the object in question into a text file and then pass that to Generate Source using the INTYPE=NTSMF to generate a table and variable definitions. You can then use the definitions of the new counters as a starting point for adding them to your PDB.

Messages similar to the following may appear in the SAS log during a %CPPROCES and are caused by variables (in this case ACTVSSN and INCTSSN) being marked as KEPT=YES in the table being processed, however, data for that variable not existing in the raw NTSMF data. In this example, the reason that there is no data for these varaibles in the NTSMF data was becaused the NT machine that was recording this information had an older service pack applied that did not produce values for these counters. This is not a problem and to stop these warnings from appearing just mark the appropriate variables as KEPT=NO.

WARNING: Variable name Active Session in table NTSSTM is not in data set COLLECT
NOTE: This may cause missing values to be generated for ACTVSSN
WARNING: Variable name Inactive Session in table NTSSTM is not in data set COLLECT
NOTE: This may cause missing values to be generated for INCTSSN


Support for Cabletron Spectrum 5.0

With ITSV 2.2.1, IT Service Vision fully supports Cabletron SPECTRUM version 5.0 including the List Attribute Format of SPECTRUM data.

List Attribute Format is a data format that SPECTRUM uses when exporting data from models that contains "instances".  In the SPECTRUM SDE User Interface, if a model is selected that has list attributes associated with it, the list attributes will be distinguishable in the UI from the non-list attributes by brackets, [] next to the attribute.

An entry has been added to the SPECTRUM SDE resource file to allow some control over the data format. Setting this value to "1" will cause all Statistics output to be in the List Attribute format whether or not List Attribute are present in the attributes selected. If this value is left at 0, the default value, the standard format will be used unless a list attribute is selected for export. If such an attribute is selected, SPECTRUM will use the list attribute format when exporting data into SAS data sets.

IT Service Vision will determine the format of the exported data and adjust accordingly. However, table definitions may need to be generated or modified to include the instance variable, OID. The supplied SAS macro, %CSATR2DD generates table definitions based on a given statistics output data set. The resulting dictionary definition statements created by this macro should be examined closely to insure that the tables and variables are defined to ITSV correctly.

See the chapter on processing data from Cabletron SPECTRUM for the steps necessary to read in SPECTRUM data.

NOTE:  Due to a problem with the attributes data set in SPECTRUM 5.0R1, a patch needs to be requested from Cabletron technical support to fix the Attribute Type field in the ATTRIBUTES data set. This field is used by ITSV when generating table definitions as it tells ITSV the variable's interpretation type, for example, STRING or COUNTER.