Skip to Content

MXDTCACH—Data caching memory

Use theModify Data Caching Memory panel or the MXDTCACH command to specify the maximum number of megabytes of virtual memory allocated for data caching.

Modify Data Caching Memory panel

DDTAMCH D Modify Data Caching Memory
Command ===> _________________________________________________________________

 Command: CURRENT
Description . . . . . . . : DATA CACHING MEMORY

Type the new Data Caching Memory value you wish to change. Then press Enter.

Data Caching Memory
Number of megabytes. . . . : _____ (0-512 or delta)

Command syntax and parameters

image2018-12-24_11-40-23.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 virtual memory allocated for data caching. Specify one of the following values:

  • 0—Db2 does not use data caching
  • A numerical value in the range 1–512
  • 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–512.

The Db2 default is 20.

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

Data caching memory

DSNTIP8

MXDTCACH

DSN6SPRM

MXDTCACH

 

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

OPERTUNE for DB2 12.1