LOGOFF 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 a pool immediately by forcing the logoff of pool sessions that are in use by application programs.

Syntax



where:

poolid
Unique identifier of the pool that is to be logged off.
ALL
Requests that all pools be logged off.

Usage Notes

The LOGOFF POOL command affects only pool sessions that are being used by applications. The LOGOFF POOL command terminates any pool sessions that are in use and disables their associated pools. The pools still exist, but they are disabled.

To use the pools again, use the ENABLE POOL command.

To completely eliminate existing pools in an orderly manner, use the STOP POOL command.

Example 1: LOGOFF POOL

LOGOFF POOL ID ACTR04

Example 2: LOGOFF POOL

LOGOFF POOL ALL

Completion Messages

When LOGOFF POOL . . . This message is displayed . . .
begins processing TDP0877 LOGOFF POOL INITIATED FOR POOL ID: poolid
finishes processing TDP0878 POOL ID: poolid STOPPING