Example Scenario - Teradata Unity

Teradata® Unity™ User Guide

Product

Teradata Unity

Release Number

16.20

Published

May 2019

Language

English (United States)

Last Update

2019-05-23

dita:mapPath

dzf1517499323110.ditamap

dita:ditavalPath

ft:empty

dita:id

B035-2520

lifecycle

Product Category

Analytical Ecosystem

The following example demonstrates using unityadmin to verify a successful Unity installation.

Viewing Status Information

Run STATUS to view system details.

unityadmin> status;
Sequencer: region1_seq-fastcop1(active), Repository: prod1(active)
Sequencer: region2_seq-bltorcop1(standby-synchronized), Repository: prod2(standby - synced)
Endpoint region1_ept: 10.25.1.4(not listening):1025, 153.65.194.99(listening):1025, 10.25.1.9(not listening):1025, 153.65.194.55(not listening):1025
Endpoint region2_ept: any(listening):1025
System prod1(unrecoverable) Tables: OOS 0, standby 0, unrecoverable 0, interrupted 0, restore 0, read-only 0, active 0
Dispatcher status: region2_dsp_prod1(standby) - down, region1_dsp_prod1(active) – up
Gateway status: flash - prod1cop1(up)
System blaze(active) Tables: OOS 0, standby 0, unrecoverable 0, interrupted 0, restore 0, read-only 0, active 0
Dispatcher status: region2_dsp_prod2(active) - up, region1_dsp_prod2(standby) – up
Gateway status: prod2 - prod2cop1(up)
Alerts: 0 critical, 1 warning, 1 normal

This table explains the output.

Output	Description	Status
Sequencers	Name of Sequencer Current state (in parentheses) Name of associated Repository State of associated Repository (in parentheses)	When Unity is functioning properly, one Sequencer (region1_seq-fastcop1) and its Repository (flash) should be in the Active state. The second Sequencer (region2_seq-bltorcop1) and its Repository (blaze) should be in the standby state (the sub-state can be synchronizing, syncing, synced or synchronized). For more information, see SEQUENCER STATUS or REPOSITORY INFO.
Endpoints	Name of Endpoint List of all IP addresses (or the special keyword "any") where the Endpoint is configured for listening Current state (listening, not listening, etc.) for each IP address Associated port for each IP address	All Endpoints (region1_ept, region2_ept) should be connected. Each IP address should be in the proper listening/not listening state (10.25.1.4(not listening)). Endpoints listen on all default IP addresses, and not listen on standby IP addresses (unless requested to do so specifically by the Sequencer). If an Endpoint is not connected, "not connected" appears instead of a list of associated IP addresses.
Systems	Name of the system State (in parentheses) List of all Unity-managed table counts grouped by table state (with Out of Service state shortened to OOS)	The first list shows the flash system, which is in the unrecoverable state. There are currently no objects in the Unity dictionary, so that count of tables in each state is 0. There are two dispatchers defined. Dispatcher (region2_dsp_flash) is in Standby state, and is not connected to the Sequencer (state: down). Dispatcher (region1_dsp_flash) is the Active dispatcher, and is connected to the Sequencer (state: up). For detailed information on the system, associated gateways and dispatchers, see the SYSTEM DESCRIBE command.
Alerts	Count of critical, warning, and normal alerts open.	There should be no critical alerts, but warning alerts can show up as part of normal system operation and don't need to be cleared. Normal alerts can appear during system startup. To see all open alerts in a system, use the ALERT LIST OPEN command.

After completing installation, run the Data Dictionary scanner from the Unity Setup portlet to scan and deploy the initial dictionary. Once completed, activate one or more systems as needed, ensuring that all objects scanned and deployed across more than one system have the exact same meta data and physical data.