TABULAR

The TABULAR Analyzer control statement produces printed Tabular Reports and value-delimited text records that can serve as input to spreadsheets or other user-supplied programs.

TABULAR
[,CPU={ALL|cpuID}]
[,FLDSEP={COLON|COMMA|SEMICOLON|TAB}]
[,INTERVAL={hh:mm:ss|HOURLY|DAILY|WEEKLY|MONTHLY|QTRLY|SEMIANNL}]
[,MEASURE=(measureExpression,...)]
[,MSRLIST=(ALL,CACHE,CHANNEL,COUPFAC,CPU,CRYPTO,DEVICE,IOQ,PAGE,PAGING,PCIE,WLM)]
[,NODATA={ZERO|N/A}]
[,OUTDD=ddName]
[,OUTDDCSV=ddName]
[,OUTPUT=(RECORDS|REPORT|CSV)]
[,QUALLIST={YES|NO}]
[,SYSID={(sysID,...)|*}]
[,XREFLIST={YES|NO}]

With the TABULAR statement, you can:

Produce a full or partial list of available measures with the Measure Reference List, (optionally) their respective qualifiers, and (optionally) a cross-reference of comparable IBM RMF OVERVIEW conditions
Produce a printed tabular report or two different types of value-delimited text files containing up to 254 measures
For the value-delimited text files, use a comma (default), colon, semicolon, or tab character
Specify your own names to replace the supplied measure names
Use qualifier expressions to include only selected data for a measure
Filter the input by using SYSID and CPU parameters

Parameters

The parameters for the TABULAR control statement are described in the following table. Depending on your level of PTF maintenance, select one of the following tabs:

PTF BQM1615 applied
PTF BQM1615 not applied

CPU=	Specifies the CPU ID for which data is to be displayed Use either of the following values: ALL (the default) displays data for all CPUs. cpuID specifies data for one CPU ID, specified as a two-digit hexadecimal value. Note Measures specific to the TABULAR statement do not use the CPU parameter. This parameter provides compatibility with the following GRAPH TYPE=TAB measures: CPUCAP CPK- n IOIRATE IOTPI PPB SUP SYST TYP70CPU The CPU ID qualifier provides comparable functionality for some TABULAR measures.
FLDSEP=	Specifies the character to be used to separate measures in value-delimited text records Valid FLDSEP values are: COLON COMMA (the default) SEMICOLON TAB Note This parameter applies with the OUTPUT=RECORDS or CSV values.
INTERVAL=	Specifies the time interval to be reported in the output If you omit INTERVAL, the reporting interval will be the same as the input file's recording interval. Valid INTERVAL values are as follows: hh:mm:ss, where hh is the hour. mm is the minutes. ss is the seconds. Each line of the report represents the specified length of time. The time value should be the same as or a multiple of the recording interval. A value less than the recording interval is reset to the recording interval. A value that is not a multiple of the recording interval can produce unpredictable results. HOURLY—Each line of the report represents one hour. DAILY—Each line of the report represents one day. WEEKLY—Each line of the report represents one week. MONTHLY—Each line of the report represents one month. QTRLY—Each line of the report represents one quarter. SEMIANNL—Each line of the report represents six months.
MEASURE=	Specifies one or more measure expressions to be included in the report When specifying multiple measure expressions, separate them with commas and enclose them in parentheses. You can specify up to 254 measure expressions for the MEASURE parameter. For more information, see Measure expressions. Note If you specify MEASURE, you must also specify the OUTPUT parameter.
MSRLIST=	Requests the TABULAR Measure Reference List for selected record types MSRLIST produces a list of all available measures for each record type. Optionally, the list can include the respective qualifiers and a cross-reference of RMF OVERVIEW names to TABULAR measures. Note Even if multiple TABULAR control statements are used, you can specify the MSRLIST parameter only once per Analyzer execution. You can specify ALL (for all record types) or one or more of the following record types: CACHE CHANNEL COUPFAC CPU CRYPTO DEVICE IOQ PAGE PAGING PCIE WLM When specifying multiple record types, separate them with commas and enclose them in parentheses. The default is ALL. For a valid TABULAR control statement, you must specify either the MSRLIST or OUTPUT parameter.
NODATA=	Specifies how the report should represent the absence of data Valid NODATA values are: N/A—The field is shown as N/A. ZERO—For numeric measures, the field is shown as a zero (0). For text measures, the field is shown as blanks in the report and a null value in text records. The default is ZERO.
OUTDD=	Specifies the DD name that identifies the sequential file to which value-delimited text records should be written You must define the data set as RECFM=FB, LRECL=80. The BLKSIZE should be a multiple of 80. If you omit BLKSIZE, it defaults to 1600. Note You must specify OUTDD if you specify OUTPUT=RECORDS. If you specify OUTPUT=REPORT or CSV, OUTDD is ignored.
OUTDDCSV=	Specifies the DD name that identifies the sequential file to which value-delimited text records should be written You must define the data set as RECFM=FB, LRECL=4096, BLKSIZE=32760. The default value for LRECL and BLKSIZE is 32760. Note You must specify OUTDDCSV if you specify OUTPUT=CSV. If you specify OUTPUT=REPORT or RECORDS, OUTDDCSV is ignored.
OUTPUT=	Specifies the type of output to be produced Valid OUTPUT values are: RECORDS—A collection of value-delimited text records If you specify OUTPUT=RECORDS, you must also specify the OUTDD parameter. REPORT—A printed tabular report CSV—A comma-separated value (CSV) file If you specify OUTPUT=CSV, you must also specify the OUTDDCSV parameter. Note If you specify OUTPUT, you must also specify the MEASURE parameter with one or more measure expressions.
QUALLIST=	Specifies whether to include the qualifier list in the measure list when MSRLIST is specified Valid QUALLIST values are YES and NO. The default is NO.
SYSID=	Identifies one or more systems to be included in the output You can specify up to 96 system IDs, or an asterisk () for all systems. When specifying multiple system IDs, separate them with commas and enclose them in parentheses. You can also use an asterisk as a wildcard character to specify multiple system IDs that follow a pattern (such as SJS for systems SJSA, SJSB, and SJSC). The default is * for all systems.
XREFLIST=	Specifies whether to include the RMF cross-reference list in the measure list when MSRLIST is specified Valid XREFLIST values are YES and NO. The default is NO.

