REMOTE
DYNAMIC SQL field (RLFERRD subsystem parameter)
The RLFERRD subsystem
parameter specifies the default action that Db2 takes for dynamic SQL statements from remote
locations when a problem occurs with the resource limit specification table.
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.
An applicable row is one that applies to the authorization ID, collection ID, or package name, and name of the logical unit of work of the query user. This parameter applies to the distributed data facility.
| Acceptable values: | NOLIMIT, NORUN, 1–5000000 |
|---|---|
| Default: | NOLIMIT |
| Update: | option 26 on panel DSNTIPB |
| Online changeable: | Yes |
| DSNZPxxx: | DSN6FAC RLFERRD |
- 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.