SESSION FAILOVER Command | unityadmin | Teradata Unity - 17.00 - SESSION FAILOVER - Continuous Availability - Teradata Unity

Teradata® Unity™ User Guide

Product
Continuous Availability
Teradata Unity
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2020-09-15
dita:mapPath
fmz1594836948704.ditamap
dita:ditavalPath
qqk1595871525984.ditaval

Purpose

For managed routing sessions, the command changes the designated Teradata system for Preferred session routing rule to the next available system in the ordered list.

For passive routing sessions, the command causes the session to move from the current system to the next system, as per the ordered system list associated with the routing rule.

Syntax

SESSION FAILOVER sessionId | routing ;

Parameters

sessionid
Unique session identifier (ID).
routing
Unique routing rule identifier.

Usage Considerations

On sessions tagged for failover, the failover only occurs on the next request.

Example

At the unityadmin prompt:

Input Description
SESSION FAILOVER 1001; To force a failover of session 1001
SESSION FAILOVER prefReadOnly; To force a failover of all sessions using the prefReadOnly routing rule