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

Was this page helpful? Yes No Submitting... Thank you

Comments