STOP POOL - Teradata Director Program

Teradata® Director Program Reference

Product
Teradata Director Program
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-18
dita:mapPath
pxm1544831938750.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2416
lifecycle
previous
Product Category
Teradata Tools and Utilities

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 pools 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 database. When all pool sessions are logged off, the pool is removed.

Use the LOGOFF POOL command to terminate existing pool sessions without waiting for them to finish and disable the pools (but not eliminate them).

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