CPU=	Specifies the CPU ID for which data is to be displayed Use either of the following values: ALL (the default) displays data for all CPUs. cpuID specifies data for one CPU ID, specified as a two-digit hexadecimal value. Note Measures specific to the TABULAR statement do not use the CPU parameter. This parameter provides compatibility with the following GRAPH TYPE=TAB measures: CPUCAP CPK- n IOIRATE IOTPI PPB SUP SYST TYP70CPU The CPU ID qualifier provides comparable functionality for some TABULAR measures.
FLDSEP=	Specifies the character to be used to separate measures in value-delimited text records Valid FLDSEP values are: COLON COMMA (the default) SEMICOLON TAB Note This parameter applies with the OUTPUT=RECORDS or CSV values.
INTERVAL=	Specifies the time interval to be reported in the output If you omit INTERVAL, the reporting interval will be the same as the input file's recording interval. Valid INTERVAL values are as follows: hh:mm:ss, where hh is the hour. mm is the minutes. ss is the seconds. Each line of the report represents the specified length of time. The time value should be the same as or a multiple of the recording interval. A value less than the recording interval is reset to the recording interval. A value that is not a multiple of the recording interval can produce unpredictable results. HOURLY—Each line of the report represents one hour. DAILY—Each line of the report represents one day. WEEKLY—Each line of the report represents one week. MONTHLY—Each line of the report represents one month. QTRLY—Each line of the report represents one quarter. SEMIANNL—Each line of the report represents six months.
MEASURE=	Specifies one or more measure expressions to be included in the report When specifying multiple measure expressions, separate them with commas and enclose them in parentheses. You can specify up to 254 measure expressions for the MEASURE parameter. For more information, see Measure expressions. Note If you specify MEASURE, you must also specify the OUTPUT parameter.
MSRLIST=	Requests the TABULAR Measure Reference List for selected record types MSRLIST produces a list of all available measures for each record type. Optionally, the list can include the respective qualifiers and a cross-reference of RMF OVERVIEW names to TABULAR measures. Note Even if multiple TABULAR control statements are used, you can specify the MSRLIST parameter only once per Analyzer execution. You can specify ALL (for all record types) or one or more of the following record types: CACHE CHANNEL COUPFAC CPU CRYPTO DEVICE IOQ PAGE PAGING PCIE WLM When specifying multiple record types, separate them with commas and enclose them in parentheses. The default is ALL. For a valid TABULAR control statement, you must specify either the MSRLIST or OUTPUT parameter.
NODATA=	Specifies how the report should represent the absence of data Valid NODATA values are: N/A—The field is shown as N/A. ZERO—For numeric measures, the field is shown as a zero (0). For text measures, the field is shown as blanks in the report and a null value in text records. The default is ZERO.
OUTDD=	Specifies the DD name that identifies the sequential file to which value-delimited text records should be written You must define the data set as RECFM=FB, LRECL=80. The BLKSIZE should be a multiple of 80. If you omit BLKSIZE, it defaults to 1600. Note You must specify OUTDD if you specify OUTPUT=RECORDS. If you specify OUTPUT=REPORT or CSV, OUTDD is ignored.
OUTDDCSV=	Specifies the DD name that identifies the sequential file to which value-delimited text records should be written You must define the data set as RECFM=FB, LRECL=32760, BLKSIZE=32760. The default value for LRECL and BLKSIZE is 32760. Note You must specify OUTDDCSV if you specify OUTPUT=CSV. If you specify OUTPUT=REPORT or RECORDS, OUTDDCSV is ignored.
OUTPUT=	Specifies the type of output to be produced Valid OUTPUT values are: RECORDS—A collection of value-delimited text records If you specify OUTPUT=RECORDS, you must also specify the OUTDD parameter. REPORT—A printed tabular report CSV—A comma-separated value (CSV) file If you specify OUTPUT=CSV, you must also specify the OUTDDCSV parameter. Note If you specify OUTPUT, you must also specify the MEASURE parameter with one or more measure expressions.
QUALLIST=	Specifies whether to include the qualifier list in the measure list when MSRLIST is specified Valid QUALLIST values are YES and NO. The default is NO.
SYSID=	Identifies one or more systems to be included in the output You can specify up to 96 system IDs, or an asterisk () for all systems. When specifying multiple system IDs, separate them with commas and enclose them in parentheses. You can also use an asterisk as a wildcard character to specify multiple system IDs that follow a pattern (such as SJS for systems SJSA, SJSB, and SJSC). The default is * for all systems.
XREFLIST=	Specifies whether to include the RMF cross-reference list in the measure list when MSRLIST is specified Valid XREFLIST values are YES and NO. The default is NO.

