Managing resource limit tables
You can use resource limit tables to specify resource usage limits for SQL statements.
About this task
Resource limit tables enable you to limit the amount of processor resources, in service units, that are used by the following types of SQL statements:
- SELECT
- INSERT
- UPDATE
- MERGE
- TRUNCATE
- DELETE
Resource limits apply only to dynamic SQL
statements.
Resource
limits apply to SQL statement regardless of whether they are issued locally or remotely. The resource limit facility does not control static SQL statements regardless of
whether they are issued locally or remotely, and no limits apply to primary or secondary
authorization IDs that have installation SYSADM or installation SYSOPR
authority.
The DSNTIJSG installation job contains statements that create the database, table space, tables, and indexes for the resource limit facility. You can tailor those statements to create or update the format of resource limit tables.
To create a new resource limit specification table, you must have sufficient authority to define objects in the DSNRLST database and to specify authid, which is the authorization ID specified in the value of the RLFAUTH subsystem parameter.
You can create two different types of resource limit tables, resource limit specification tables (named DSNRLSTxx) and resource limit middleware tables (named DSNRLMTxx). You can create instances of either type of table, or instances of both, depending on your specific plan for limiting resources.
If you are a system administrator, you must determine how your location intends to use the resource limit facility and create several local procedures:
- For creating and maintaining your resource limit tables
- For establishing limits for any newly written applications
- For console operators, such as switching resource limit tables every day at a certain time
Resource limit tables can reside in any database. However, because a database has some special attributes while the resource limit facility is active, it is best to create resource limit tables in their own database. Only one resource limit table can be active at any particular time, however you might create several instances of either or both types of resource limit tables and use different instances at different times.