Hp 3PAR StoreServ 7000 Storage User Manual Page 212
- Page / 231
- Table of contents
- TROUBLESHOOTING
- BOOKMARKS
Rated. / 5. Based on customer reviews
Table 85 statvlun_<res>_3 Table (continued)
CommentTypeColumn
The host WWN (world wide name) or iscsi name.VARCHAR(128) NOT
NULL
host_wwn
The node that the port is connected to (the “n” part of n:s:p).INTEGER NOT NULLport_n
The PCI slot in the node that the port is connected to (the “s” part of
n:s:p).
INTEGER NOT NULLport_s
The port number in the PCI slot in the node that the port is connected
to (the “p” part of n:s:p).
INTEGER NOT NULLport_p
The rest of the columns are the common performance columns
described in “Common Performance Table Columns” (page 205)).
(common performance
columns)
The statvluninv Table
The statvluninv_<res>_4 table holds the inventory for statvlun_<res>_4 table.
Table 86 statvluninv_<res>_4 Table
CommentTypeColumn
Sample time in secs. This is the Unix time and is the number of
seconds since 0:00:00 Jan 1, 1970 GMT.
INTEGER NOT NULLtsecs
A unique identifier for the system instance refers to the uniq_id for
the system instance in the system_3 table.
INTEGER NOT NULLsys_uid
The domain name that the VLUN belongs to. If the VLUN is not
assigned to a domain, this column contains the value “-”.
VARCHAR(32) NOT NULLdom_name
The VV name.VARCHAR(32) NOT NULLvv_name
The host name.VARCHAR(32) NOT NULLhost_name
The LUN number.INTEGER NOT NULLlun
The host WWN (world wide name) or iscsi name.VARCHAR(128) NOT
NULL
host_wwn
The node that the port is connected to (the “n” part of n:s:p).INTEGER NOT NULLport_n
The PCI slot in the node that the port is connected to (the “s” part of
n:s:p).
INTEGER NOT NULLport_s
The port number in the PCI slot in the node that the port is connected
to (the “p” part of n:s:p).
INTEGER NOT NULLport_p
The statvvcmp Table
The statvvcmp_<res>_2 table holds VV cache performance data samples.
Table 87 statvvcmp_<res>_2 Table
CommentTypeColumn
Sample time in secs. This is the Unix time and is the number of
seconds since 0:00:00 Jan 1, 1970 GMT.
INTEGER NOT NULLtsecs
A unique identifier for the system instance refers to the uniq_id for
the system instance in the system_3 table.
INTEGER NOT NULLsys_uid
The domain name that the VV belongs to. If the VV is not assigned
to a domain, this column contains the value “-”.
VARCHAR(32) NOT NULLdom_name
The VV ID.INTEGER NOT NULLvvid
212 Database Schema
- User's Guide 1
- Contents 7
- 8 Contents 8
- Contents 9 9
- 10 Contents 10
- Contents 11 11
- 12 Contents 12
- Contents 13 13
- 14 Contents 14
- Contents 15 15
- 16 Contents 16
- 1 Overview and Features 17
- 18 Overview and Features 18
- Creating Customized Reports 19
- Generating Email Alerts 21
- 22 Overview and Features 22
- Before You Begin 23
- System Reporter CD Contents 23
- System Requirements 24
- System Reporter Components 26
- Optional Components 28
- Installing the Web Server 29
- Microsoft SQL 31
- 9. Click Next 36
- 10. Click Finish 36
- Installing MySQL Server 37
- Creating an Oracle database 40
- Adding Storage Systems 46
- Verifying Installation 47
- 3 Getting Started 51
- 52 Getting Started 52
- Getting Help 53
- 54 Getting Started 54
- 56 Getting Started 56
- 58 Getting Started 58
- Deleting Excel Sheets 60
- Deleting Data Sheets 61
- Deleting the Query Log 61
- (Optional)” (page 47) 62
- Accessing Quick Reports 63
- Accessing Scheduled Reports 64
- Creating Custom Reports 65
- Building the Report Menu 66
- Sample Resolution 67
- Generating the Report 68
- Creating Custom Reports 69 69
- Controls Available by Report 71
- Report Selection 75
- Reports” (page 112) 76
- Creating Custom Reports 77 77
- Creating Custom Reports 79 79
- Select Summary Columns 81
- Max. Number 82
- Select Peak 82
- Group By 82
- Order By 83
- Time Selection 84
- Object Selection 85
- Select PDIDs 86
- Include Chunklets 86
- Select Cage IDs 86
- Select Disk Types 86
- Select Disk Speed 86
- Include PDs in States 87
- Select Usr CPGs 87
- Select Snp CPGs 87
- Select CPGs 88
- Select LDs 88
- Select RAID Types 88
- Select LD Usage 88
- Select LUN 89
- Select VVs 89
- Select Prov Types 89
- Select VV Types 90
- Select Port Types 90
- Select Port Rates 90
- Select Ports (n:s:p) 90
- Select Hosts 91
- Select Nodes 91
- Select To Nodes 91
- Select Queues 91
- Report Information 92
- Chart Lib 92
- Chart Types 93
- • Stacked Bars 94
- • Stacked Vert Bars 94
- • Stacked Area 95
- Figure 37 Chart Using Lines 96
- Figure 38 Chart Using Bars 96
- Chart X Pixels 97
- Chart Y Pixels 97
- Time Labels 97
- Legend Position 97
- Time Format 97
- Working with Excel Charts 98
- Refreshing Charts 99
- Retaining Charts 100
- Exporting Executable Reports 101
- Customizing Excel Reports 101
- Creating a Custom Chart 102
- Saving Customized Settings 103
- 5 Interpreting Report Metrics 104
- Space Reports 107
- LD Space Reports 108
- VV Space Reports 108
- Performance Reports 109
- VV Cache Performance Reports 110
- CPU Performance Reports 111
- Link Performance Reports 111
- Adaptive Optimization Reports 112
- Configuring Sampling Policies 113
- Compacting Databases 114
- Editing Sampling Policies 115
- Adding a Storage System 116
- Removing a Storage Server 116
- Adding an Alert Rule 118
- Changing an Alert Rule 118
- Removing an Alert Rule 119
- Alert Rule Parameters 119
- Resolution 120
- Direction 121
- Limit Value 121
- Limit Count 121
- Condition 121
- Scheduling Reports 122
- Adding a Scheduled Report 123
- Changing a Scheduled Report 124
- Removing a Scheduled Report 124
- About File Permissions 125
- 7 Web Queries 127
- About Reports and Options 128
- Report Options 129
- 130 Web Queries 130
- &compare=LD 131
- Report Options 131 131
- 132 Web Queries 132
- &refresh=2 133
- &charttab=chart 133
- Report Options 133 133
- 134 Web Queries 134
- Report Options 135 135
- &alllabels=1 136
- &timeform=relative 136
- 136 Web Queries 136
- &begintsecs=1121277634 137
- &endtsecs=1121277634 137
- Report Options 137 137
- 138 Web Queries 138
- &groupby=System 139
- Report Options 139 139
- 140 Web Queries 140
- &orderby=System 141
- Report Options 141 141
- &histbegin=1 142
- 142 Web Queries 142
- &selcageid=1 144
- 144 Web Queries 144
- &seldisktype=FC 146
- &seldiskspeed=10 146
- 146 Web Queries 146
- &selvv= 153
- &selvv=--All%20VVs 153
- Report Options 153 153
- Report Types 154
- Summary Report 154
- Options Available by Report 163
- 164 Web Queries 164
- 166 Web Queries 166
- 168 Web Queries 168
- Objects Present Reports 169
- Objects Present Reports 171 171
- 174 Web Queries 174
- Objects Present Reports 177 177
- Objects Present Reports 179 179
- 8 Using Adaptive Optimization 180
- Schedule 184
- Measurement Hours 184
- Adaptive Optimization Mode 185
- Adaptive Optimization Active 185
- VV Tiers Report 188
- The showvvcpg CLI extension 190
- 9 Database Schema 192
- The system Table 193
- The scheduled_report Table 194
- The alertconfig Table 194
- The adprovconfig Table 195
- The adprov_log Table 196
- The ldrgmoves Table 196
- The recentsample Table 197
- The pdspace Table 198
- The pdspaceinv Table 199
- The ldspace Table 200
- The ldspaceinv Table 200
- The vvspace Table 201
- The vvspaceinv Table 203
- The cpgspace Table 203
- The cpgspaceinv Table 205
- The statpd Table 208
- The statpdinv Table 209
- The statld Table 209
- The statldinv Table 210
- The statport Table 210
- The statportinv Table 211
- The statvlun Table 211
- The statvluninv Table 212
- The statvvcmp Table 212
- The statvvcmpinv Table 213
- The statcpu Table 213
- The statcpuinv Table 214
- The statlink Table 214
- The statlinkinv Table 215
- The statldrg Table 215
- The statldrg_timeinv Table 216
- The perf_timeinv Table 216
- The space_timeinv Table 216
- Troubleshooting Overview 217
- Installation Configuration 218
- Sampling Errors 218
- Sampler Service/Daemon Errors 219
- Dumping the Entire Database 224
- Contacting HP 225
- HP 3PAR documentation 225
- Typographic conventions 228
- HP 3PAR branding information 228
- 12 Documentation feedback 229
- 230 Index 230
Related products and manuals for Storage Hp 3PAR StoreServ 7000 Storage
Storage Hp StoreAll Storage User Manual
(254 pages)
(254 pages)
Storage Hp IP Distance Gateway User Manual
(153 pages)
(153 pages)
Storage Hp Surestore 6164 Switch User Manual
(86 pages)
(86 pages)
Storage Hp XP RAID Manager Software User Manual
(182 pages)
(182 pages)
© 2020, manymanuals.com. All rights reserved. | 5.967 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comments to this Manuals