The range of data transmissions between the DB2 Connect™ gateway and the
host that
was used to process this DCS statement. (One data transmission consists
of either one send or one receive.)
Table 1. Snapshot
Monitoring Information| Snapshot Level |
Logical Data Grouping |
Monitor
Switch |
|---|
| DCS Statement |
dcs_stmt |
Statement |
- Usage
- Use
this element to get a better understanding of the reasons
why a particular statement took longer to execute. For example, a
query returning a large result set may need many data transmissions
to complete.
The constants representing the ranges of transmissions
are described as follows and are defined in sqlmon.h.
| API Constant |
Description |
|---|
| SQLM_DCS_TRANS_GROUP_2 |
2 transmissions |
| SQLM_DCS_TRANS_GROUP_3TO7 |
3 to 7 transmissions |
| SQLM_DCS_TRANS_GROUP_8TO15 |
8
to 15 transmissions |
| SQLM_DCS_TRANS_GROUP_16TO64 |
16 to 64 transmissions |
| SQLM_DCS_TRANS_GROUP_GT64 |
Greater
than 64 transmissions |
DB2 Version 9.7 for Linux, UNIX, and Windows