Hp 3PAR System Reporter Software Manual de usuario Pagina 357
- Pagina / 378
- Tabla de contenidos
- SOLUCIÓN DE PROBLEMAS
- MARCADORES
Valorado. / 5. Basado en revisión del cliente
11.7
Extracting Data from the Database with sysbck
System Reporter 2.8 3PAR System Reporter User’s Guide
On Windows the sysbck.exe executable is installed in the System Reporter directory (by
default C:\Program Files\3PAR\System Reporter), and on Linux the sysbck.bin
executable is installed in the
/usr/bin/ directory.
The parameters for the
sysbck command are shown below:
NOTE: If necessary, when using sysbck to extract large amounts of data from a
database, the contents may be saved in separate 2 Gb files.
NOTE: The sysbck command is recommended when extracting a relatively small
sampling of the database. The command creates a file with SQL statements to
insert each row of extracted data into a database. While this is convenient for
subsequently loading the data into a database, especially if the database is of a
different type than the source database, the file size can be quite large. If you
want to extract the entire database or large sections of the database, it is
preferable to dump the entire database as described in 11.7 Dumping the Entire
Database on page 11.12.
# ./sysbck.bin
Usage:
sysbck [parameters]
The [parameters] are
-dbtype <dbtype> Type of database: sqlite, mysql or oracle.
-dbhost <dbhost> For mysql: name or IP address of host.
Default is localhost.
For oracle: hosts string.
Ignored if dbtype is sqlite.
-db <name> Name of the database.
For SQLite this is the full file name, including the path,
of the file that contains the database.
-dbpwfile <file> Name of file whose first line is the username and
password for the database.
Ignored if dbtype is sqlite.
-dbouttype [Optional] <dbtype> Name of the outscript db type
-scripttype [Optional] <script type> Type of the script 'insert/create/both'
-backupfilename The file name along with the path to put the extract in
-begintime [Optional] begin time of the extract in '%m/%d/%YYYY %H:%M:%S' format
-endtime [Optional] end time of the extract in '%m/%d/%YYYY %H:%M:%S' format
-inservname [Optional] name of the inservs to be extracted seperated by ':'
- System Reporter 2.8 1
- User’s Guide 1
- Oractcl Copyright and License 3
- TWAPI Copyright & License 7
- GNU General Public License 7
- PREAMBLE 7
- NO WARRANTY 10
- Table of Contents 11
- 4 Getting Started 13
- 6 Interpreting Report Metrics 16
- 8Web Queries 17
- 9 Using Adaptive Optimization 20
- 10 Database Schema 21
- 11 Troubleshooting 22
- IX Index 23
- RH Revision History 23
- Introduction 25
- 1.3 Related Documentation 26
- 1.4 Organization 27
- 1.5 Typographical Conventions 28
- 1.6 Advisories 28
- Overview and Features 29
- Table 2-1. Available Reports 32
- 2.7 Generating Email Alerts 35
- Installation, Configuration 37
- Update, and Removal 37
- System Reporter CD Contents 38
- 0.9.8k.msi 39
- 3.3 System Requirements 40
- System Requirements 41
- System Reporter Components 45
- Installing the Web Server 49
- 3.8.1.1 SQLite 50
- 3.8.1.2 MySQL 51
- 3.8.1.3 Oracle 51
- 3.9.1 Adding InServ Systems 67
- C:\Program Files\3par\System 68
- Reporter\log\sampleloop.log) 68
- 3PAR System Reporter.xls 69
- Getting Started 75
- 4.3 Getting Help 78
- 4.4.1 Simple Selection List 79
- 4.6.1 Changing the Web Server 89
- 4.6.2 Resetting the Workbook 89
- 4.8 Deleting Excel Sheets 90
- Accessing and Creating 93
- 5.1 Accessing Quick Reports 94
- Accessing Scheduled Reports 95
- 5.3 Creating Custom Reports 96
- 5.3.1.1 Sample Resolution 98
- 5.3.1.2 Report 98
- 5.3.1.3 Select Systems 100
- 5.3.1.4 Select Domains 101
- 5.3.2 Generating the Report 102
- Creating Custom Reports 103
- Figure 5-5. Query Results 105
- 5.3.4 Report Selection 109
- 5.3.4.1 Standard Report Types 110
- Report Example 116
- Summary report 116
- 5.3.4.3 Compare 117
- 5.3.4.4 Select Peak 117
- 5.3.4.5 Group By 117
- Table 5-7. Group By 118
- Option Purpose 119
- 5.3.4.6 Order By 120
- Table 5-8. Order By 121
- 5.3.4.7 Low Bucket 122
- 5.3.4.8 High Bucket 122
- 5.3.4.9 Sum End Buckets 122
- 5.3.5 Time Selection 123
- 5.3.5.4 Count 124
- 5.3.6 Object Selection 125
- 5.3.6.3 Select Cage IDs 126
- 5.3.6.4 Select Disk Types 126
- 5.3.6.5 Select Disk Speed 127
- 5.3.6.6 Include PDs in States 127
- 5.3.6.7 Select Usr CPGs 128
- 5.3.6.8 Select Snp CPGs 129
- 5.3.6.9 Select CPGs 129
- 5.3.6.10 Select LDs 130
- 5.3.6.11 Select RAID Types 130
- 5.3.6.12 Select LD Usage 131
- 5.3.6.13 Select VVs 132
- 5.3.6.14 Select Prov Types 133
- 5.3.6.15 Select VV Types 134
- 5.3.6.16 Select Ports (n:s:p) 134
- 5.3.6.17 Select Port Types 135
- 5.3.6.18 Select Hosts 135
- 5.3.6.19 Select Nodes 136
- 5.3.6.20 Select To Nodes 136
- 5.3.6.21 Select Queues 137
- 5.3.7.1 Report Information 137
- 5.3.7.2 Chart Types 138
- Stacked Bars 139
- Stacked Vert Bars 139
- Stacked Area 140
- Vert Bars 141
- 5.3.7.3 Chart X Pixels 142
- 5.3.7.4 Chart Y Pixels 142
- 5.3.7.5 Time Labels 142
- 5.3.7.6 Legend Position 142
- 5.3.7.7 Time Format 143
- 5.3.7.8 Select Space Unit 143
- 5.4.1 Choosing a Chart Type 144
- 5.4.2 Refreshing Charts 145
- Working with Excel Charts 146
- 5.4.3 Retaining Charts 147
- =H53+J53+K53 150
- =IF(N53>0,H53/N53*100,0) 150
- Interpreting Report Metrics 153
- Summary Report 154
- 6.2 Space Reports 158
- 6.2.2 LD Space Reports 159
- 6.2.3 VV Space Reports 160
- Space Reports 161
- 6.3 Performance Reports 163
- Performance Reports 164
- 6.3.4 CPU Performance Reports 167
- Adaptive Optimization Reports 168
- Configuring the System 169
- Reporter Policy Settings 169
- Table 7-1. Sampling Policies 170
- 7.2.1 Compacting Databases 171
- Configuring Sampling Policies 172
- 7.3.1 Adding a Storage Server 175
- 7.4.1 Adding an Alert Rule 177
- 7.4.2 Changing an Alert Rule 178
- 7.4.3 Removing an Alert Rule 178
- 7.4.4 Alert Rule Parameters 179
- 7.4.4.2 Resolution 180
- 7.4.4.3 System 181
- 7.4.4.4 Metric 181
- Table 7-4. Metric 182
- 7.4.4.5 Direction 184
- 7.4.4.6 Limit Value 184
- 7.4.4.7 Limit Count 185
- 7.4.4.8 Condition 185
- 7.4.4.9 Condition Value 185
- 7.4.4.10 Recipient 185
- 7.5 Scheduling Reports 186
- Scheduling Reports 187
- 7.7 About File Permissions 190
- Web Queries 193
- <server_name>) 194
- [&<option>]) 194
- [&<option>...]) 194
- Data Format Version Report 195
- 8.4 Report Options 196
- 8.4.2 compare 197
- 8.4.2.1 values: 198
- Report Options 199
- 8.4.3 comparesel 200
- 8.4.4 table 201
- 8.4.4.2 example: 202
- 8.4.5 refresh 203
- 8.4.6 charttab 203
- 8.4.7 charttype 204
- 8.4.8 graphx 205
- 8.4.9 graphy 205
- 8.4.10 graphlegpos 206
- 8.4.11 tableformat 206
- 8.4.12 alllabels 207
- 8.4.13 timeform 208
- 8.4.14 begintsecs 208
- 8.4.15 endtsecs 209
- 8.4.16 groupby 210
- 8.4.16.2 example: 212
- 8.4.17 orderby 213
- 8.4.18 histbegin 217
- 8.4.19 ldspaceunit 217
- 8.4.20 pdspaceunit 218
- 8.4.21 vvspaceunit 219
- 8.4.22 selcageid 220
- 8.4.23 selchunks 221
- 8.4.23.2 example: 222
- 8.4.24 selcpg 223
- 8.4.25 selusrcpg 223
- 8.4.26 selsnpcpg 223
- 8.4.27 seldisktype 223
- 8.4.28 seldiskspeed 224
- 8.4.29 seldomain 225
- 8.4.30 selhost 226
- 8.4.31 selld 227
- 8.4.32 sellduse 227
- 8.4.33 selnode 228
- 8.4.34 selnsp 229
- 8.4.35 selpdid 230
- 8.4.36 selpdstate 231
- 8.4.37 selporttype 231
- 8.4.38 selraidtype 232
- 8.4.39 selsys 233
- 8.4.40 selvv 234
- 8.4.41 selvvtype 235
- 8.4.42 selprovtype 235
- 8.5 Report Types 236
- 8.6 Summary Report 237
- 8.7 Space Reports 237
- 8.7.3 ld_space_time 238
- 8.7.4 ld_space_group 238
- 8.8 Performance Reports 239
- 8.8.2 pd_perf_group 240
- 8.8.3 pd_svt_hist 240
- 8.8.4 pd_svt_histvstime 241
- 8.8.5 port_perf_time 241
- 8.8.6 port_perf_group 241
- 8.8.7 port_svt_hist 242
- 8.8.8 port_svt_histvstime 242
- 8.8.9 ld_perf_time 242
- 8.8.10 ld_perf_group 243
- 8.8.11 ld_svt_hist 243
- 8.8.12 ld_svt_histvstime 243
- 8.8.13 vlun_perf_time 244
- 8.8.14 vlun_perf_group 244
- 8.8.15 vlun_svt_hist 244
- 8.8.16 vlun_svt_histvstime 245
- 8.8.17 vv_cmp_time 245
- 8.8.18 vv_cmp_group 245
- 8.8.19 cpu_perf_time 246
- 8.8.20 cpu_perf_group 246
- 8.9.1 regiodensity 247
- 8.9.2 regmoves 247
- 8.9.3 vvtier 247
- 8.9.3.1 vvtier example 248
- Options Available by Report 249
- 8.11 Objects Present Reports 253
- Objects Present Reports 254
- 8.11.1 objectpres= cageid 257
- 8.11.2 objectpres= cpg_name 258
- 8.11.3 objectpres= diskspeed 259
- 8.11.4 objectpres= disktype 260
- 8.11.6 objectpres= host_name 261
- 8.11.7 objectpres= ld_name 262
- 8.11.8 objectpres=node 263
- 8.11.9 objectpres=pdid 264
- 8.11.10 objectpres=port 265
- 8.11.11 objectpres= system 266
- 8.11.12 objectpres= vv_name 267
- 8.11.12.2 output: 268
- 8.11.13.1 example: 268
- 8.11.13.2 output: 268
- 8.11.14 objecctpres= porttype 269
- 8.11.15 sample_times 270
- Using Adaptive 273
- Optimization 273
- Overview 274
- 9.3.2 Schedule 281
- 9.3.3 Measurement Hours 281
- 9.4.2 VV Tiers Report 288
- The showvvcpg CLI extension 290
- Database Schema 293
- 10.3 Administrative Tables 294
- 10.3.2 The sampleinserv Table 295
- 10.3.3 The system Table 296
- 10.3.4 The alertconfig Table 297
- Administrative Tables 298
- 10.3.7 The adprovconfig Table 301
- 10.3.8 The adprov_log Table 303
- 10.3.9 The ldrgmoves Table 304
- ■ hourly - Hourly samples 306
- ■ daily - Daily sample 306
- 10.4.1 The pdspace Table 307
- 10.4.2 The pdspaceinv Table 310
- 10.4.3 The ldspace Table 311
- 10.4.4 The ldspaceinv Table 313
- 10.4.5 The vvspace Table 314
- 10.4.6 The vvspaceinv Table 317
- 10.4.7 The cpgspace Table 319
- 10.4.8 The cpgspaceinv Table 321
- 10.4.10 The statpd Table 329
- 10.4.11 The statpdinv Table 331
- 10.4.12 The statld Table 332
- 10.4.13 The statldinv Table 333
- 10.4.14 The statport Table 334
- 10.4.15 The statportinv Table 335
- 10.4.16 The statvlun Table 337
- 10.4.17 The statvluninv Table 338
- 10.4.18 The statvvcmp Table 339
- 10.4.20 The statcpu Table 342
- 10.4.21 The statcpuinv Table 344
- 10.4.22 The statlink Table 344
- 10.4.23 The statlinkinv Table 346
- 10.4.24 The statldrg Table 347
- Troubleshooting 351
- 11.2.3 InServ Sampling Errors 353
- C:\Program Files\Apache 355
- Group\Apache2\logs 355
- /var/log/httpd) 355
- ■ From MySQL to Oracle: 359
- ■ From MySQL to MySQL: 359
- ■ From Oracle to MySQL: 359
- ■ From Oracle to Oracle: 359
- ■ From SQLite to SQLite: 360
- ■ From SQLite to MySQL: 360
- ■ From SQLite to Oracle: 360
- Dumping the Entire Database 362
- Revision History 371
Relacionado con productos y manuales para Almacenamiento Hp 3PAR System Reporter Software
(58 paginas)© 2020, manymanuals.es. Todos los derechos reservados | 0.039 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comentarios a estos manuales