Measure expressions

Measure expressions identify the measures to be included in TABULAR output. An expression consists of a measure name and, optionally, a user-specified name and qualifier expression.

<measureName>[:[<userName>]:<qualifierExpression>]

The components of a measure expression are as follows:

measureName	Identifies the measure to be included For a list of valid measure names, see these resources: TABULAR Measure List Reference (as created by the MSRLIST parameter) Measure-and-trace-values. Note GRAPH and WLMGRAPH measures do not support qualifier expressions.
userName	(optional) Specifies a user-defined name to replace the measure name that would otherwise appear in TABULAR output You can define your own names to distinguish between multiple instances of the same measure on the same report. The name that you specify cannot exceed eight characters and cannot contain blanks. Note If you specify a qualifier expression but no userName value, you must include the colon as a placeholder (measureName::qualifierExpression).
qualifierExpression	(optional) Limits the data that is included for a measure The output will include only data that matches the qualifier expression. If you do not specify a qualifier expression, the output will include all eligible data. The format of a qualifier expression is: qualifierName:qualifierCondition:qualifierValue All parts of the qualifier expression are required, and you must use a colon to separate them. Note You cannot use qualifier expressions with GRAPH and WLMGRAPH measures.
	*qualifierName* is symbolic name for the field to be compared, as identified in the TABULAR Measure List report (such as LPARNUM for LPAR number or CPUID for CPU identifier)
	qualifierCondition is the type of comparison to be made, as one of the following values: EQ (equal to) NE (not equal to) LT (less than) LE (less than or equal to) GT (greater than) GE (greater than or equal to) BW (begins with) Note You can use BW only with qualifiers that are character- or hexadecimal-string fields.
	qualifierValue is the value to be compared with the qualifier name Valid values are: A character string, such as SYSA An integer string, such as 100 A hexadecimal string, such as 0C00 A keyword, such as DASD Note You can use ALL to select all occurrences of a measure. The value begins with an asterisk to differentiate it from a normal string value of ALL. Typically, you would use ALL with the EQ (equal to) qualifier condition. The length of qualifierValue is restricted: For all qualifier conditions except BW (begins with), the length of qualifierValue must be the same as the length of the field that the qualifier name identifies. For the BW qualifier condition, the length of qualifierValue must be less than the field length. Note For a list of available qualifiers for each measure, see the TABULAR Measure List Reference (as created by the MSRLIST parameter). For each qualifier, the report identifies the field in the SMF record that is examined, and the type and length of qualifier value that you can specify.

