DB2RESP variables
This section describes the DB2RESP variables.
Table 1. DB2RESP variables in hilevel.UBBPROC
Variable name | Description | Default | Data set member |
|---|---|---|---|
MAX_TSOELAP | maximum elapsed time per TSO user | 00:01:00 (1 minute) | DSU101C |
MAX_TSOSTMT | maximum number of SQL statements issued per TSO user | 500 | DSU101C |
MAX_TSOLOCK | maximum number of LOCKS held per TSO user | 500 | DSU101C |
MAX_BATELAP | maximum elapsed time per BATCH transaction | 01:00:00 (1 hour) | DSU101C |
MAX_BATSTMT | maximum number of SQL statements issued per BATCH transaction | 100,000 | DSU101C |
MAX_BATLOCK | maximum number of LOCKs held per BATCH transaction | 2,000 | DSU101C |
MAX_UTLELAP | maximum elapsed time per UTILITY transaction | 00:30:00 (30 minutes) | DSU101C |
MAX_UTLSTMT | maximum number of SQL statements issued per UTILITY transaction | 0 | DSU101C |
MAX_UTLLOCK | maximum number of LOCKs held per UTILITY transaction | 50 | DSU101C |
MAX_CAFELAP | maximum elapsed time per CAF transaction | 00:30:00 (30 minutes) | DSU101C |
MAX_CAFSTMT | maximum number of SQL statements issued per CAF transaction | 100,000 | DSU101C |
MAX_CAFLOCK | maximum number of LOCKs held per CAF transaction | 2,000 | DSU101C |
MAX_TPELAP | maximum elapsed time per CICS or IMS transaction | 00:00:05 (5 seconds) | DSU101C |
MAX_TPSTMT | maximum number of SQL statements issued per CICS or IMS transaction | 100 | DSU101C |
MAX_TPLOCK | maximum number of LOCKs held per CICS or IMS transaction | 100 | DSU101C |
MAX_EDMFAILS | maximum number of EDM pool failures per minute | 0 | DSU101C |
MAX_EDMLOADS | maximum percent of EDM pool requests needing loads | 20% | DSU101C |
MAXBFR_UNAVAIL | maximum number of buffer unavailable conditions per minute | 0 | DSU101C |
MAXALLOC_DELAY | maximum number of allocation delay conditions per minute | 0 | DSU101C |
MAX_RIDUT | maximum RID pool percent utilization | 80% | DSU101C |
MAX_BFREXP | maximum number of buffer pool expansions per minute | 0 | DSU101C |
MAX_BFRDMC | maximum number of Data Manager Critical conditions per minute | 0 | DSU101C |
MAX_BFRIW | maximum number of Immediate Write conditions per minute | 0 | DSU101C |
MIN_GETRIO | minimum number of GETPAGES per read I/O in the INTVL | 2.0 | DSU101C |
MIN_SWSPWS | minimum number of system page updates per system pages written in the INTVL | 1.0 | DSU101C |
MIN_PWSWIO | minimum number of system pages written per write I/O in the INTVL | 5.0 | DSU101C |
RESP_MIN | number of minutes between monitor warning messages before triggering the EXEC again if necessary | 1 | DSU101C |
MAX_SUSPCT | percent suspended threads (total active threads divided by total suspended threads) | 25% | DSU101C |
MAX_THDUTL | thread utilization (total active threads divided by maximum threads allowed) | 90% | DSU101C |
MAX_#SUSP | maximum suspensions per active thread per minute (suspensions per minute divided by number of active threads) | 1 | DSU101C |
MAX_#DEAD | maximum deadlocks per minute in the interval | 0 | DSU101C |
MAX_#TIMEOUT | maximum timeouts per minute in the interval | 0 | DSU101C |
MAX_PAGEPCT | maximum DB2 paging as a percent of total system (DB2 paging divided by total system paging) | 10% | DSU101C |
MAX_EDMUT | maximum EDM pool utilization | 80% | DSU101C |
MAX_OPENPCT | maximum open data set utilization | 90% | DSU101C |