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.