TABULAR control statement example

The following example illustrates the use of the TABULAR control statement:

TABULAR OUTPUT=(REPORT,RECORDS,CSV),
  INTERVAL=HOURLY,
  OUTDD=RECDD,
  OUTDDCSV=CSVDD,
  FLDSEP=COLON,
  MEASURE=(DEVACONN:CONNDASD:DEVCLASS:EQ:DASD,
           DEVADISC:DISCDASD:DEVCLASS:EQ:DASD,
           DEVAPEND:PENDDASD:DEVCLASS:EQ:DASD,
           DEVAIOSQ:IOSQDASD:DEVCLASS:EQ:DASD,
           DEVARESP:RESPDASD:DEVCLASS:EQ:DASD,
           DEVACONN:CONNISRP:STGGRP:EQ:ISRPOOL,
           DEVADISC:DISCISRP:STGGRP:EQ:ISRPOOL,
           DEVAPEND:PENDISRP:STGGRP:EQ:ISRPOOL,
           DEVAIOSQ:IOSQISRP:STGGRP:EQ:ISRPOOL,
           DEVARESP:RESPISRP:STGGRP:EQ:ISRPOOL)

This control statement example requests the following:

Five device measures for all devices in the DASD device class, and the same five measures for those devices that are assigned to storage group ISRPOOL
Three types of output (printed tabular report and two types of value-delimited records)
A reporting interval of HOURLY
A colon (:) as the delimiter
Output of OUTPUT=RECORDS directed to DD name RECDD
Output of OUTPUT=CSV directed to DD name CSVDD

The statement produces the following report:

PRODUCED BY CMF ANALYZER (V.R.MM PUT yymm)                 TABULAR REPORT                              RPTSEQ     1 PAGE      1
BMC Software, Inc.                                        BMC SOFTWARE, INC.                            REPORT DATE: 01 JAN yy 12.00
ACTL DD MMM YY 00.00.00 DD MMM YY 06.00.00                  HOUSTON, TX.                               SYSTEM ID: SJSC     Z V.RR.0

BASED ON REC TYPE/# RECS/# SAMPLES/REC HOURS: 74-1/6,703/13K/18.17
   DATE     TIME    CONNDASD DISCDASD PENDDASD IOSQDASD RESPDASD CONNISRP DISCISRP PENDISRP IOSQISRP RESPISRP
                       AVG      AVG      AVG      AVG      AVG      AVG      AVG      AVG      AVG      AVG
DD MMM YY 00.00.00    0.345    0.003    0.161    0.290    0.799    0.107        0    0.196        0    0.303
          01.00.00    0.351    0.002    0.149    1.058    1.560    0.538        0    1.532        0    2.070
          02.00.00    0.353    0.006    0.187    0.061    0.607    0.256        0    1.655        0    1.911
          03.00.00    0.302    0.070    0.158    0.222    0.752    0.196        0    0.312        0    0.508
          04.00.00    0.286    0.001    0.091    0.068    0.446    0.278        0    1.510        0    1.788
          05.00.00    0.324    0.004    0.140    0.068    0.536    0.691        0    0.759        0    1.451
          06.00.00    0.327    0.004    0.131    0.024    0.486    0.119        0    0.216        0    0.335

