16.10 - SYSTEM WAIT UNTIL - 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

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.