17.05 - Memory: Node Level Buffering Columns - Teradata Database

Teradata Vantageā„¢ - Resource Usage Macros and Tables

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Administration
User Guide
featnum
B035-1099-170K
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