IBM Integration Bus, Version 10.0.0.17 Operating Systems: AIX, HP-Itanium, Linux, Solaris, Windows, z/OS


CSV file format for message flow accounting and statistics data

Snapshot and archive data records are written to output files in comma-separated value (.csv) format.

The output files include a header with the field name. The fields for averages are optional, and are written only if the averages property of the statistics file writer is set to true. One line is written for each message flow that is producing data for the time period that you choose. For example, if MessageFlowA and MessageFlowB are both producing archive data over a period of 60 minutes, both message flows produce a line of statistics data every 60 minutes.

The following table describes the general accounting and statistics information. These fields appear in all file types.

Field Data type Details
RecordType Character Type of output, one of:
  • Archive
  • Snapshot
RecordCode Character Reason for output, one of:
  • MajorInterval
  • Snapshot
  • Shutdown
  • ReDeploy
  • StatsSettingsModified

The following table describes the message flow statistics information, which is written to the flowStats files.

Field Data type Details
BrokerLabel

Character
(maximum 32)

Integration node name
BrokerUUID

Character
(maximum 32)

Integration node universal unique identifier
ExecutionGroupName

Character
(maximum 32)

Integration server name
ExecutionGroupUUID

Character
(maximum 32)

Integration server universal unique identifier
MessageFlowName

Character
(maximum 32)

Message flow name
StartDate Character

Interval start date
(YYYY-MM-DD)

StartTime Character

Interval start time
(HH:MM:SS:NNNNNN)

GMTStartTime Character Interval start date and time (universal timestamp in ISO8601)
EndDate Character

Interval end date
(YYYY-MM-DD)

EndTime Character

Interval end time
(HH:MM:SS:NNNNNN)

GMTEndTime Character Interval end date and time (universal timestamp in ISO8601)
TotalElapsedTime Numeric Total elapsed time spent processing input messages (microseconds)
AverageElapsedTime Numeric Average elapsed time spent processing input messages (microseconds)
MaximumElapsedTime Numeric Maximum elapsed time that is spent processing an input message (microseconds)
MinimumElapsedTime Numeric Minimum elapsed time that is spent processing an input message (microseconds)
TotalCPUTime Numeric Total processor time spent processing input messages (microseconds)
AverageCPUTime Numeric Average processor time that is spent processing an input message (microseconds)
MaximumCPUTime Numeric Maximum processor time that is spent processing an input message (microseconds)
MinimumCPUTime Numeric Minimum processor time that is spent processing an input message (microseconds)
CPUTimeWaitingForInputMessage Numeric Total processor time spent waiting for input messages (microseconds)
ElapsedTimeWaitingForInputMessage Numeric Total elapsed time that is spent waiting for input messages (microseconds)
TotalInputMessages Numeric Total number of messages processed

TotalInputMessages records only those messages that are propagated from input node terminals.

TotalSizeOfInputMessages Numeric Total size of input messages (bytes)
AverageSizeOfInputMessages Numeric Average size of input messages (bytes)
MaximumSizeOfInputMessages Numeric Maximum input message size (bytes)
MinimumSizeOfInputMessages Numeric Minimum message input size (bytes)
NumberOfThreadsInPool Numeric Number of threads in pool
TimesMaximumNumberofThreadsReached Numeric Number of times the maximum number of threads is reached
TotalNumberOfMQErrors Numeric Number of MQGET errors (MQInput node) or web services errors (HTTPInput node)

For example, a conversion error occurs when the message is got from the queue.

TotalNumberOfMessagesWithErrors Numeric Number of messages that contain errors

These errors include exceptions that are thrown downstream of the input node, and errors that are detected by the input node after it successfully retrieves the message from the queue, but before it propagates it to the output terminal (for example, a format error).

TotalNumberOfMessagesWithErrors can include messages that are not included in TotalInputMessages.

TotalNumberOfErrorsProcessingMessages Numeric Number of errors when processing a message
TotalNumberOfTimeOutsWaitingForRepliesToAggregateMessages Numeric Number of timeouts when processing a message (AggregateReply node only)
TotalNumberOfCommits Numeric Number of transaction commits
TotalNumberOfBackouts Numeric Number of transaction backouts
AccountingOrigin Character (maximum 32) Accounting origin

The following table describes the thread statistics information, created in threadStats files.

Field Data type Details
Number Numeric Number of thread statistics subfolders in Threads folder

The following table describes the thread statistics information for each individual thread, created in threadStats files.

Field Data type Details
Number Numeric Relative thread number in pool
TotalNumberOfInputMessages Numeric Total number of messages that are processed by a thread
TotalElapsedTime Numeric Total elapsed time spent processing input messages (microseconds)
AverageElapsedTime Numeric Average elapsed time spent processing input messages (microseconds)
TotalCPUTime Numeric Total processor time spent processing input messages (microseconds)
AverageCPUTime Numeric Average processor time that is spent processing an input message (microseconds)
CPUTimeWaitingForInputMessage Numeric Total processor time spent waiting for input messages (microseconds)
ElapsedTimeWaitingForInputMessage Numeric Total elapsed time that is spent waiting for input messages (microseconds)
TotalSizeOfInputMessages Numeric Total size of input messages (bytes)
AverageSizeOfInputMessages Numeric Average size of input messages (bytes)
MaximumSizeOfInputMessages Numeric Maximum size of input messages (bytes)
MinimumSizeOfInputMessages Numeric Minimum size of input messages (bytes)

The following table describes the node statistics information, created in nodeStats files.

Field Data type Details
Number Numeric Number of node statistics subfolders in Nodes folder

The following table describes the node statistics information for each individual node, created in nodeStats files.

Field Data type Details
Label Character Name of node (Label)
Type Character Type of node
TotalElapsedTime Numeric Total elapsed time spent processing input messages (microseconds)
AverageElapsedTime Numeric Average elapsed time spent processing input messages (microseconds)
MaximumElapsedTime Numeric Maximum elapsed time spent processing input messages (microseconds)
MinimumElapsedTime Numeric Minimum elapsed time spent processing input messages (microseconds)
TotalCPUTime Numeric Total processor time spent processing input messages (microseconds)
AverageCPUTime Numeric Average processor time that is spent processing an input message (microseconds)
MaximumCPUTime Numeric Maximum processor time spent processing input messages (microseconds)
MinimumCPUTime Numeric Minimum processor time spent processing input messages (microseconds)
CountOfInvocations Numeric Total number of messages that are processed by this node
NumberOfInputTerminals Numeric Number of input terminals
NumberOfOutputTerminals Numeric Number of output terminals

bn23635_.htm | Last updated 2019-07-13 08:13:52