Purpose
For sessions associated with a managed routing rule, this command changes the Teradata system for the session routing rule to another system by specifying the system TDPID.
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 database system.
Usage Considerations
On sessions tagged for move, the move only occurs on the subsequent request. The audit log tracks session changes.
Examples
At the bcmadmin prompt:
| Input | Description |
|---|---|
| SESSION MOVE 1001 TO sys2; | Demonstrates how to force a move of session 1001 to system sys2. |
| SESSION MOVE prefReadOnly TO sys2; | Demonstrates how to force a move of all sessions using the prefReadOnly routing rule to system sys2. |