Purpose
Changes the state of a table object to the Read-Only state. The table must be managed by Business Continuity Manager.
Syntax
OBJECT FREEZE {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
- Specify a single table object to mark it Read-Only.
- When a Business Continuity Manager managed table object is frozen across multiple systems, the freeze process completes on each system as the table object on that system becomes current with the freeze point. After a successful operation, the data is the same on each copy of the table object across the systems on which it was frozen.
- If you are making a state change for a Business Continuity Manager managed table object, then the table object on all database systems becomes Read-Only. If you are making a state change for a Business Continuity Manager managed table object on a specific database system, only the table object on that database system becomes Read-Only.
Example
The following example demonstrates placing a table table4 from a database temporal_user in Read-Only state.
bcmadmin> OBJECT FREEZE temporal_user.table4
The request is currently processing as operation number 9.
Operation Number : 9
Operation Name : Freezing Table
User : admin
User Name : Main Administration User
Progress (%) : 100
Status : Finished (1)
Start Time : 01/14 16:35:49
Finish Time : 01/14 16:35:50
Systems:
[1] bltor - Finished (1)
[2] fast - Finished (1)
Updates:
01/14 16:35:50 [-] Info: Freezing table temporal_user.table4
01/14 16:35:50 [-] Info: Requesting mgmt R lock on 'temporal_user.table4'
01/14 16:35:50 [-] Info: Mgmt R lock on 'temporal_user.table4' granted
01/14 16:35:50 [-] Info: Releasing mgmt R lock on 'temporal_user.table4'
01/14 16:35:50 [-] Info: Successfully froze table on 2 systems
01/14 16:35:50 [-] Info: Operation finished