MODIFY POOL - Teradata Director Program

Teradata® Director Program Reference - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Director Program
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-11-17
dita:mapPath
cki1641301536147.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
frc1470439950465
Product Category
Teradata Tools and Utilities

Purpose

Increases or decreases the number of sessions in a pool.

Syntax



where:

poolid
Unique identifier of the pool that is to be modified.
number
Modified number of sessions desired for the pool.

Usage Notes

The MODIFY POOL command can be used to supplement the number of sessions in a pool that was originally unable to acquire the desired number of sessions because there was insufficient session capacity.

When supplementing the number of pool sessions, the MODIFY POOL command is entered after system session load has been reduced.

If the modified number of sessions is equal to the current number of sessions in the pool, then the command is rejected with an error message.

Example: MODIFY POOL

MODIFY POOL ID ACTR04 NUM 30

Completion Messages

When MODIFY POOL is executed to . . . The resulting message is . . .
increase the number of sessions in a pool TDP0866 ADDING number SESSIONS TO POOL ID: poolid
decrease the number of sessions in a pool TDP0879 REMOVING number SESSIONS FROM POOL ID: poolid