Dynamic Routing Rule Changes Using Query Band Requests | Teradata Business Continuity Manager - Dynamic Routing Rule Changes Using Query Band Requests - 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

You can use a query band statement to change the routing rule of a session dynamically. The query band rule makes sure that particular reporting or load processes use a specific routing rule.

If the client application is already using the routing rule, then the query band has no effect. If the client specifies a new routing rule, it disconnects the Business Continuity Manager sessions and reconnects using the specified routing rule.

The following example demonstrates a report that is intended to run only on the first DB1 system, using the DB1_Only routing rule.
SET QUERY_BAND = 'BCMROUTING=DB1_Only;’ For Session;