TCP/IP Data Collection and Reporting Tables (MF User)

This section provides information to help you define the parameters of your COLLECT and custom REPORT statements. See COLLECT Statement and REPORT Statement for Custom Reports for information.

Performance Test for Mainframe Servers provides the following tables of data collection and reporting criteria:

PLAYBACK Table
SOCKETS Table
SCRIPT Table
CONNECTION Table
MESSAGE Table

Most report tables are broken into two sections:

Report fields: Collect any or all of these fields during playback. Then build custom reports containing the fields you need.

Example

COLLECT FIELDS(*) FROM(PLAYBACK)

collects all report fields from the PLAYBACK table.

REPORT FIELDS(OWNA, JBNA, PLNA) FROM(PLAYBACK)

reports the OwnerName, JobName, and PlaybackName fields from the PLAYBACK table.

Statistic fields: These fields report counts, minimum and maximum values, averages, and sums of specified report fields. You do not collect statistic fields, but do collect the field the statistic is based on. For example, collect SocketsDuration from the SOCKETS table to report the SUM of SocketsDuration on a PLAYBACK report.

While sorting the collected data, Performance Test for Mainframe Servers calculates statistics for that data. Report the statistic by specifying any or all of the statistics fields on your REPORT statements.

Additionally, statistics are relative to the table from which they are reported.

Example

REPORT FIELDS(MAX(ConnectionDuration)) FROM(PLAYBACK)

reports the longest connection duration that occurred during the playback.

REPORT FIELDS(MAX(ConnectionDuration)) FROM(SOCKETS)

reports the longest connection duration from each sockets played back.

The tables include the long and short name for each report field. Use either on the FIELDS declarations of your COLLECT and REPORT statements.

PLAYBACK table

The PLAYBACK table includes both report and statistic fields.

PLAYBACK report fields

COLLECT any or all of the following fields and REPORT them on customized PLAYBACK reports.

Long Field Names	Short Field Names
JobName	JBNA
JobNumber	JBNU
OwnerName	OWNA
PlaybackDuration	PLDR
PlaybackFinishTime	PLFT
PlaybackName	PLNA
PlaybackNumber	PLNU
PlaybackReturnCode	PLRC
PlaybackStartTime	PLST
SocketsStatementCount	SOSC
SystemName	SYNA

Important

Performance Test

for Mainframe Servers and

Performance Test

for WebSphere MQ share the same PLAYBACK report fields table. As such, a report containing all of the fields from the table includes the MQGroupStatementCount field.

PLAYBACK statistic fields

REPORT any of the following statistics on customized PLAYBACK reports.

Important

Use the Collect from Table column to determine the parameters for the collection statement required to report the given statistic. For example, to report MAXIMUM ConnectionCount from the PLAYBACK table, you need to collect the ConnectionCount field from the SCRIPT table. Collect all fields from all tables to simplify collection and to ensure a complete reporting database.

