Multiple Cliques In System (OR) High Level In TeraData

What is a clique?

A clique is a set of Teradata nodes that share a common set of disk arrays which are connected in daisy chain network to each disk array controller.

Clique is mainly used to prevent node failures. Group of nodes which share common disk drives is called CLIQUE.

Group of cylindrical or physical disks arranged in array fashion is called VDISKS.

After AMP performing the operations it invokes the controllers to store and manage the data across physical disks.

Here the two controllers are active and they do the same operation so we call this controllers as DUAL REDUNDANT ACTIVE ARRAY CONTROLLERS.

What is meant by AMP in Teradata?

AMP, acronym for “Access Module Processor,” is the type of vproc (Virtual Processor) used to manage the database, handle file tasks and and manipulate the disk subsystem in the multi-tasking and possibly parallel-processing environment of the Teradata Database. AMP contains Database Management Subsystem and it performs below operations:

• DDL
• DML
• Applying and releasing the locks
• Joins, aggregations, etc

Interested in mastering Teradata Training? Enroll now for FREE demo on Teradata Training.

In the event of a node failure, cliques provide for data access through vproc migration. When a node resets, the following happens to the AMPs:

• When the node fails, the Teradata Database restarts across all remaining nodes in the system.
• The vprocs (AMPs) from the failed node migrate to the operational nodes in its clique.
• The PE vprocs will migrate as follows: LAN attached PEs will migrate to other nodes in the clique. Channel attached PEs will not migrate. While that node remains down, that channel connection is not available.
• Disks managed by the AMP remain available and processing continues while the failed node is being repaired.

• Cliques in a System

Vprocs are distributed across all nodes in the system. Multiple cliques in the system should have the same number of nodes.

The diagram below shows three cliques. The nodes in each clique are cabled to the same disk arrays. The overall system is connected by the BYNET. If one node goes down in a clique the vprocs will migrate to the other nodes in the clique, so data remains available. However, system performance decreases due to the loss of a node. System performance degradation is proportional to clique size.

Check out the top Teradata Interview Questions now!

BYNET (Banyan Network)

It acts like “Message Communication” layer between components.

1. SMP BYNET [PE-AMP]

POINT-POINT : One msg from PE – One Amp

MULTICAST     : One msg from PE- Many Amps

BROADCAST    : One msg from PE – All Amps

2. MPP BYNET [NODE-NODE]

POINT-POINT : One msg from One Node to Another Node

MULTICAST     : One msg from One Node to Many Node

BROADCAST    : One msg from One Node to All Nodes

MULTIPLE CLIQUES IN SYSTEM (OR) HIGH LEVEL

INSIDE CLIQUE PROCESS(OR)SINGLE CLIQUE:-

If Node, fails

HSN (HOT STAND by NODE)

This node is not functional till any other node goes down, simply acts like an extra player. In a clique,multiple nodes are accessible by any node in the same clique. The facing page shows a situation where a node fails. When the node fails PDE resets and Teradata restarts and the amp vprocs migrate to the other nodes in the clique.

• Teradata Wallet
• Memory Management in TeraData
• TPUMP Structure and Process In TeraData
• Teradata Parallel Transporter(TPT)
• TeraData Interview Questions and Answers