TIMEOUT VALUE field (STORTIME subsystem parameter)
The STORTIME subsystem parameter specifies the number of seconds before Db2 is to stop waiting for an SQL CALL statement or invocation of a user-defined function. This parameter applies to user-defined functions that are to be assigned to one of the task control blocks (TCBs) in a Db2 stored procedures address space.
| Acceptable values: | 5–1800, NOLIMIT |
|---|---|
| Default: | 180 |
| Update: | option 47 on panel DSNTIPB |
| DSNZPxxx: | DSN6SYSP STORTIME |
If the time interval expires, the SQL statement fails. The default is a reasonable waiting time for most sites. You might want to choose a higher value if your system has long queues. You might want to choose a lower value if you want to minimize the waiting time for end-user requests. The NOLIMIT value means that Db2 waits indefinitely for the SQL request to complete, while the thread is active.
Recommendation: Do not select the NOLIMIT value. If the stored procedure address space is down for some reason or the user-defined function does not complete, your SQL request hangs until the request is satisfied or the thread is canceled.