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