The statement also produces the following value-delimited text records. The first row identifies the data columns for each record that follows.

Date:Time:Measure:Type:Result:
19 FEB 18:00.00.00:CONNDASD:AVG:0.345:
19 FEB 18:00.00.00:DISCDASD:AVG:0.003:
19 FEB 18:00.00.00:PENDDASD:AVG:0.161:
19 FEB 18:00.00.00:IOSQDASD:AVG:0.290:
19 FEB 18:00.00.00:RESPDASD:AVG:0.799:
19 FEB 18:00.00.00:CONNISRP:AVG:0.107:
19 FEB 18:00.00.00:DISCISRP:AVG:0:
19 FEB 18:00.00.00:PENDISRP:AVG:0.196:
19 FEB 18:00.00.00:IOSQISRP:AVG:0:
19 FEB 18:00.00.00:RESPISRP:AVG:0.303:
19 FEB 18:01.00.00:CONNDASD:AVG:0.351:
19 FEB 18:01.00.00:DISCDASD:AVG:0.002:
19 FEB 18:01.00.00:PENDDASD:AVG:0.149:
19 FEB 18:01.00.00:IOSQDASD:AVG:1.058:
19 FEB 18:01.00.00:RESPDASD:AVG:1.560:
19 FEB 18:01.00.00:CONNISRP:AVG:0.538:
19 FEB 18:01.00.00:DISCISRP:AVG:0:
19 FEB 18:01.00.00:PENDISRP:AVG:1.532:
19 FEB 18:01.00.00:IOSQISRP:AVG:0:

The statement also produces the following CSV file:

DATE:TIME:CONNDASD:DISCDASD:PENDDASD:IOSQDASD:RESPDASD:CONNISRP:DISCISRP:PENDISRP:IOSQISRP:RESPISRP
::AVG:AVG:AVG:AVG:AVG:AVG:AVG:AVG:AVG:AVG
19FEB18:00.00.00:0.345:0.003:0.161:0.290:0.799:0.107:0:0.196:0:0.303
19FEB18:01.00.00:0.351:0.002:0.149:1.058:1.560:0.538:0:1.532:0:2.070
19FEB18:02.00.00:0.353:0.006:0.187:0.061:0.607:0.256:0:1.655:0:1.911
19FEB18:03.00.00:0.302:0.070:0.158:0.222:0.752:0.196:0:0.312:0:0.508
19FEB18:04.00.00:0.286:0.001:0.091:0.068:0.446:0.278:0:1.510:0:1.788
19FEB18:05.00.00:0.324:0.004:0.140:0.068:0.536:0.691:0:0.759:0:1.451
19FEB18:06.00.00:0.327:0.004:0.131:0.024:0.486:0.119:0:0.216:0:0.335

TABULAR Measure List Reference

The TABULAR Measure List Reference is a full or partial list of measures that you can use as values for the MEASURE= parameter of the TABULAR Analyzer control statement. The list includes the measures' respective qualifiers, and, optionally, a cross-reference of the comparable IBM RMF OVERVIEW names.

The TABULAR Analyzer control statement produces the TABULAR Measure List Reference when the MSRLIST= parameter is used.

The following figure shows an example of the TABULAR Measure List Reference.

PRODUCED BY CMF ANALYZER (v.r.mm RSL yymm )        TABULAR Measure List Reference                      RPTSEQ     3 PAGE      6
BMC SOFTWARE, INC.                                        BMC SOFTWARE, INC.                            REPORT DATE: DD MMM YY 13.53
ACTL 25 JUN 14 11.30.00 25 JUN 14 12.30.00                  HOUSTON, TX.                               SYSTEM ID: SJSD     Z 2.01.0

