REMOTE STATIC SQL field (RLFERRDSTC subsystem parameter)
The RLFERRDSTC subsystem parameter specifies the action that Db2 takes for static 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.
Acceptable values: | NOLIMIT, NORUN, 1–5000000 |
---|---|
Default: | NOLIMIT |
Update: | option 26 on DSNTIPB |
Online changeable: | Yes |
DSNZPxxx: | DSN6FAC RLFERRDSTC |
- NOLIMIT
- Allows all static SQL statements from remote locations to run without limit.
- NORUN
- Terminates all static SQL statements from remote locations 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.