Memory: Node Level Buffering Columns - Advanced SQL Engine - Teradata Database

Resource Usage Macros and Tables

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
fwg1557098454552.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1099
lifecycle
previous
Product Category
Teradata Vantageā„¢
Column Name Mode Description Data Type
NLBActiveSessionsMax max Maximum concurrent Node Level Buffering sessions.

Node Level Buffering is typically used for redistributions (RRD) and duplications (DUP).

FLOAT
NLBSessionsInuse track Current number of active Node Level Buffering sessions.

Node Level Buffering is typically used for redistributions (RRD) and duplications (DUP).

FLOAT
NLBSessionsCompleted count Number of Node Level Buffering sessions completed.

Node Level Buffering is typically used for redistributions (RRD) and duplications (DUP).

FLOAT
NLBMsgFlowControlled track Number of Node Level Buffered messages being flow controlled on the sender side (or node).

Node Level Buffering is typically used for redistributions (RRD) and duplications (DUP).

These messages use a different mailbox than the AMP work mailbox. They are allocated channel linked mailboxes.

FLOAT
NLBMsgFlowControlledKB track Amount of segment memory in use by Flow Controlled Node Level Buffered Messages at the time of the RSS gather operation.

Node Level Buffering is typically used for redistributions (RRD) and duplications (DUP).

The pages associated with segments used by Node Level Buffered messages are pinned in memory for bynet DMA.

FLOAT