HP 3PAR StoreServ 7400 2-node HP 3PAR System Reporter 3.1.0 Software User& - Page 220
Extracting Data from the Database with sysbck, sysbck
View all HP 3PAR StoreServ 7400 2-node manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 220 highlights
Figure 67 Microsoft Office Excel Internal Error If you experience a problem with a recovered copy of the workbook (Figure 68 (page 220)), try starting with a fresh copy of System Reporter workbook. Figure 68 Microsoft Excel Recovery Error Extracting Data from the Database with sysbck Sometimes it is necessary to extract some of the data from the System Reporter database. For example, you may want to send that data to HP to help in analyzing a performance problem. This section describes how you can extract all or some of the data from a database using the sysbck command into a set of files that can then be loaded into a different database. 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 "Dumping the Entire Database" (page 224). 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: # ./sysbck.binUsage: sysbck [parameters] The [parameters] are -dbtype -dbhost Type of database: sqlite, mysql or oracle. For mysql: name or IP address of host. Default is localhost. 220 Troubleshooting System Reporter