Creating resource limit tables

You can create resource limit tables and related indexes to limit the amount of resources that are used for processing SQL statements.

About this task

You can create different types of resource limit tables, depending on context of the queries that you want to limit.

If both DSNRLMTxx and DSNRLSTxx tables exist, rows in the DSNRLMTxx table that match a statement take priority over any matching rows in the DSNRLSTxx table.

Procedure

Create the type of resource limit table and related index in the DSNRLST database. Choose the type of table according to the context of the queries that you want to govern, and how you will identify those queries:
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.
Option Description
Plan name, collection ID, package name, authorization ID, and location name:
  1. Issue the create table statement for authid.DSNRLSTxx, where xx is two alphanumeric characters that identifies the particular instance of the table.
    Important: The value of xx must be alphanumeric and cannot contain special or double-byte characters.
  2. Issue the create index statement for authid.DSNARLxx, where xx is the same two alphanumeric characters that identify the table.
Client information, including application name, user ID, workstation ID, and IP address:
  1. Issue the create table statement for authid.DSNRLMTxx, where xx is two alphanumeric characters that identifies the particular instance of the table.
    Important: The value of xx must be alphanumeric and cannot contain special or double-byte characters.
  2. Issue the create index statement for authid.DSNMRLxx, where xx is the same two alphanumeric characters that identify the table.