7.2 Resource Limit Facility Db2 12 for z/OS extends the Resource Limit Facility (RLF) reactive governing to support  static SQL statements, such as SELECT (cursor or singleton), INSERT, UPDATE, MERGE,  TRUNCATE, or DELETE. This new support is available from function level V12R1M100 and  must be enabled by setting the following new system parameter: RLFENABLE=ALL or STATIC  Where ALL means both dynamic and static, as shown in the following example: STATIC means static SQL only The DDL for the creation of the DSNRLMTxx table is shown in Example 7-14. Example 7-14 DDL for creating the DSNRLMT01 table CREATE TABLE DSNRLMT01 (RLFFUNC CHAR(1) NOT NULL WITH DEFAULT,  RLFEUAN VARCHAR(255) NOT NULL WITH DEFAULT,  RLFEUID VARCHAR(128) NOT NULL WITH DEFAULT,  RLFEUWN VARCHAR(255) NOT NULL WITH DEFAULT,  RLFIP CHAR(254) NOT NULL WITH DEFAULT,  ASUTIME INTEGER, RLFASUERR INTEGER, RLFASUWARN INTEGER, RLF_CATEGORY_B CHAR(1) NOT NULL WITH DEFAULT) For reactive governing using the DSNRLMT01 table (Example 7-14), RLFFUNC=B means  that the row reactively governs static SQL statements by using client information (RLFEUID,  RLFEUAN, RLFEUWN, and RLFIP). The DDL for the creation of the DSNRLSTxx table is shown in Example 7-15. Example 7-15 DDL for creating the DSNRLST01 table CREATE TABLE DSNRLST01 (AUTHID VARCHAR(128) NOT NULL WITH DEFAULT,  PLANNAME CHAR( 8) NOT NULL WITH DEFAULT,  ASUTIME INTEGER, LUNAME CHAR( 8) NOT NULL WITH DEFAULT,  RLFFUNC CHAR( 1) NOT NULL WITH DEFAULT,  RLFBIND CHAR( 1) NOT NULL WITH DEFAULT,  RLFCOLLN VARCHAR(128) NOT NULL WITH DEFAULT,  RLFPKG VARCHAR(128) NOT NULL WITH DEFAULT,  RLFASUERR INTEGER, RLFASUWARN INTEGER, RLF_CATEGORY_B CHAR( 1) NOT NULL WITH DEFAULT) Consider the following points regarding Example 7-15:  GLYPH<SM590000> For reactive governing using the DSNRLST01 table (Example 7-14), RLFFUNC = A  means that the row reactively governs static SQL statements by package or collection  name.  GLYPH<SM590000> ASUTIME is used to limit the statement’s execution time. Db2 issues SQLCODE -905 if  the execution time exceeds the ASUTIME limit. Chapter 7. SQL and application enablement  215