DDF monitors
Monitor | Title | View name | Description, Parameters, Warning |
|---|---|---|---|
CNVLM | Conversations Deallocated–ZPARM Limit | DCNVLM | Reports the number of conversations that are deallocated because the ZPARM limit was reached for maximum concurrent threads during a sampling interval (QDSTQCRT) Parameters: none Example DS1160W (nn) hh:mm:ss CONV DEALLOC Zparm LIMIT(parm) = v IN x intrvl (>thrshld) |
DBATQ | Inactive (Type 2)/New Connections Queued | DDBATQ | Reports the current number of inactive (Type 2) or new connections that are queued and waiting to be serviced by a DBAT (QDSTNQR2). Parameters: none Example DS1660W (nn) hh:mm:ss CUR TYP2/NEW CONN QUEUED(TOTAL) = value (>thrshld) |
DBTQD | Database Thread Queued | DDBTQD | Reports the number of times a database access thread was queued because the number of concurrent remote threads was already at a maximum (QDSTQDBT) Parameters: none Example DS0650W (nn) hh:mm:ss DATABASE THREAD QUEUED(TOTAL) = v IN x intrvl (>thrshld) |
DBTUT | DBAT % Utilization | DDBTUT | Reports the percentage of DBATs from the total allowable during the sampling period Allowable DBATs are defined in member MAXDBAT of the DSNZPARM data set. Parameters: none Example DS1680W (nn) hh:mm:ss DBAT % UTILIZATION(TOTAL) = v (>thrshld) |
DDFBR | DDF Bytes Received | DDDFBR | Reports the total bytes received at the monitor target location from all remote locations or from specified locations during the sampling period Parameters: [location name] Example DS0750W (nn) hh:mm:ss DDF BYTES RECEIVED(parm) = v IN x intrvl (>thrshld) |
DDFBS | DDF Bytes Sent | DDDFBS | Reports the total bytes sent from the monitor target to all remote locations or to specified locations during the sampling period Parameters: [location name] Example DS0740W (nn) hh:mm:ss DDF BYTES SENT(parm) = v IN x intrvl (>thrshld) |
DDFCQ | DDF Conversations Queued | DDDFCQ | Reports the number of queued conversations because the session limit has been reached for all LUs or for specified LUs during a sampling interval Parameters: [lu name] Example DS0760W (nn) hh:mm:ss DDF CONVS QUEUED(parm) = v (>thrshld) |
DDFT1 | Connections Terminated–Maximum Type 1 | DDDFT1 | Reports the number of connections that were terminated instead of made type 1 inactive because the maximum number of type 1 inactive threads was reached during the sampling period (QDSTNITC) Parameters: none Example DS1650W (nn) hh:mm:ss CONNECT TERM-MAX TYPE1(TOTAL) = v IN x intrvl (>thrshld) |
NACT2 | Current Inactive Type 2 DB Threads | DNACT2 | Reports the number of inactive Type 2 database access threads during a sampling period (QDSTCIN2) Parameters: none Example DS1190W (nn) hh:mm:ss CURRENT INACT TYPE2 CONNS = value (>thrshld) |
NACTC | Current Inactive Type 1 DB Threads | DNACTC | Reports the number of inactive Type 1 database access threads during a sampling period (QDSTQCIT) Parameters: none Example DS1170W (nn) hh:mm:ss CURRENT INACT TYP1 DBATS(parm) = v IN x intrvl (>thrshld) |
P2CON | 2-Phase Connections | DP2CON | Reports the number of connections with two-phase commit operations (QDSTQCIT + QDSTWSTR), cold started connections (QDSTCSTR), and warm started connections (QDSTWSTR) during a sampling interval Parameters: [COLD|WARM] Example DS1180W (nn) hh:mm:ss 2-PHASE CONNECTIONS(parm) = v IN x intrvl (>thrshld) |
P2RMC | Remote Location Coordinator COMMITS | DP2RMC | Reports the number of COMMIT operations that have the specified location as the coordinator or for all remote locations during the specified time interval (QLSTCPTR) Parameters: [location name] Example DS1250W (nn) hh:mm:ss REMOTE COORDNTR COMMITS(parm) = v IN x intrvl (>thrshld) |
P2RMI | Remote Location Coordinator INDOUBTS | DP2RMI | Reports the number of threads that became in-doubt that have the remote location as the coordinator or for all remote locations during the specified time interval (QLSTINDT) Parameters: [location name] Example DS1240W (nn) hh:mm:ss REMOTE COORDNTR INDOUBTS(parm) = v IN x intrvl (>thrshld) |
P2RMR | Remote Location Coordinator ROLLBACKs | DP2RMR | Reports the number of ROLLBACK operations that have the specified locations as the coordinator or for all remote locations during the specified time interval (QLSTRBTR) Parameters: [location name] Example DS1260W (nn) hh:mm:ss REMOTE COORDNTR ROLLBKS(parm) = v IN x intrvl (>thrshld) |
P2RMT | Remote Location Coordinator Total Operations | DP2RMT | Reports the number of operations that have the remote location as the coordinator or for all remote locations during the specified time interval (QLSTINDT + QLSTCPTR + QLSTRBTR) Parameters: [location name] Example DS1230W (nn) hh:mm:ss REMOTE COORDNTR TOTAL(parm) = v IN x intrvl (>thrshld) |
P2RSY | 2-Phase Resync Connections | DP2RSY | Reports the number of resynchronization connections attempted with all remote locations for two-phase commit operations (QDSTRSAT), successful attempts (QDSTRSSU), and unsuccessful attempts (QDSTRSAT - QDSTRSSU) during a sampling period Parameters: [FAIL|SUCCESS] Example DS1200W (nn) hh:mm:ss 2-PHASE RESYNC CONNECTS(parm) = v IN x intrvl (>thrshld) |
RMTUT | Remote Connection % Utilization | DRMTUT | Reports the number of remote connections as a percent of the CONDBAT maximum in DSNZPARM Parameters: none Example DS1210W (nn) hh:mm:ss REMOTE CONNECTION &S+UTIL (TOTAL) = value (>thrshld) |
RSQLR | Remote SQL Statements Received | DRSQLR | Reports the number of SQL statements received from a remote site to be executed locally on behalf of a remote user (QLSTSQLR) If the RSQLR monitor is started without parameters (blank), the reported number is the sum of SQL statements received from all remote sites. Parameters: [location name] Example DS0670W (nn) hh:mm:ss REMOTE SQL RECEIVED(parm) = v IN x intrvl (>thrshld) |
RSQLS | Remote SQL Statements Sent | DRSQLS | Reports the number of SQL statements sent to a remote site to be executed on behalf of a user at a local site (QLSTSQLS) If the RSQLS monitor is started without parameters (blank), the reported number is the sum of SQL statements sent to all remote sites. Parameters: [location name] Example DS0660W (nn) hh:mm:ss REMOTE SQL SENT(parm) = v IN x intrvl (>thrshld) |
Comments
Log in or register to comment.