Statistics	For Field (long names)	Field Short Names	Collect from Table
MIN or MAX	SocketsReturnCode	SORC	SOCKETS
MIN or MAX	ScriptReturnCode	SCRC	SCRIPT
AVG, MIN, MAX, or SUM	SocketsDuration	SODR	SOCKETS
AVG, MIN, MAX, or SUM	ScriptDuration	SCDR	SCRIPT
AVG, MIN, MAX, or SUM	ConnectionDuration	CNDR	CONNECTION
AVG, MIN, MAX, or SUM	MessageDuration	MSDR	MESSAGE
AVG, MIN, MAX, or SUM	InitialResponseTime	RTIN	MESSAGE
AVG, MIN, MAX, or SUM	FinalResponseTime	RTFN	MESSAGE
AVG, MIN, or MAX	BytesSentRate	BYSR	MESSAGE
AVG, MIN, or MAX	BytesReceivedRate	BYRR	MESSAGE
SUM	ScriptStatementCount	SCSC	SOCKETS
AVG, MIN, MAX, or SUM	ConnectionCount	CNCT	SCRIPT
AVG, MIN, MAX, or SUM	MessageCount	MSCT	CONNECTION
AVG, MIN, MAX, or SUM	ConnectionsAttempted	CNAT	CONNECTION
AVG, MIN, MAX, or SUM	ConnectionsRefused	CNRF	CONNECTION
AVG, MIN, MAX, or SUM	ConnectionsTimedOut	CNTO	CONNECTION
AVG, MIN, MAX, or SUM	TimeToConnect	TMTC	CONNECTION
AVG, MIN, MAX, or SUM	TimeForConnectionRefusal	TMCR	CONNECTION
AVG, MIN, MAX, or SUM	TimeForConnectionTimedOut	TMCT	CONNECTION
MIN or MAX	ConnectionStatus	CNSC	CONNECTION
AVG, MIN, or MAX	ConnectionRate	CNRT	SCRIPT
AVG, MIN, or MAX	MessageRate	MSRT	CONNECTION
AVG, MIN, MAX, or SUM	RequestByteCount	RQCT	MESSAGE
MIN or MAX	RequestVersionNumber	RQVN	MESSAGE
AVG, MIN, MAX, or SUM	RequestHeaderCount	RQHC	MESSAGE
CNT	RequestHeadersnnnn¹	RQHDnnnn	MESSAGE
AVG, MIN, MAX, or SUM	RequestBodyLineCount	RQBL	MESSAGE
AVG, MIN, MAX, or SUM	RequestBodyByteCount	RQBB	MESSAGE
AVG, MIN, MAX, or SUM	ResponseByteCount	RSCT	MESSAGE
MIN or MAX	ResponseVersionNumber	RSVN	MESSAGE
MIN or MAX	ResponseStatusCode	RSSC	MESSAGE
AVG, MIN, MAX, or SUM	ResponseHeaderCount	RSHC	MESSAGE
CNT	ResponseHeadernnnn 1^¹	RSHDnnnn	MESSAGE
AVG, MIN, MAX, or SUM	ResponseBodyByteCount	RSBB	MESSAGE
AVG, MIN, MAX, or SUM	ResponseBodyLineCount	RSBL	MESSAGE
AVG, MIN, MAX, or SUM	ExpResponseByteCount	EXCT	MESSAGE
MIN or MAX	ExpResponseVersionNumber	EXVN	MESSAGE
MIN or MAX	ExpResponseStatusCode	EXSC	MESSAGE
AVG, MIN, MAX, or SUM	ExpResponseHeaderCount	EXHC	MESSAGE
CNT	ExpResponseHeadernnnn¹	EXHDnnnn	MESSAGE
AVG, MIN, MAX, or SUM	ExpResponseBodyByteCount	EXBB	MESSAGE
AVG, MIN, MAX, or SUM	ExpResponseBodyLineCount	EXBL	MESSAGE

Where nnnn is the Header Field Identifier. See Valid Values for RequestHeadernnnn, ResponseHeadernnnn, ExpResponseHeadernnnn, for a list of identifiers.

SOCKETS table

The SOCKETS table includes both report and statistic fields.

SOCKETS report fields

COLLECT any or all of the following fields and REPORT them on customized SOCKETS reports.

Long Field Names	Short Field Names
PlaybackNumber	PLNU
ScriptStatementCount	SCSC
SocketsDuration	SODR
SocketsFinishTime	SOFT
SocketsID	SOID
SocketsNumber	SONU
SocketsReturnCode	SORC
SocketsStartTime	SOST

SOCKETS statistic fields

REPORT any of the following statistics on customized SOCKETS reports.

Important

Use the Collect from Table column to determine the parameters for the collection statement required to report the given statistic. For example, to report MAXIMUM ScriptDuration from the SOCKETS table, you need to collect the ScriptDuration field from the SCRIPT table. Collect all fields from all tables to simplify collection and to ensure a complete reporting database.

