DYNAMIC SQL field (RLFERR subsystem parameter)
The RLFERR subsystem parameter specifies the action that Db2 takes for dynamic SQL statements that originate from the local server when it cannot find an applicable row in the resource limit specification table.
An applicable row is one that applies to the authorization ID, collection ID, package name, and name of the logical unit of work of the query user.
| Acceptable values: | NOLIMIT, NORUN, 1–5000000 |
|---|---|
| Default: | NOLIMIT |
| Update: | option 24 on panel DSNTIPB |
| Online changeable: | Yes |
| DSNZPxxx: | DSN6SYSP RLFERR |
- NOLIMIT
- Allows all dynamic SQL statements to run without limit.
- NORUN
- Terminates all dynamic SQL statements immediately with an SQL error code.
- 1–5000000
- Specifies the number of service units to use as the default resource limit. If the limit is exceeded, the SQL statement is terminated.