XMLVALA—XML user storage limit

Use the Modify User XML Storage Limit panel or the XMLVALA command to specify the maximum number of kilobytes of storage that each user is allowed for storing XML values

Important

This installation parameter applies only to Db2 Version 9.1 and subsequent releases.

Modify User XML Storage Limit panel

DDTAMRA Modify User XML Storage Limit
Command ===> _________________________________________________________________

  Command: CURRENT
Description . . . . . . . . : XML USER STORAGE LIMIT

Type the new User XML storage limit that you wish to change to. Then press Enter.

User XML Storage Limit
Storage Limit . . . . . . . ________ (1-2097152 or delta) Kilobytes

Command syntax and parameters

image2018-12-25_13-33-35.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

The XML user storage limit (the maximum number of kilobytes of storage that each user is allowed to use for storing XML values). Specify one of the following values:

  • A numerical value in the range 1–2097152
  • 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–2097152.

The Db2 default is 204800 KB.

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

Storage Limit

DSNTIPD

XMLVALA

DSN6SYSP

XMLVALA

 

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