MODIFY POOL - Teradata Director Program

Teradata® Director Program Reference

Product
Teradata Director Program
Release Number
16.20
Published
September 2019
Language
English (United States)
Last Update
2019-10-11
dita:mapPath
xuf1527114222341.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2416
lifecycle
previous
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