Statistics	For Field (long names)	Field Short Names	Collect from Table
MIN or MAX	ScriptReturnCode	SCRC	SCRIPT
AVG, MIN, MAX, or SUM	ScriptDuration	SCDR	SCRIPT
AVG, MIN, MAX, or SUM	ConnectionDuration	CNDR	CONNECTION
AVG, MIN, MAX, or SUM	MessageDuration	MSDR	MESSAGE
AVG, MIN, MAX, or SUM	InitialResponseTime	RTIN	MESSAGE
AVG, MIN, MAX, or SUM	FinalResponseTime	RTFN	MESSAGE
AVG, MIN, or MAX	BytesSentRate	BYSR	MESSAGE
AVG, MIN, or MAX	BytesReceivedRate	BYRR	MESSAGE
AVG, MIN, MAX, or SUM	ConnectionCount	CNCT	SCRIPT
AVG, MIN, MAX, or SUM	MessageCount	MSCT	CONNECTION
AVG, MIN, MAX, or SUM	ConnectionsAttempted	CNAT	CONNECTION
AVG, MIN, MAX, or SUM	ConnectionsRefused	CNRF	CONNECTION
AVG, MIN, MAX, or SUM	ConnectionsTimedOut	CNTO	CONNECTION
AVG, MIN, MAX, or SUM	TimeToConnect	TMTC	CONNECTION
AVG, MIN, MAX, or SUM	TimeForConnectionRefusal	TMCR	CONNECTION
AVG, MIN, MAX, or SUM	TimeForConnectionTimedOut	TMCT	CONNECTION
MIN or MAX	ConnectionStatus	CNSC	CONNECTION
AVG, MIN, or MAX	ConnectionRate	CNRT	SCRIPT
AVG, MIN, or MAX	MessageRate	MSRT	CONNECTION
AVG, MIN, MAX, or SUM	RequestByteCount	RQCT	MESSAGE
MIN or MAX	RequestVersionNumber	RQVN	MESSAGE
AVG, MIN, MAX, or SUM	RequestHeaderCount	RQHC	MESSAGE
CNT	RequestHeadersnnnn¹	RQHDnnnn	MESSAGE
AVG, MIN, MAX, or SUM	RequestBodyLineCount	RQBL	MESSAGE
AVG, MIN, MAX, or SUM	RequestBodyByteCount	RQBB	MESSAGE
AVG, MIN, MAX, or SUM	ResponseByteCount	RSCT	MESSAGE
MIN or MAX	ResponseVersionNumber	RSVN	MESSAGE
MIN or MAX	ResponseStatusCode	RSSC	MESSAGE
AVG, MIN, MAX, or SUM	ResponseHeaderCount	RSHC	MESSAGE
CNT	ResponseHeadernnnn¹	RSHDnnnn	MESSAGE
AVG, MIN, MAX, or SUM	ResponseBodyByteCount	RSBB	MESSAGE
AVG, MIN, MAX, or SUM	ResponseBodyLineCount	RSBL	MESSAGE
AVG, MIN, MAX, or SUM	ExpResponseByteCount	EXCT	MESSAGE
MIN or MAX	ExpResponseVersionNumber	EXVN	MESSAGE
MIN or MAX	ExpResponseStatusCode	EXSC	MESSAGE
AVG, MIN, MAX, or SUM	ExpResponseHeaderCount	EXHC	MESSAGE
CNT	ExpResponseHeadernnnn¹	EXHDnnnn	MESSAGE
AVG, MIN, MAX, or SUM	ExpResponseBodyByteCount	EXBB	MESSAGE
AVG, MIN, MAX, or SUM	ExpResponseBodyLineCount	EXBL	MESSAGE

Where nnnn is the Header Field Identifier. See Valid Values for RequestHeadernnnn, ResponseHeadernnnn, ExpResponseHeadernnnn , for a list of identifiers.

SCRIPT table

The SCRIPT table includes both report and statistic fields.

SCRIPT report fields

COLLECT any or all of the following fields and REPORT them on customized SCRIPT reports.

