16.10 - OBJECT HALT - 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

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;