Purpose
Ends one or more session pools in an orderly manner.
Syntax
where:
- poolid
- Unique identifier of the pool that is to be stopped.
- ALL
- Requests that all pools be stopped.
Usage Notes
The STOP POOL command does the following:
- Disables logons to the pool(s) that are to be stopped.
- Logs off pool sessions that are not in use.
- Waits for any pool session that is in use to run until the application logs off. The session is then logged off from the Teradata Database. When all pool sessions are logged off, the pool is removed.
To terminate existing pool sessions without waiting for them to finish and disable the pools (but not eliminate them), use the LOGOFF POOL command.
Example 1: STOP POOL
STO POOL ID: ACTR04
Example 2: STOP POOL
STO POOL ALL
Completion Messages
When the STOP POOL command is accepted for processing by TDP, the following message is displayed:
TDP0867 STOPPING POOL ID poolid
When the STOP POOL command has been processed, the following message is displayed:
POOL ID: poolid IS NOW STOPPED