Long Field Names	Short Field Names
ConnectionCount	CNCT
ConnectionRate	CNRT
PlaybackNumber	PLNU
ScriptDuration	SCDR
ScriptFinishTime	SCFT
ScriptName	SCNA
ScriptNumber	SCNU
ScriptReturnCode	SCRC
ScriptStartTime	SCST
SocketsNumber	SONU

SCRIPT statistic fields

REPORT any of the following statistics on customized SCRIPT reports.

Important

Use the Collect from Table column to determine the parameters for the collection statement required to report the given statistic. For example, to report MAXIMUM MessageRate from the SCRIPT table, you need to collect the MessageRate field from the CONNECTION table. Collect all fields from all tables to simplify collection and ensure a complete reporting database.

Statistics	For Field (long names)	Field Short Names	Collect from Table
AVG, MIN, MAX, or SUM	ConnectionDuration	CNDR	CONNECTION
AVG, MIN, MAX, or SUM	MessageDuration	MSDR	MESSAGE
AVG, MIN, MAX, or SUM	InitialResponseTime	RTIN	MESSAGE
AVG, MIN, MAX, or SUM	FinalResponseTime	RTFN	MESSAGE
AVG, MIN, or MAX	BytesSentRate	BYSR	MESSAGE
AVG, MIN, or MAX	BytesReceivedRate	BYRR	MESSAGE
AVG, MIN, MAX, or SUM	MessageCount	MSCT	CONNECTION
AVG, MIN, MAX, or SUM	ConnectionsAttempted	CNAT	CONNECTION
AVG, MIN, MAX, or SUM	ConnectionsRefused	CNRF	CONNECTION
AVG, MIN, MAX, or SUM	ConnectionsTimedOut	CNTO	CONNECTION
AVG, MIN, MAX, or SUM	TimeToConnect	TMTC	CONNECTION
AVG, MIN, MAX, or SUM	TimeForConnectionRefusal	TMCR	CONNECTION
AVG, MIN, MAX, or SUM	TimeForConnectionTimedOut	TMCT	CONNECTION
MIN or MAX	ConnectionStatus	CNSC	CONNECTION
AVG, MIN, or MAX	MessageRate	MSRT	CONNECTION
AVG, MIN, MAX, or SUM	RequestByteCount	RQCT	MESSAGE
MIN or MAX	RequestVersionNumber	RQVN	MESSAGE
AVG, MIN, MAX, or SUM	RequestHeaderCount	RQHC	MESSAGE
CNT	RequestHeadersnnnn¹	RQHDnnnn	MESSAGE
AVG, MIN, MAX, or SUM	RequestBodyLineCount	RQBL	MESSAGE
AVG, MIN, MAX, or SUM	RequestBodyByteCount	RQBB	MESSAGE
AVG, MIN, MAX, or SUM	ResponseByteCount	RSCT	MESSAGE
MIN or MAX	ResponseVersionNumber	RSVN	MESSAGE
MIN or MAX	ResponseStatusCode	RSSC	MESSAGE
AVG, MIN, MAX, or SUM	ResponseHeaderCount	RSHC	MESSAGE
CNT	ResponseHeadernnnn¹	RSHDnnnn	MESSAGE
AVG, MIN, MAX, or SUM	ResponseBodyByteCount	RSBB	MESSAGE
AVG, MIN, MAX, or SUM	ResponseBodyLineCount	RSBL	MESSAGE
AVG, MIN, MAX, or SUM	ExpResponseByteCount	EXCT	MESSAGE
MIN or MAX	ExpResponseVersionNumber	EXVN	MESSAGE
MIN or MAX	ExpResponseStatusCode	EXSC	MESSAGE
AVG, MIN, MAX, or SUM	ExpResponseHeaderCount	EXHC	MESSAGE
CNT	ExpResponseHeadernnnn¹	EXHDnnnn	MESSAGE
AVG, MIN, MAX, or SUM	ExpResponseBodyByteCount	EXBB	MESSAGE
AVG, MIN, MAX, or SUM	ExpResponseBodyLineCount	EXBL	MESSAGE

