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;