BASED ON REC TYPE/# RECS/# SAMPLES/REC HOURS: 74-5/510/4/1
-------------------------------------------------------- Measure Definition --------------------------------------------------------
--SMF Record -- ---------------------------- Measure --------------------------- Qual                                       RMF
  Name   ID-SID   Name   Type ------------------ Description ------------------- Reqd ------------ Qualifiers ----------- Equiv.
CACHE    74-05 CACHMCSF RATE Global Mirror Collisions Sidefile                       DEVID    VOLSER   SSID              CADGMCSF
                CACHMCSS RATE Global Mirror Collisions Send Sync                      DEVID    VOLSER   SSID              CADGMCSS
                CACHRHR RATE Read I/O requests hit total /second                     DEVID    VOLSER   SSID              CASRHT
                CACHRIOR RATE Read I/O requests total /second                         DEVID    VOLSER   SSID              CASRT
                CACHRMR RATE Cache misses read normal /second                        DEVID    VOLSER   SSID              CASMRN
                CACHRRN RATE Read I/O requests normal /second                        DEVID    VOLSER   SSID              CASRN
                CACHWHR RATE Write I/O requests hit total /second                    DEVID    VOLSER   SSID              CASWHT
                CACHWIOR RATE Write I/O requests total per second                     DEVID    VOLSER   SSID              CASWT
----------------------------------------- Qualifier Definition ----------------------------------------
--SMF Record -- ------------------------- Qualifier ------------------------ ----- Qualifier Field ----
  Name   ID-SID   Name   ------------------ Description -------------------   Type      Name    Length
CACHE    74-05 DEVID    Matches on device ID                                HexStr    R745DEVN      2
                SSID     Matches on SSID                                     HexStr    R745DSID      2
                VOLSER   Matches on VOLSER                                   String    R745DVOL      6
------------------------------ RMF Name Cross-reference -----------------------------
--SMF Record --   RMF    ------------------ Description ------------------- Measure
  Name   ID-SID   Name                                                         Name
CACHE    74-05 CADGMCSF Global Mirror Collisions Sidefile                   CACHMCSF
                CADGMCSS Global Mirror Collisions Send Sync                  CACHMCSS
                CASMRN   Cache misses read normal /second                    CACHRMR
                CASRHT   Read I/O requests hit total /second                 CACHRHR
                CASRN    Read I/O requests normal /second                    CACHRRN
                CASRT    Read I/O requests total /second                     CACHRIOR
                CASWHT   Write I/O requests hit total /second                CACHWHR
                CASWT    Write I/O requests total per second                 CACHWIOR

TABULAR Measure List Reference field descriptions

The table below describes each field in the TABULAR Measure List Reference.

Field	Description
Measure Definition
SMF Record - Name	name of the SMF record
SMF Record - ID-SID	SMF record type ID number and subtype ID number
Measure - Name	name of the measure, as defined by CMF MONITOR
Measure - Type	measure value type:
	RATE	The measure value represents a number of actions or events over a period of time.
	PCT	The measure value represents a percentage.
	AVG	The measure value represents an average.
	MEAS	The measure value is a number.
	TEXT	The measure value is a text string.
Measure - Description	brief description of the measure, which can include the units measured
Qual Reqd	Whether a qualifier is required when you include the measure in the TABULAR Analyzer control statement
Qualifiers	list of one or more valid qualifiers for the measure
Qualifier Definition This section lists each qualifier that appears as a value in the Qualifiers field in the Measure Definition.
SMF Record - Name	name of the SMF record
SMF Record - ID-SID	SMF record type ID number and subtype ID number
Qualifier - Name	name of the qualifier
Qualifier - Description	brief description of the qualifier
Qualifier Field - Type	qualifier field type:
	HexStr	hexadecimal string
	String	text string
	Integer	integer
	Keyword	defined list of valid values
	Binary	two valid values (ON or OFF)
Qualifier Field - Name	qualifier field name
Qualifier Field - Length	number of characters in the qualifier field
RMF Name Cross-reference
SMF Record - Name	name of the SMF record
SMF Record - ID-SID	SMF record type ID number and subtype ID number
RMF Name	name of the measure as defined by the IBM z/OS Resource Measurement Facility (RMF)
Description	brief description of the measure, which can include the units measured
Measure Name	name of the measure as defined by CMF MONITOR