Hp 3PAR System Reporter Software Manual de usuario Pagina 194
- Pagina / 224
- Tabla de contenidos
- SOLUCIÓN DE PROBLEMAS
- MARCADORES
Valorado. / 5. Basado en revisión del cliente
Table 65 adprovconfig_1 Table
CommentTypeColumn
A unique identifier for each adaptive optimization configuration.INTEGER PRIMARY KEY
(AUTO_INCREMENT)
adprovid
The system name.VARCHAR(32) NOT
NULL
sysname
Tier 0 CPG name. If there is no tier 0, this should be the empty string.VARCHAR(32) NULLt0_cpg_name
Tier 1 CPG name. If there is no tier 1, this should be the empty string.VARCHAR(32) NULLt1_cpg_name
Tier 2 CPG name. If there is no tier 2, this should be the empty string.VARCHAR(32) NULLt2_cpg_name
The schedule for when this adaptive optimization configuration should
be run. The format is a space-separated list of three items: the date
VARCHAR(200) NOT
NULL
ap_sched
list, the weekday list and the hour list. Each of these three lists is
either a “*” or a comma-separated list of individual dates, weekdays
and hours respectively.
The number of hours for which the region statistics should be
considered.
INTEGER NOT NULLstats_hours
One of three modes:VARCHAR(32) NOT
NULL
ao_mode
• Performance - Configuration is biased to move data towards faster
tiers.
• Balanced - Configuration determines appropriate distribution
between Performance and Cost.
• Cost - Configuration is biased to move data towards slower (less
costly) tiers.
0 - Configuration not active. 1 - Configuration is active.INTEGER NOT NULLap_active
The adprov_log Table
The adprov_log_1 table is used to keep track of when each adaptive optimization configuration
has been executed.
Table 66 adprov_log_1 Table
CommentTypeColumn
A unique identifier for each adaptive optimization configuration.INTEGER PRIMARY KEY
(AUTO_INCREMENT)
adprovid
Time in secs when the adaptive optimization configuration was started.
This is the Unix time and is the number of seconds since 0:00:00 Jan
1, 1970 GMT.
INTEGER NOT NULLstart_tsecs
Time in secs when the adaptive optimization configuration ended.
This is the Unix time and is the number of seconds since 0:00:00 Jan
1, 1970 GMT.
INTEGER NOT NULLend_tsecs
The status can be one of the following:VARCHAR(64) NOT NULLstatus
• started - Execution has started for the configuration.
• done - Execution completed without error for the configuration.
• error - Execution encountered an error.
The ldrgmoves Table
The ldrgmoves_1 table is used to keep track of the LD region moves generated for each adaptive
optimization configuration that has been executed.
194 Database Schema
- User’s Guide 1
- Documentation 7
- 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
- Contents 17 17
- 1 Introduction 18
- Typographical Conventions 19
- Advisories 19
- 2 Overview and Features 20
- Creating Customized Reports 21
- Generating Email Alerts 23
- 24 Overview and Features 24
- Before You Begin 25
- System Reporter CD Contents 25
- System Requirements 26
- System Reporter Components 28
- System Reporter Components 29 29
- Required Components 30
- Optional Components 30
- Installing the Web Server 31
- Microsoft SQL 33
- 6. Click Next 36
- Installing MySQL Server 38
- Creating an Oracle database 41
- Adding Storage Systems 47
- Verifying Installation 48
- 4 Getting Started 52
- Getting Help 54
- 56 Getting Started 56
- 58 Getting Started 58
- 60 Getting Started 60
- Deleting Excel Sheets 61
- Deleting Data Sheets 62
- Deleting the Query Log 62
- (Optional)” (page 48) 63
- Accessing Quick Reports 64
- Accessing Scheduled Reports 65
- Creating Custom Reports 66
- Building the Report Menu 67
- Select Systems 68
- Generating the Report 69
- Creating Custom Reports 71 71
- Controls Available by Report 72
- Report Selection 76
- 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 Cage IDs 86
- Select Disk Types 86
- Select Disk Speed 86
- Include PDs in States 86
- Select Usr CPGs 87
- Select Snp CPGs 87
- Select CPGs 87
- Select LDs 88
- Select RAID Types 88
- Select LD Usage 88
- Select LUN 88
- Select VVs 89
- Select Prov Types 89
- Select VV Types 89
- 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 92
- • Stacked Bars 93
- • Stacked Vert Bars 93
- • Stacked Area 94
- Figure 37 Chart Using Lines 95
- Figure 38 Chart Using Bars 95
- Chart X Pixels 96
- Chart Y Pixels 96
- Time Labels 96
- Legend Position 96
- Time Format 96
- Working with Excel Charts 97
- Refreshing Charts 98
- Retaining Charts 99
- Exporting Executable Reports 100
- Customizing Excel Reports 100
- Creating a Custom Chart 101
- Saving Customized Settings 102
- 6 Interpreting Report Metrics 103
- Space Reports 106
- VV Space Reports 107
- LD Space Reports 107
- Performance Reports 108
- VV Cache Performance Reports 109
- CPU Performance Reports 110
- Link Performance Reports 110
- Adaptive Optimization Reports 111
- Configuring Sampling Policies 112
- Compacting Databases 113
- Editing Sampling Policies 114
- Adding a Storage Server 115
- Removing a Storage Server 115
- Adding an Alert Rule 117
- Changing an Alert Rule 117
- Removing an Alert Rule 118
- Alert Rule Parameters 118
- Resolution 119
- Table 57 Metric (continued) 120
- Example of an Alert Rule 121
- Scheduling Reports 122
- Adding a Scheduled Report 123
- Changing a Scheduled Report 123
- About File Permissions 124
- 8 Web Queries 126
- About Reports and Options 127
- Report Options 128
- Report Options 129 129
- &compare=LD 130
- 130 Web Queries 130
- Report Options 131 131
- &refresh=2 132
- &charttab=chart 132
- 132 Web Queries 132
- Report Options 133 133
- 134 Web Queries 134
- &alllabels=1 135
- &timeform=relative 135
- Report Options 135 135
- &begintsecs=1121277634 136
- &endtsecs=1121277634 136
- 136 Web Queries 136
- Report Options 137 137
- &groupby=System 138
- 138 Web Queries 138
- Report Options 139 139
- &orderby=System 140
- 140 Web Queries 140
- &histbegin=1 141
- Report Options 141 141
- &seldisktype=FC 145
- Report Options 145 145
- &selvv= 152
- &selvv=--All%20VVs 152
- 152 Web Queries 152
- Report Types 153
- Summary Report 153
- Options Available by Report 161
- 162 Web Queries 162
- 164 Web Queries 164
- 166 Web Queries 166
- Objects Present Reports 167
- 172 Web Queries 172
- 176 Web Queries 176
- Objects Present Reports 177 177
- 9 Using Adaptive Optimization 178
- Schedule 182
- Measurement Hours 182
- Adaptive Optimization Mode 183
- Adaptive Optimization Active 183
- VV Tiers Report 186
- The showvvcpg CLI extension 188
- 10 Database Schema 190
- The system Table 191
- The alertconfig Table 192
- The scheduled_report Table 193
- The adprovconfig Table 193
- The adprov_log Table 194
- The ldrgmoves Table 194
- The recentsample Table 195
- The pdspace Table 196
- The pdspaceinv Table 197
- The ldspace Table 198
- The ldspaceinv Table 198
- The vvspace Table 199
- The vvspaceinv Table 201
- The cpgspace Table 201
- The cpgspaceinv Table 203
- The statpd Table 206
- The statpdinv Table 207
- The statld Table 207
- The statldinv Table 208
- The statport Table 208
- The statportinv Table 209
- The statvlun Table 209
- The statvluninv Table 210
- The statvvcmp Table 210
- The statvvcmpinv Table 211
- The statcpu Table 211
- The statcpuinv Table 212
- The statlink Table 212
- The statlinkinv Table 213
- The statldrg Table 213
- The statldrg_timeinv Table 214
- The perf_timeinv Table 214
- The space_timeinv Table 214
- 11 Troubleshooting 215
- Installation Configuration 216
- Sampling Errors 216
- Sampler Service/Daemon Errors 217
- # ./sysbck.binUsage: 218
- The [parameters] are 218
- 218 Troubleshooting 218
- Dumping the Entire Database 222
- 224 Index 224
Relacionado con productos y manuales para Almacenamiento Hp 3PAR System Reporter Software
(115 paginas)© 2020, manymanuals.es. Todos los derechos reservados | 0.045 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comentarios a estos manuales