HP Brocade 8/12c Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 157

Table 296, Switch_bottleneck_config, Switch_port_performance, User_defined_device_detail

Page 157 highlights

Database tables and fields E TABLE 295 USER_DEFINED_DEVICE_DETAIL (Continued) Field Definition USER_DEFINED_VALUE1 USER_DEFINED_VALUE2 USER_DEFINED_VALUE3 Format Size varchar 256 varchar 256 varchar 256 TABLE 296 SWITCH_BOTTLENECK_CONFIG Field Definition Format Size VIRTUAL_SWITCH_ID The database ID of the switch that the configuration int belongs to 'Flag indicates if bottleneck detection is enabled or BOTTLENECK_DETECT_ENA not. The default value is 0. BLED s smallint ALERTS_ENABLED Flag indicates if bottleneck detection alerts is enabled or not. The default value is 0. smallint CONGESTION_THRESHOLD Value of bottleneck detection congestion threshold in double percent. The default value is '9 0'. precision LATENCY_THRESHOLD Value of bottleneck detection latency threshold in percent. The default value is '1 0'. double precision WINDOW_ Value of bottleneck detection latency window in int millisecond. The default value is 3 0 0. QUIET_TIME Value of bottleneck detection quiet time in int millisecond. The default value is 3 0 0. CREATION_TIME Creation time of the record timestamp LAST_UPDATE_TIME Last update time of the record timestamp TABLE 297 SWITCH_PORT_PERFORMANCE Field Definition Format Size PORT_ID SWITCH_ID TX RX TX_UTILIZATION Primary key of the Switch Port. int Primary key of Virtual Switch which this port is int present The number of octets or bytes that have been transmitted by this port. One second periodic polling of the port. This value is saved and compared with the next polled value to compute net throughput. Note, for Fibre Channel, ordered sets are not included in the count double precision The number of octets or bytes that have been received by this port. One second periodic polling of the port. This value is saved and compared with the next polled value to compute net throughput. Note, for Fibre Channel, ordered sets are not included in the count double precision The computed value of TX based on speed of port double precision Brocade Network Advisor Documentation Updates 149 53-1002363-02

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119
  • 120
  • 121
  • 122
  • 123
  • 124
  • 125
  • 126
  • 127
  • 128
  • 129
  • 130
  • 131
  • 132
  • 133
  • 134
  • 135
  • 136
  • 137
  • 138
  • 139
  • 140
  • 141
  • 142
  • 143
  • 144
  • 145
  • 146
  • 147
  • 148
  • 149
  • 150
  • 151
  • 152
  • 153
  • 154
  • 155
  • 156
  • 157
  • 158
  • 159
  • 160
  • 161
  • 162
  • 163
  • 164
  • 165
  • 166
  • 167
  • 168
  • 169
  • 170
  • 171
  • 172
  • 173
  • 174
  • 175
  • 176
  • 177
  • 178
  • 179
  • 180
  • 181
  • 182
  • 183
  • 184
  • 185
  • 186
  • 187
  • 188
  • 189
  • 190
  • 191
  • 192
  • 193
  • 194
  • 195
  • 196
  • 197
  • 198
  • 199
  • 200
  • 201
  • 202
  • 203
  • 204
  • 205
  • 206
  • 207
  • 208
  • 209
  • 210
  • 211
  • 212
  • 213
  • 214
  • 215
  • 216
  • 217
  • 218
  • 219
  • 220
  • 221
  • 222
  • 223
  • 224
  • 225
  • 226
  • 227
  • 228
  • 229
  • 230
  • 231
  • 232
  • 233
  • 234
  • 235
  • 236
  • 237
  • 238
  • 239
  • 240
  • 241
  • 242
  • 243
  • 244
  • 245
  • 246
  • 247
  • 248
  • 249
  • 250
  • 251
  • 252
  • 253
  • 254
  • 255
  • 256
  • 257
  • 258
  • 259
  • 260
  • 261
  • 262
  • 263
  • 264
  • 265
  • 266
  • 267
  • 268
  • 269
  • 270
  • 271

Brocade Network Advisor Documentation Updates
149
53-1002363-02
Database tables and fields
E
USER_DEFINED_VALUE1
varchar
256
USER_DEFINED_VALUE2
varchar
256
USER_DEFINED_VALUE3
varchar
256
TABLE 296
SWITCH_BOTTLENECK_CONFIG
Field
Definition
Format
Size
VIRTUAL_SWITCH_ID
The database ID of the switch that the configuration
belongs to
int
BOTTLENECK_DETECT_ENA
BLED s
'Flag indicates if bottleneck detection is enabled or
not. The default value is 0.
smallint
ALERTS_ENABLED
Flag indicates if bottleneck detection alerts is
enabled or not. The default value is 0.
smallint
CONGESTION_THRESHOLD
Value of bottleneck detection congestion threshold in
percent. The default value is ‘9 0’.
double
precision
LATENCY_THRESHOLD
Value of bottleneck detection latency threshold in
percent. The default value is ‘1 0’.
double
precision
WINDOW_
Value of bottleneck detection latency window in
millisecond. The default value is 3 0 0.
int
QUIET_TIME
Value of bottleneck detection quiet time in
millisecond. The default value is 3 0 0.
int
CREATION_TIME
Creation time of the record
timestamp
LAST_UPDATE_TIME
Last update time of the record
timestamp
TABLE 297
SWITCH_PORT_PERFORMANCE
Field
Definition
Format
Size
PORT_ID
Primary key of the Switch Port.
int
SWITCH_ID
Primary key of Virtual Switch which this port is
present
int
TX
The number of octets or bytes that have been
transmitted by this port. One second periodic polling
of the port. This value is saved and compared with
the next polled value to compute net throughput.
Note, for Fibre Channel, ordered sets are not
included in the count
double
precision
RX
The number of octets or bytes that have been
received by this port. One second periodic polling of
the port. This value is saved and compared with the
next polled value to compute net throughput. Note,
for Fibre Channel, ordered sets are not included in
the count
double
precision
TX_UTILIZATION
The computed value of TX based on speed of port
double
precision
TABLE 295
USER_DEFINED_DEVICE_DETAIL
(Continued)
Field
Definition
Format
Size