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 |
Comments
Log in or register to comment.