Troubleshooting › SQL Statements are Consuming Excess CPU Time

SQL Statements are Consuming Excess CPU Time

Symptom:

SQL statements are consuming excess CPU time.

Solution:

Use the Resource Limit Facility (RLF) to prevent SQL statements from consuming excess CPU time. We recommend that you add a row to the RLF to limit the resources that are consumed from DBA Command Manager for DB2 module. To accomplish this task, use the following parameters:

AUTHID=(blank)

Applies to all authorization IDs.

RLFFUNC=2

Governs dynamic SELECT, INSERT, UPDATE, MERGE, TRUNCATE, or DELETE statements reactively by package or collection name.

ASUTIME=15000

Specifies a value to help control excessive CPU time.

Note: For more information about setting this parameter, see the IBM MVS Initialization and Tuning Guide.

RLFCOLLN=(blank)

Applies to all package collections.

RLFPKG=’package-name’

Specifies a package name. Use BPAFE08 for versions of DB2 before DB2 9 NFM or BPAFE09 for DB2 9 NFM and later.

Note: Use other parameter settings depending on installation requirements. For more information about these options, see the IBM DB2 Performance Monitoring and Tuning Guide.