STORTIME—Stored procedure timeout value

Use the Modify Stored Procedure Timeout panel (Figure 158) or the STORTIME command to specify the number of seconds that Db2 waits before timing out an SQL CALL waiting for a stored procedure. Specifying 0 for this element instructs Db2 to avoid timing out callers of stored procedures.

Modify Stored Procedure Timeout panel

DDTG DBI1 Modify Stored Procedure Timeout
Command ===> _________________________________________________________________

  Command: CURRENT
Description . . . . . . . . : STORED PROCEDURE TIMEOUT VALUE

Type the new stored procedure timeout value that you wish to change to. Then press Enter.

Stored Procedure Parameter
Timeout value . . . . . . . _____ (0,5-1800 or delta)

Command syntax and parameters

image2018-12-25_11-7-27.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 number of seconds that Db2 waits before timing out an SQL CALL waiting for a stored procedure. Specify one of the following values:

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

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

Timeout value

DSNTIPX

STORTIME

DSN6SYSP

STORTIME

 

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