Managing resource limit facility tables

RLF 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

You can specify resource limits for dynamic SQL statements and static SQL statements. Resource limits apply to SQL statement regardless of whether they are issued locally or remotely. The resource limit facility does not 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.