MAXTHDS—Maximum number of threads

Use the Modify Maximum Threads panel or the MAXTHDS command to specify new values for the maximum number of threads for the different thread types. You can use these values to control the amount of work that can originate from the different environments (local, remote, TSO, batch).

If you specify an increase to the number of threads, queued or new threads are started immediately. If you specify a reduction to the number of threads below the number already active, the next request to start a thread is denied, and all active threads are terminated normally.

Modify Maximum Threads panel

DDTAMMT 1 Modify Maximum Threads
Command ===> _________________________________________________________________

Command: CURRENT
Description . . . . . . . . : MAXIMUM # OF THREADS (BY TYPE)

Type the new maximum thread values that you wish to change to. Then press Enter. Release dependent limits are checked and enforced by the target OPERTUNE system.

Maximum Thread Type Parameters
Max users . . . . . . . . . (1-2000 or delta)
Max Remote Active . . . . (0-1999 or delta)
Max TSO Connect . . . . . . (1-2000 or delta)
Max Batch Connect . . . . . (1-2000 or delta)
Max Remote Connected . . . . (0-150000 or delta)

Command syntax and parameters

Value	Description
DB2ssid	Db2 subsystem ID or the name of the Db2 data sharing group to which the command applies.
opertuneID	OPERTUNE system profile name (if OPERTUNE is running as a started task) or the batch job name (if OPERTUNE is running as a batch job).
local	Maximum number of local concurrent threads allowed. Specify one of the following values: a numerical value in the range 1–2000 a delta value Delta values are expressed numerically (+nn or -nn) or as a percentage (+nn% or -nn%). The resulting value must fall in the range 1–2000.
remote	Maximum number of concurrent active DBAT threads. Specify one of the following values: A numerical value in the range 0–1999 A delta value Delta values are expressed numerically (+nn or -nn) or as a percentage (+nn% or -nn%). The resulting value must fall in the range 0–1999.
tso	Maximum number of concurrent connections from TSO foreground. Specify one of the following values: A numerical value in the range 1–2000 A delta value Delta values are expressed numerically (+nn or -nn) or as a percentage (+nn% or -nn%). The resulting value must fall in the range 1–2000.
batch	Maximum number of concurrent connections from batch jobs and utilities. Specify one of the following values: A numerical value in the range 0–150000 A delta value Delta values are expressed numerically (+nn or -nn) or as a percentage (+nn% or -nn%). The resulting value must fall in the range 0–150000.
remoteConnected	Maximum number of concurrent remote connections supported. Specify one of the following values: A numerical value in the range 1–2000 A delta value Delta values are expressed numerically (+nn or -nn) or as a percentage (+nn% or -nn%). The resulting value must fall in the range 1–2000.
NORESET	The changes you request remain in effect until the Db2 subsystem is cycled.

Db2 parameter values

Field	Installation panel	CLIST parameter	ZPARM macro	ZPARM parameter
Max users	DSNTIPE	NUMCONCR	DSN6SYSP	CTHREAD
Max Remote Active	DSNTIPE	NUMCONRM	DSN6SYSP	MAXDBAT
Max TSO Connect	DSNTIPE	NUMCONTS	DSN6SYSP	IDFORE
Max Batch Connect	DSNTIPE	NUMCONBT	DSN6SYSP	IDBACK
Max Remote Connected	DSNTIPE	CONDBAT	DSN6SYSP	CONDBAT

MAXTHDS—Maximum number of threads

Command syntax and parameters

Db2 parameter values

On this page