OBJECT LIST Command | unityadmin | Teradata Unity - 17.00 - OBJECT LIST - Continuous Availability - Teradata Unity

Teradata® Unity™ User Guide

Product
Continuous Availability
Teradata Unity
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2020-09-15
dita:mapPath
fmz1594836948704.ditamap
dita:ditavalPath
qqk1595871525984.ditaval

Purpose

Lists all Unity-managed table objects in the state you specify.

Syntax

OBJECT LIST [state] [,state,...] [ON tdpid [,tdpid,...]] ;

Parameters

The following states are available:

ACTIVE
Lists table objects in Active state.
INTERRUPTED
Lists table objects in Interrupted state.
OOS
Lists table objects in Out of Service state.
READONLY
Lists table objects in Read Only state.
RESTORE
Lists table objects in Restore state.
STANDBY
Lists table objects in Standby state.
UNRECOVERABLE
Lists table objects in Unrecoverable state.
tdpid
Unique identifier of the Teradata Database system.

Example

The following example lists table objects in the Active state on the Teradata Database systems named TDsysA and TDsysB.

unityadmin>  OBJECT LIST ACTIVE; 
State of orders.customers on preferred system 1 (TDsysA) active
State of orders.customers on system 2 (TDsysB) active
State of orders.employee on preferred system 1 (TDsysA) active
State of orders.employee on system 2 (TDsysB) active
State of orders.location on system 1 (TDsysA) active
State of orders.location on system 2 (TDsysB) active
The word 'preferred' only appears on an output line that shows the preferred system for the table. Tables that do not have a preferred system, as in the orders.location output in this example, do not have the 'preferred' specification.