15.10 - Net: Message Type Columns - Teradata Database

Teradata Database Resource Usage Macros and Tables

Product
Teradata Database
Release Number
15.10
Published
April 2016
Language
English (United States)
Last Update
2018-05-17
dita:mapPath
Resource_Usage_Macros_15_10.ditamap
dita:ditavalPath
ft:empty

These columns subdivide all messages sent and received into the type of message, where:

  • Hash messages (Hash) are data sent to a destination through its primary or fallback hash value.
  • Processor messages (Proc) are data sent to a destination through a vproc ID.
  • Group messages (Group) are broadcasted messages to be received by members of a group.
  • local messages (Local) are messages communicated locally within the node.
  • Channel messages (Chan) are data sent between vprocs through channel IDs for purposes of a private conversation to perform functions such as row redistribution, and so on.
  • Mailbox messages (Mbox) are data sent between vprocs through mailbox IDs for similar purposes as channel messages.

A duplicated accounting is done with two different perspectives, since Hash + Proc + Group + Local messages = Chan + MBox messages.

Column Name Mode Description Data Type
MsgChanReads count Number of channel messages read by this vproc. FLOAT
MsgChanWrites count Number of channel messages written by this vproc. FLOAT
MsgHashReads count Number of hash messages read by this vproc. FLOAT
MsgHashWrites count Number of hash messages written by this vproc. FLOAT
MsgGroupReads count Number of group messages read by this vproc. FLOAT
MsgGroupWrites count Number of group messages written by this vproc. FLOAT
MsgLocalReads count Number of local messages read by this vproc. FLOAT
MsgLocalWrites count Number of local messages written by this vproc. FLOAT
MsgProcReads count Number of processor messages read by this vproc. FLOAT
MsgProcWrites count Number of processor messages written by this vproc. FLOAT
MsgMboxReads count Number of mailbox messages read by this vproc. FLOAT
MsgMboxWrites count Number of mailbox messages written by this vproc. FLOAT