SYSTEM WAIT UNTIL - Teradata Unity

Teradata® Unity™ User Guide

Product
Teradata Unity
Release Number
16.20
Published
May 2019
Language
English (United States)
Last Update
2019-05-23
dita:mapPath
dzf1517499323110.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2520
lifecycle
previous
Product Category
Analytical Ecosystem

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.
The valid states are:
  • active
  • standby
  • read only
  • out of service
  • interrupted
  • unrecoverable
  • disconnected

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.