SESSION MOVE Command | unityadmin | Teradata Unity - 17.00 - SESSION MOVE - 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 sessions associated with a managed routing rule, this command changes the Teradata system for the Preferred session routing rule to another system by specifying the TDPID of that system.

For sessions associated with passive routing rules, this command moves the sessions from the current system to the one specified. The TDPID specified must be part of the routing rule associated with the session.

Syntax

SESSION MOVE {sessionid | routing} TO tdpid ;

Parameters

sessionid
Unique session identifier (ID).
routing
Unique routing rule identifier.
tdpid
Unique identifier (TDPID) of a Teradata Database system.

Usage Considerations

On sessions tagged for move, the move only occurs on the next request. The audit log tracks session changes.

Examples

At the unityadmin prompt:

Input Description
SESSION MOVE 1001 TO sys2; The example demonstrates how to force a move of session 1001 to system sys2.
SESSION MOVE prefReadOnly TO sys2; The example demonstrates how to force a move of all sessions using the prefReadOnly routing rule to system sys2.