OBJECT HALT Command | unityadmin | Teradata Unity - 17.00 - OBJECT HALT - Continuous Availability - Teradata Unity

Teradata® Unity™ User Guide

Product
Continuous Availability
Teradata Unity
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2020-09-15
dita:mapPath
fmz1594836948704.ditamap
dita:ditavalPath
qqk1595871525984.ditaval

Purpose

Changes state of a table object to the Out-of-Service state. The table must be managed by Unity.

Syntax

OBJECT HALT {tablename [ON tdpid [, tdpid, ...]]} [ REASON reason];

Parameters

ON
Change a table on a specific Teradata Database system.
tdpid
Unique identifier (TDPID) of a Teradata Database system.
REASON reason
User description of why the object is having its state changed.
tablename
The fully qualified table name if you are attempting to change the state of a table.

Usage Considerations

Restricts an object state change to an object on a specific Teradata Database system. If making a state change for an object on all the Teradata Database systems then the object has the same data across all Teradata Database systems when this operation completes.

When running this command, Teradata Unity holds any new transactions/statements until all in-flight transactions close for the object. RecoveryCheckpointTimeout determines the duration of wait time. If in-flight transactions are not closed within this time limit, the operation aborts. An error displays, and the state returns to its state prior to the attempt.

If a multi-object Write runs, and an object is in Out of Service or Interrupted state, then all associated objects in the Write automatically become Out of Service or Interrupted.

Example

The following example demonstrates placing an object t4_cp from a Teradata Database cp_tpp004u in Out-of-Service state on the Teradata Database system cricket.

unityadmin>  OBJECT HALT cp_tpp004u.t4_cp ON cricket;