16.10 - SYSTEM LIST STATES - 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

Provides state information for the specified object and all child objects.

Syntax

SYSTEM LIST STATES {tdpid[,tdpid, ...]} | {database.tablename [ON tdpid[, tdpid, ...]]};

Parameters

database.tablename
Name of a database and table currently in the Unity Data Dictionary. The table name that you specify must be fully qualified.
tdpid
Unique identifier (TDPID) of a Teradata Database system.

Usage Considerations

Lists table states on one or more specific Teradata Database systems.

Examples

The following example shows the state of a Teradata Database called sdll3776 with a portion of the output.

unityadmin>  SYSTEM LIST STATES sdll3776; 
State of b00323a_usr0.j2:
  State of b00323a_usr0.j2 on system 2 (sdll3776): active
State of b00323a_usr0.j3:
  State of b00323a_usr0.j3 on system 2 (sdll3776): active
State of b00324a_usr0.t1:
  State of b00324a_usr0.t1 on system 2 (sdll3776): active
State of b00325a_usr0.tbl:
  State of b00325a_usr0.tbl on system 2 (sdll3776): active
...

The following example shows the state of a table called b00383a_usr0.billings on the Teradata Database systems called sdll3754 and sdll3776.

unityadmin>  SYSTEM LIST STATES b00383a_usr0.billings ON sdll3754,sdll3776; 
State of b00383a_usr0.billings:
  State on system 1 (sdll3754): active
  State on system 2 (sdll3776): active