Skip to Content

MAXTEMPS - Maximum temporary space

Use the Modify Maximum Temporary Space panel or the MAXTEMPS command to specify the maximum number of megabytes of temporary storage in the work file database that can be used by a single agent at any given time for all temporary tables.

Modify Maximum Temporary Spcae panel

DDTAMTP D Modify Maximum Temprary Space
Command ===> _________________________________________________________________

 Command: CURRENT
Description . . . . . . . : MAXIMUM TEMPORARY SPACE

Type the new Maximum Temporary Space value you wish to change. Then press Enter.

Max Temp Space
Number of megabytes. . . . : ___________ (0-2147483647 or delta)

Command syntax and parameters

image2018-12-24_10-6-32.png

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).

value

Maximum number of megabytes of temporary storage in the work file database that can be used by a single agent at any given time for all temporary tables. Specify one of the following values:

  • 0—no limit is enforced
  • A numerical value in the range 1– 2147483647
  • 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– 2147483647.

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 temp space

DSNTIP9

MAXTEMPS

DSN6SPRM

MAXTEMPS

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

OPERTUNE for DB2 13.1