DISPLAY 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

Lists information and statistics about one or more established session pools.

Syntax



The DI and DIS abbreviations are deprecated.

where:

poolid
Id of pool whose information is to be displayed.
ALL
Request that information about all pools be displayed.

Usage Notes

If an error occurs during START POOL processing (because creation of further pool sessions will cause the database or installation-defined maximum session capacity (MAXSESS) to be exceeded), you can use the DISPLAY POOL command to determine how many sessions were successfully added to the pool before the error prevented further processing. Later, if session demand is reduced, you can use the MODIFY SESSIONS command to acquire the desired number of sessions for the pool.

Example: DISPLAY POOL

D POOL ID ACTR04
D POOL ALL

Completion Message

The completion message to the DISPLAY POOL command consists of a header line, followed by one line of statistics per pool, as follows:

TDP0869   ID     REQD AVAL ALC BUSY    LOGS ERR E/D
TDP0870 FTXCLUP  0001 0001 000 0000 0000001 011 (E)

where:

Column heading . . . Contains the . . .
ID unique identifiers of the pool whose statistics are displayed.
REQD number of sessions requested for the pool in the START POOL or MODIFY POOL command.
AVAL number of sessions in the pool that are currently not in use and available to satisfy application logon requests.
ALC number of pool sessions that are currently in use by applications.
BUSY number of pool sessions that are in the process of logging on to the database.
LOGS number of application logon requests that have already been satisfied by pool sessions.
ERR number of application logon requests that have been denied owing to a lack of available pool sessions.
E/D indication of whether logons to the pool are enabled (E), or disabled (D).