Routine Parameters (DSNTIPX)

This topic shows detailed information about "System Parameters - Routine Parameters (DSNTIPX)".

This block shows information about the stored procedures address space used to run stored procedures or user-defined functions.

Note: The fields shown on this panel depend on the installed DB2 version.

System Parameters - Routine Parameters (DSNTIPX)

The field labels shown in the following sample layout of "System Parameters - Routine Parameters (DSNTIPX)" are described in the following section.

 
ROUTINE PARAMETERS (DSNTIPX)                                   
----------------------------                                   
MAX ABEND COUNT (STORMXAB)....................................0
TIMEOUT VALUE (STORTIME)....................................180
WLM ENVIRONMENT (WLMENV)...............................DBPGD800
MAX OPEN CURSORS (MAX_NUM_CUR)..............................500
MAX STORED PROCS (MAX_ST_PROC)............................2,000
MAXIMUM NUMBER OF LE TOKENS (LEMAX)..........................20
BIF COMPATIBILITY (BIF_COMPATIBILITY)........V9_DECIMAL_VARCHAR

MAX ABEND COUNT (STORMXAB)

The number of times a stored procedure is allowed to terminate abnormally, after which SQL CALL statements for the stored procedure are rejected.

Install parameter MAX ABEND COUNT on panel DSNTIPX, or ZPARM STORMXAB in DSN6SYSP.

Field Name: QWP1SPAB

TIMEOUT VALUE (STORTIME)

The number of seconds before DB2 stops waiting for an SQL CALL statement to be assigned to one of the TCBs in the DB2 stored procedures address space.

Install parameter TIMEOUT VALUE on panel DSNTIPX, or ZPARM STORTIME in DSN6SYSP.

Field Name: QWP1SPTO

WLM ENVIRONMENT (WLMENV)

Workload manager environment.

Install parameter WLM ENVIRONMENT on panel DSNTIPX, or ZPARM WLMENV in DSN6SYSP.

Field Name: QWP1WLME

MAX OPEN CURSORS (MAX_NUM_CUR)

Shows the maximum number of cursors, including allocated cursors, that are open at a given DB2 site per thread. RDS keeps a total of currently open cursors. If an application attempts to open a thread after the maximum is reached, the statement will fail.

In a data sharing group, this parameter is shown at member scope.

Install parameter MAX OPEN CURSORS on panel DSNTIPX, or ZPARM MAX_NUM_CUR in DSN6SPRM.

Field Name: QWP4MXNC

MAX STORED PROCS (MAX_ST_PROC)

Shows the maximum number of stored procedures per thread. If an application attempts to call a stored procedure after this is reached, the statement will fail. In a data sharing group, this parameter is shown as member scope.

Install parameter MAX STORED PROCS on panel DSNTIPX, or ZPARM MAX_ST_PROC in DSN6SPRM.

Field Name: QWP4MXSP

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

BIF COMPATIBILITY (BIF_COMPATIBILITY)

The BIF_COMPATIBILITY subsystem parameter specifies whether the built-in functions and specifications are to return results in the DB2 10 format or revert to the pre-Version 10 format. It can have the following values: Start of change

CURRENT
V9
V9_TRIM
V9_DECIMAL_VARCHAR (default for migration)
N/P (default for new installation

Start of change This field corresponds to field BIF COMPATIBILITY on installation panel DSNTIPX. End of change

Start of change ZPARM name BIF_COMPATIBILITY in DSN6SPRM. End of change

Field Name: QWP4_BIF_COMPAT

Feedback