DCMT VARY Commands › DCMT VARY DMCL › DCMT VARY DMCL Parameters

DCMT VARY DMCL Parameters

New Copy

Displays changes that the new DMCL will trigger on the runtime system and then optionally prompts for permission to proceed to make the changes.

DC/UCF displays the names of:

• Each area that would be quiesced, and whether it would be changed or removed
• Each file that would be de-allocated and whether it would be re-allocated or removed
• Each new area and/or file that would be made available
• Each buffer whose page size would change
• Each buffer that would be removed
• Each buffer that would be added

NOPrompt

Inhibits prompting for permission to proceed. If NOPROMPT is specified, the changes are displayed and then immediately implemented.

Validate

Displays changes that the DMCL will cause on the runtime system. DC/UCF displays the names of:

• Each area that would be quiesced, and whether it would be changed or removed
• Each file that would be de-allocated and whether it would be re-allocated or removed
• Each new area and/or file that would be made available
• Each buffer whose page size would change
• Each buffer that would be removed
• Each buffer that would be added

PRefetch ON/OFf

Enables or disables prefetch processing for the entire system. This overrides a specification about prefetch processing for a specific buffer, file, or area.

MEMORY CACHE

Indicates global options for memory cache:

LOCATION

Indicates where to allocate the storage for memory cache:

ANYWHERE

Memory cache storage is allocated from 64-bit storage; if no or not enough 64-bit storage is available, dataspace storage is acquired.

64 BIT only

Memory cache storage is allocated from 64-bit storage; if no or not enough 64-bit storage is available, memory caching fails.

STORAGE LIMIT

Controls the amount of storage used for memory caching:

OPSYS

Memory cache storage can be acquired until the operating system limit is reached. For 64-bit storage, the operating system limit is set through the MEMLIMIT parameter; for dataspace storage, the limit is optionally imposed by an operating system exit.

nnn MB, GB, TB, PB, EB

CA IDMS controls the amount of memory cache storage if the value specified is smaller than the operating system limit. nnn must be a positive value between 1 and 32767. MB, GB, TB, PB, EB indicate the unit in which nnn is expressed. The abbreviations stand for Mega Byte (2**20), Giga Byte (2**30), Tera Byte (2**40), Peta Byte (2**50), and Exa Byte (2**60).

More Information

• For more information about creating and generating the DMCL, see the Database Administration Guide.
• For more information about prefetch processing, see the Database Administration Guide.