¹Where nnnn is the Header Field Identifier. See Table 6, for a list of identifiers.

CONNECTION table

The CONNECTION table includes both report and statistic fields.

CONNECTION report fields

COLLECT any or all of the following fields and REPORT them on customized CONNECTION reports.

Long Field Names	Short Field Names
ClientAddress	CLAD
ClientPort	CLPT
ConnectionDuration	CNDR
ConnectionFinishTime	CNFT
ConnectionID	CNID
ConnectionNumber	CNNU
ConnectionsAttempted	CNAT
ConnectionsRefused	CNRF
ConnectionStartTime	CNST
ConnectionStatus	CNSC
ConnectionsTimedOut	CNTO
MessageCount	MSCT
MessageRate	MSRT
PlaybackNumber	PLNU
Protocol	PROT
ScriptNumber	SCNU
ServerAddress	SVAD
ServerPort	SVPT
SocketsNumber	SONU
TimeForConnectionRefusal	TMCR
TimeForConnectionTimedOut	TMCT
TimeToConnect	TMTC

CONNECTION statistic fields

REPORT any of the following statistics on customized CONNECTION reports.

Important

Use the Collect from Table column to determine the parameters for the collection statement required to report the given statistic. For example, to report MAXIMUM MessageDuration from the CONNECTION table, collect the MessageDuration field from the MESSAGE table. Collect all fields from all tables to simplify collection and to ensure a complete reporting database.

Statistics	For Field (long names)	Field Short Names	Collect from Table
AVG, MIN, MAX, or SUM	MessageDuration	MSDR	MESSAGE
AVG, MIN, MAX, or SUM	InitialResponseTime	RTIN	MESSAGE
AVG, MIN, MAX, or SUM	FinalResponseTime	RTFN	MESSAGE
AVG, MIN, or MAX	BytesSentRate	BYSR	MESSAGE
AVG, MIN, or MAX	BytesReceivedRate	BYRR	MESSAGE
AVG, MIN, MAX, or SUM	RequestByteCount	RQCT	MESSAGE
MIN or MAX	RequestVersionNumber	RQVN	MESSAGE
AVG, MIN, MAX, or SUM	RequestHeaderCount	RQHC	MESSAGE
CNT	RequestHeadersnnnn¹	RQHDnnnn	MESSAGE
AVG, MIN, MAX, or SUM	RequestBodyLineCount	RQBL	MESSAGE
AVG, MIN, MAX, or SUM	RequestBodyByteCount	RQBB	MESSAGE
AVG, MIN, MAX, or SUM	ResponseByteCount	RSCT	MESSAGE
MIN or MAX	ResponseVersionNumber	RSVN	MESSAGE
MIN or MAX	ResponseStatusCode	RSSC	MESSAGE
AVG, MIN, MAX, or SUM	ResponseHeaderCount	RSHC	MESSAGE
CNT	ResponseHeadernnnn¹	RSHDnnnn	MESSAGE
AVG, MIN, MAX, or SUM	ResponseBodyByteCount	RSBB	MESSAGE
AVG, MIN, MAX, or SUM	ResponseBodyLineCount	RSBL	MESSAGE
AVG, MIN, MAX, or SUM	ExpResponseByteCount	EXCT	MESSAGE
MIN or MAX	ExpResponseVersionNumber	EXVN	MESSAGE
MIN or MAX	ExpResponseStatusCode	EXSC	MESSAGE
AVG, MIN, MAX, or SUM	ExpResponseHeaderCount	EXHC	MESSAGE
CNT	ExpResponseHeadernnnn¹	EXHDnnnn	MESSAGE
AVG, MIN, MAX, or SUM	ExpResponseBodyByteCount	EXBB	MESSAGE
AVG, MIN, MAX, or SUM	ExpResponseBodyLineCount	EXBL	MESSAGE

¹Where nnnn is the Header Field Identifier. See Valid Values for RequestHeadernnnn, ResponseHeadernnnn, ExpResponseHeadernnnn, for a list of identifiers.

MESSAGE table

