Purpose
Set the override level for the determinism of an object.
Syntax
OBJECT SET DETERMINISM <object_name> [NO OVERRIDE | FORCE DETERMINISTIC | FORCE NONDETERMINISTIC]Parameters
- FORCE DETERMINISTIC
- Treats an object as deterministic
- FORCE NONDETERMINISTIC
- Treats an object as nondeterministic
- NO OVERRIDE
- Allows Business Continuity Manager to decide the object determinism
- objectname
- Fully qualified name of the target object
Example
At the bcmadmin prompt:
Input | Result |
---|---|
OBJECT SET DETERMINISM databasename.objectname FORCE NONDETERMINISTIC; | Forces Business Continuity Manager to use CDM replication for SQL statements which
|
OBJECT SET DETERMINISM databasename.objectname FORCE DETERMINISTIC; | Forces Business Continuity Manager to not use CDM replication due to the named object being referenced in the SQL statement. This does not guarantee that the SQL statement will not result in CDM replication due to the determinism level of other objects referenced within the same SQL statement. |
OBJECT SET DETERMINISM databasename.objectname NO OVERRIDE; | Allows Business Continuity Manager to decide which replication type to use in regard to the named object being referenced within a SQL statement. |