Purpose
Waits for the specified state to be achieved for systems or tables.
Syntax
SYSTEM WAIT UNTIL {tpdid [, tdpid, ...] | tablename ON tdpid [,, ...] } IS state [TIMEOUT seconds];Parameters
- ON tdpid [, tdpid, ...]
- Enables waiting for the table state on one or more specific Teradata Database systems.
- tablename
- Specifies the fully qualified name of a table.
- tdpid
- Unique identifier (TDPID) of a Teradata Database system.
- TIMEOUT seconds
- Specifies the timeout value, in seconds.
- IS state
- Specifies the state.
Examples
The following example causes Unity to wait for the system sys1 to achieve the Active state following system recovery.
unityadmin> SYSTEM WAIT UNTIL sys1 IS active;
Target system state has been achieved.
The following example causes Unity to wait for a table freeze to complete, and specifies a timeout in case the table freeze fails.
unityadmin> SYSTEM WAIT UNTIL myDB.myTable ON sys2 IS read only TIMEOUT 60;
E Synchronous wait has timed out.