Sizes Panel 1 (DSNTIPD)

This topic shows detailed information about "System Parameters - Sizes Panel 1 (DSNTIPD)".

System Parameters - Sizes Panel 1 (DSNTIPD)

The field labels shown in the following sample layout of "System Parameters - Sizes Panel 1 (DSNTIPD)" are described in the following section.

SIZES PANEL 1 (DSNTIPD)                                        
-----------------------                                        
LOB INLINE LENGTH (LOB_INLINE_LENGTH).........................0
USER LOB VALUE STORAGE IN KB (LOBVALA)..................200,000
SYSTEM LOB VALUE STORAGE IN MB (LOBVALS).................16,384
USER XML VALUE STG IN KB (XMLVALA)......................204,800
SYSTEM XML VAL STG IN MB (XMLVALS).......................10,240

LOB INLINE LENGTH (LOB_INLINE_LENGTH)

Default inline length for any new storing large object (LOB) column in a Universal Table Space on the DB2 subsystem. The valid values are from 0 to 32680 inclusive (in bytes). The default value for this ZPARM is 0, which indicates that no inline attribute is desired for any LOB column (BLOB, CLOB or DBCLOB) created on this subsystem.

Field Name: QWP1LBIL

USER LOB VALUE STORAGE IN KB (LOBVALA)

The maximum amount of storage (KB) each user can use for LOB values.

Install parameter USER LOB VALUE STORAGE on panel DSNTIP7, or ZPARM LOBVALA in DSN6SYSP.

Field Name: QWP1LVA

SYSTEM LOB VALUE STORAGE IN MB (LOBVALS)

The maximum amount of storage (MB) each system can use for LOB values.

Install parameter SYSTEM LOB VALUE STORAGE on panel DSNTIP7, or ZPARM LOBVALS in DSN6SYSP.

Field Name: QWP1LVS

MAXIMUM NUMBER OF LE TOKENS (LEMAX)

The maximum number of LE tokens active at any time. When zero, no tokens are available.

A token is used each time one of the following is used: trigonometry functions, degrees, radians, rand, exp, power, log functions, upper, lower, translate.

Install parameter MAXIMUM LE TOKENS on panel DSNTIP7, or ZPARM LEMAX in DSN6SPRM.

Field Name: QWP4LEM

USER XML VALUE STG IN KB (XMLVALA)

The maximum amount of memory in kilobytes (KB) for each user for storing XML values.

ZPARM XMLVALA in DSN6SYSP.

Field Name: QWP1XVA

SYSTEM XML VAL STG IN MB (XMLVALS)

The maximum amount of memory in megabytes (MB) for each system for storing XML values.

ZPARM XMLVALS in DSN6SYSP.

Field Name: QWP1XVS

Feedback