Using data maps (PTFs BQY1950 and BQY2072 applied)
Data maps contain the record entries (REs) that constitute MainView product views, panels, monitors, and interfaces from which you can collect historical data. You can extract the REs using the History File Extraction utility (BBM9MD73). You can then use a sort or report-writing utility to select specific REs for data analysis. Data maps are stored in the BBSAMP or BBMAP library and listed in the Table data maps (TDMs) associated with the specific product. For more information on TDMs, see Using table data maps (PTFs BQY1950 and BQY2072 applied).
To use a data map
Locate the data map member in the BBSAMP or BBMAP data set associated with the TDM entry that you want to extract.
Determine if the data that you want to analyze is contained in the RE described by the data map.
Use the extraction utility as necessary to extract history data into uncompressed, physically sequential data sets for input into data analytics tools.
Tip
If you archive history data sets using IDCAMS, it's not necessary to extract the history data to GDGs. You can extract history data from the archived VSAM data sets as needed. However, you must keep track of the interval recorder set ID (IRSID) so that you can specify the proper value of the IRSID parameter when you extract history data with the BBM9MD73 utility. IRSID values are 0, for normal interval data sets, 1 for long-term interval sets for MainView for z/OS, or short-term interval data sets for MainView for DB2, and 2 for short-term interval data sets for MainView for z/OS. You must also keep track of the PAS type where the history data set originated so that you can specify the PASTYPE parameter correctly to the BBM9MD73 parameter. If you fail to specify the proper parameter values, it may result in mismatches during sort filtering and data transformation filtering operations.
For information on using the REs with BBM9MD73, see Selecting records by specific product and record type ID number (RTIN) (PTFs BQY1950 and BQY2072 applied).
Sample data map
The following figure shows an example of a data map from MainView AutoOPERATOR (TDM member AAOUR010):
***************************************************** Utility Version: 1.1 *****
*
* Table of Normalized Data Formats (NDF):
*
* +---------------------------------------------------------------------------+
* | Type | Data Type | External Format |
* |-------|------------------|------------------------------------------------|
* | B | Binary number | Decimal |
* | Bi | Binary number | Decimal with binary scaling (1024,1024*1024..) |
* | Bn | Binary number | Decimal where 'n' is the # of decimal places |
* | C | Character | Character |
* | F | Floating point | nnnnnnn.nnnnnn nnnnn |
* | G | Flag Byte | Flag Byte |
* | H | ZNTS duration | hh:mm:ss.th |
* | I | IP Address | 16 byte hex value (see comments per element) |
* | L | STCK (timer) | sssssss.thtthm (seconds) |
* | Px | Packed decimal | Decimal (x=1 is with sign, x=0 is w/o sign) |
* | Q | Packed date | yyyy/mm/dd (x'yyyymmdd') |
* | R | Packed time | hh:mm:ss.t (x'hhmmsstC') |
* | S | STCK (TOD) | yyyy/mm/dd.hh:mm:ss.thtthm |
* | U | POSIX STCK (TOD) | hh:mm:ss.thtthm |
* | X | Hexadecimal | Hexidecimal value (char fmt) |
* | Z | ZNTS time | yyyy/mm/dd.hh:mm:ss.th |
* +---------------------------------------------------------------------------+
*
********************************************************************************
*
Name Off Len Ty Description
-------------------- ---- ---- -- ----------------------------------------------
AR01RCID 0000 0004 C Eye catcher (AR01)
AR01SSID 0004 0004 C PAS SSID collecting the data
AR01JBNM 0008 0008 C PAS Jobname
AR01SYS 0010 0004 C System ID
AR01PUTL 0014 0008 C PUT Level
AR01DESC 001C 0040 C Record Description
AR01PGMN 0044 0008 C Collector Program Name
AR01ACTV 004C 0001 C Active Record Indicator
* 'Y' = Yes
* 'N' = No
* 'I' = Initializing
AR01EOIZ 004D 0008 Z End-of-Interval ZNTS date/time
AR01VERP 0055 0001 X Version that wrote the record
* X'00' Initial version
* X'01' AutoOPERATOR 8.2.xx
* X'01' Current version
AR01ITYP 0068 0004 C Event Type (MSG, JRNL, etc)
AR01ICNT 006C 0004 B Event Count during Interval
AR01IEPM 0070 0004 B Events per minute for Interval
AR01IHCT 0074 0004 B Handled Count during Interval
AR01ISCT 0078 0004 B Suppress Count during Interval
AR01IACT 007C 0004 B Alerts Created Count during Interval
AR01IECT 0080 0004 B EXECs Scheduled Count during Interval
AR01ICCT 0084 0004 B Hardcopy Suppressed Count during Interval
Data map parameters
The following table describes data map parameters:
Column | Description |
---|---|
Name | The field name in the RE of the data map |
Off | The offset value The relative offset from the beginning of an RE where the named field is located, starting with the first field at offset 0. Offset values are calculated in hexadecimal format. |
Len | The length of the field, in bytes Element lengths are calculated in decimal values. |
Ty | The type of data format used in the field For the key, see Table of Normalized Data Formats (NDF), included at the top of each data map. |
Description | The name of the field, including its variations, as it relates to the product In the sample data map, users of the product recognize
|
Comments
Log in or register to comment.