OBJECT SET DETERMINISM Command | bcmadmin | Teradata Business Continuity Manager - OBJECT SET DETERMINISM - Teradata Business Continuity Manager

Teradata® Business Continuity Manager User Guide - 2.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Teradata Business Continuity Manager
Release Number
2.00
Published
August 2024
ft:locale
en-US
ft:lastEdition
2025-01-31
dita:mapPath
sko1694443904278.ditamap
dita:ditavalPath
ft:empty
dita:id
otc1639627713801
lifecycle
latest
Product Category
Analytical Ecosystem

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
  • Perform a write
  • Reference the named object
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.