Net: Message Type Columns - Advanced SQL Engine - Teradata Database

Resource Usage Macros and Tables

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
dep1592878989156.ditamap
dita:ditavalPath
dep1592878989156.ditaval
dita:id
B035-1099
lifecycle
previous
Product Category
Teradata Vantageā„¢
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