HP 3PAR System Reporter Software - Manual (Page 358)

11.8 Extracting Data from the Database with sysbck
3PAR System Reporter User’s Guide System Reporter 2.8
Depending on the -scripttype parameter, the sysbck command produces one or both of
the following types of files:
1 The <backup>.str file contains SQL code to create the database structure (tables and
indexes).
2 The <backup>.ins contains SQL code to insert the data into the tables.
These files can be source as SQL commands to create the schema and insert the data
respectively.
To limit the extracted data to one or more InServ systems, use the -inservname parameter. To
limit the extracted data to a particular time period, use the -begintime and -endtime
parameters.
11.6.1 Examples of Using sysbck for Various Databases
Following are examples of how to use the sysbck command to generate output for various
databases.
NOTE: The -inservname parameter specifies the IP Name or Address that was
assigned while configuring the InServ Systems. If you are not sure, consult Policy
Settings -> InServ Systems to get this parameter.
NOTE: The - dbouttype parameter should not be used when extracting data for
analysis by 3PAR support.
NOTE: the dbouttype parameter is optional; by default, the extract database is
MySQL.