IFCID 106 - Stored Procedures Parameters

This topic shows detailed information about Record Trace - IFCID 106 - Stored Procedures Parameters.

Record trace - IFCID 106 - Stored Procedures Parameters

The field labels shown in the following sample layout of Record Trace - IFCID 106 - Stored Procedures Parameters are described in the following section.


STORED PROCEDURES PARAMETERS
MVS PROCEDURE NAME: 'BLANK'     ALLOWABLE ABENDS:          0    TIMEOUT VALUE:        180

MVS PROCEDURE NAME

The name of the MVS JCL procedure used to start the Db2 stored procedures address space.

Install parameter Db2 PROC NAME on panel DSNTIPX, or ZPARM STORPROC in DSN6SYSP.

Field Name: QWP1SPPN

ALLOWABLE ABENDS

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

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