Purpose
Changes state of a table object to the Out of Service state. The table must be managed by Business Continuity Manager.
Syntax
OBJECT HALT {tablename [ON tdpid [, tdpid, ...]]} [ REASON reason];Parameters
- ON
- Change a table on a specific database system.
- tdpid
- Unique identifier (TDPID) of a 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 database system. If making a state change for an object on all the database systems then the object has the same data across all database systems when this operation completes.
When running this command, Business Continuity Manager 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 database cp_tpp004u in Out-of-Service state on the database system cricket.
bcmadmin> OBJECT HALT cp_tpp004u.t4_cp ON cricket;