The MESSAGE table includes only report fields; not statistics fields.

MESSAGE report fields

COLLECT any or all of the following fields and REPORT them on customized MESSAGE reports.

Important

Some fields do not apply to all protocols. The columns on the right side of the table indicate the protocol the field applies to.

Long Field Names	Short Field Names	HTTP, HTTPS	TCP, IMSC	DB2C	ECI	CTG
AF_family	AFIN	X	X	X	X	X
BytesReceivedRate	BYRR	X	X	X	X	X
BytesSentRate	BYSR	X	X	X	X	X
ClientAddress6	CLA6	X	X	X	X	X
ConnectionNumber	CNNU	X	X	X	X	X
DB2SqlCode	SQCD			X
DB2SqlState	SQST			X
DB2SqlStatement	SQSM			X
DB2SqlAnswerSet	SQAS			X
DB2RDBNAM	RDBN			X
DB2Userid	SQUS			X
ExpDB2SqlCode	EXSQCD			X
ExpDB2SqlState	EXSQST			X
ExpDB2SqlAnswerSet	EXSQAS			X
ExpResponseBody¹	EXBD	X	X	X	X	X
ExpResponseBodyByteCount	EXBB	X	X	X	X	X
ExpResponseBodyLineCount	EXBL	X
ExpResponseByteCount	EXCT	X	X	X	X	X
ExpResponseHeaderCount	EXHC	X			X	X
ExpResponseHeadernnnn²	EXHDnnnn	X
ExpResponseHeaders	EXHS	X			X	X
ExpResponseReasonPhrase	EXRP	X
ExpResponseStatusCode	EXSC	X
ExpResponseVersionNumber	EXVN	X
FinalResponseTime	RTFN	X	X	X	X	X
InitialResponseTime	RTIN	X	X	X	X	X
MessageDuration	MSDR	X	X	X	X	X
MessageFinishTime	MSFT	X	X	X	X	X
MessageID	MSID	X	X	X	X	X
MessageNumber	MSNU	X	X	X	X	X
MessageStartTime	MSST	X	X	X	X	X
PlaybackNumber	PLNU	X	X	X	X	X
RequestBody¹	RQBD	X	X	X	X	X
RequestBodyByteCount	RQBB	X	X	X	X	X
RequestBodyLineCount	RQBL	X
RequestByteCount	RQCT	X	X	X	X	X
RequestHeaderCount	RQHC	X			X	X
RequestHeadernnnn²	RQHDnnnn	X
RequestHeaders	RQHS	X			X	X
RequestMethod	RQME	X
RequestURI	RQUR	X
RequestVersionNumber	RQVN	X
ResponseBody¹	RSBD	X	X	X	X	X
ResponseBodyByteCount	RSBB	X	X	X	X	X
ResponseBodyLineCount	RSBL	X
ResponseByteCount	RSCT	X	X	X	X	X
ResponseHeaderCount	RSHC	X			X	X
ResponseHeadernnnn²	RSHDnnnn	X
ResponseHeaders	RSHS	X			X	X
ResponseReasonPhrase	RSRP	X
ResponseStatusCode	RSSC	X
ResponseVersionNumber	RSVN	X
ScriptNumber	SCNU	X	X	X	X	X
ServerAddress6	SVA6	X	X	X	X	X
SocketsNumber	SONU	X	X	X	X	X

¹For ECI and CTG playback, this field reports ECI COMMAREA data.

²Where nnnn is the Header Field Identifier. See Valid Values for RequestHeadernnnn, ResponseHeadernnnn, ExpResponseHeadernnnn, for a list of identifiers.

TCP/IP Data Collection and Reporting Tables (MF User)

PLAYBACK table

PLAYBACK report fields

PLAYBACK statistic fields

SOCKETS table

SOCKETS report fields

SOCKETS statistic fields

SCRIPT table

SCRIPT report fields

SCRIPT statistic fields

CONNECTION table

CONNECTION report fields

CONNECTION statistic fields

MESSAGE table

MESSAGE report fields

On this page