16.10 - OBJECT LIST - Teradata Unity

Teradata Unity User Guide

Product
Teradata Unity
Release Number
16.10
Published
January 2018
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
anz1496162519675.ditamap
dita:ditavalPath
ft:empty

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.