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

Table 224, Crypto_host, Crypto_lun, Collector_end_timestamp Continued

Page 122 highlights

E Database tables and fields TABLE 223 COLLECTOR_END_TIMESTAMP (Continued) Field Definition Format Size TIMESTAMP_ LAST_COLLECTED_STATUS When the last successful collection is done. timestamp Status of the last collection, successful or not. 200 is smallint for successful. Values are standard HTTP protocol values. TABLE 224 CRYPTO_HOST Field Definition Format Size ID int CRYPTO_TARGET_CONTAINE Foreign key reference to the int R_ID CRYPTO_TARGET_CONTAINER that contains this host. VI_NODE_WWN Node WWN of Virtual Initiator that represents this char 23 host. VI_PORT_WWN Port WWN of Virtual Initiator that represents this char 23 host. HOST_PORT_WWN Physical (real) host''s Port WWN char 23 HOST_NODE_WWN Physical (real) host''s Node WWN char 23 TABLE 225 CRYPTO_LUN Field Definition Format Size ID int CRYPTO_TARGET_CONTAI Foreign key reference to the CRYPTO_TARGET_CONTAINER int NER_ID that contains the host for which these LUNs are configured. SERIAL_NUMBER The LUN serial number, used to identify the physical varchar 256 LUN. ENCRYPTION_STATE Boolean. True (1) if LUN is being encrypted. False (0) smallint if cleartext.'; The default value is 0. STATUS Not currently used but left in for possible future use. smallint Replaced by LUN_STATE. The default value is 0. REKEY_INTERVAL The number of days that data encryption keys should int be used before automatically generated a new key. 0 = infinite, i.e., no re-keying. VOLUME_LABEL_PREFIX A user-configured string used to construct the varchar 256 Brocade-specific volume label on encrypted tapes. Ignored for disk LUNs. LAST_REKEY_DATE The last time a data encryption key was generated for timestamp this LUN. REKEY_INTERVAL days after this date, a new key will be generated. LAST_REKEY_STATUS The success or failure of the most recent re-keying operation, if any. This field is not currently used, but is left in the hope that FOS will support it in the future. Only valid for disk LUNs. The default value is 0. smallint 114 Brocade Network Advisor Documentation Updates 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

114
Brocade Network Advisor Documentation Updates
53-1002363-02
Database tables and fields
E
TIMESTAMP_
When the last successful collection is done.
timestamp
LAST_COLLECTED_STATUS
Status of the last collection, successful or not. 200 is
for successful. Values are standard HTTP protocol
values.
smallint
TABLE 224
CRYPTO_HOST
Field
Definition
Format
Size
ID
int
CRYPTO_TARGET_CONTAINE
R_ID
Foreign key reference to the
CRYPTO_TARGET_CONTAINER that contains this
host.
int
VI_NODE_WWN
Node WWN of Virtual Initiator that represents this
host.
char
23
VI_PORT_WWN
Port WWN of Virtual Initiator that represents this
host.
char
23
HOST_PORT_WWN
Physical (real) host''s Port WWN
char
23
HOST_NODE_WWN
Physical (real) host''s Node WWN
char
23
TABLE 225
CRYPTO_LUN
Field
Definition
Format
Size
ID
int
CRYPTO_TARGET_CONTAI
NER_ID
Foreign key reference to the CRYPTO_TARGET_CONTAINER
that contains the host for which these LUNs are configured
.
int
SERIAL_NUMBER
The LUN serial number, used to identify the physical
LUN.
varchar
256
ENCRYPTION_STATE
Boolean.
True (1) if LUN is being encrypted.
False (0)
if cleartext.';
The default value is 0.
smallint
STATUS
Not currently used but left in for possible future use.
Replaced by LUN_STATE. The default value is 0.
smallint
REKEY_INTERVAL
The number of days that data encryption keys should
be used before automatically generated a new key. 0 =
infinite, i.e., no re-keying.
int
VOLUME_LABEL_PREFIX
A user-configured string used to construct the
Brocade-specific volume label on encrypted tapes.
Ignored for disk LUNs.
varchar
256
LAST_REKEY_DATE
The last time a data encryption key was generated for
this LUN.
REKEY_INTERVAL days after this date, a new
key will be generated.
timestamp
LAST_REKEY_STATUS
The success or failure of the most recent re-keying
operation, if any.
This field is not currently used, but is
left in the hope that FOS will support it in the future.
Only valid for disk LUNs. The default value is 0.
smallint
TABLE 223
COLLECTOR_END_TIMESTAMP (Continued)
Field
Definition
Format
Size