STATIC SQL field (RLFERRSTC subsystem parameter)
The RLFERRSTC subsystem parameter specifies the action that Db2 takes when a problem occurs with the resource limit specification table during execution of a local, static SQL statement.
The situations that this subsystem parameter applies to are:
- An error occurs that prevents the resource limit facility from accessing the resource limit specification table.
- Db2 cannot find an applicable row in the resource limit specification table.
| Acceptable values: | NOLIMIT, NORUN, 1 to 5000000 |
|---|---|
| Default: | NOLIMIT |
| Update: | option 26 on DSNTIPB |
| Online changeable: | Yes |
| DSNZPxxx: | DSN6SYSP RLFERRSTC |
- NOLIMIT
- No limit is applied to any static SQL statement that does not correspond to a row in the resource limit table.
- NORUN
- Any static SQL statement that does not correspond to a row in the resource limit table is prevented from running.
- 1 to 5000000
- Specifies the number of service units to use as the default resource limit. If the limit is exceeded, the SQL statement is terminated.