HP 3PAR System Reporter 3.1 MU2 Software Release Notes (QL226-97096, April 2014)

run very frequently, HP recommends using either MySQL or Oracle databases. SQLite is not
supported when sampling more than one HP 3PAR StoreServ Storage array.
• Microsoft SQL Server (not included) must be obtained and installed separately and can be run
on a remote host. HP 3PAR System Reporter Software uses ODBC to connect to the Microsoft SQL
Server. HP 3PAR System Reporter Software does not support Microsoft SQL Server through ODBC
on Linux platforms.
• Oracle (not included) must be obtained and installed separately. Performance of sample insertion
with Oracle is a little lower than that of MySQL, but Oracle is also a good choice for large
databases. The Oracle database can be on a remote database server host, and not necessarily
on a machine on which HP 3PAR System Reporter Software is installed. Note that 64-bit Red Hat
Linux is not supported if using Oracle because it requires a 32-bit Oracle client to be installed,
and this is not supported on 64-bit Linux.
For detailed information on the supported database versions, see HP 3PAR System Reporter Software
document under 3PAR Array Software section on the HP SPOCK website: http://www.hp.com/storage/
spock.
HP 3PAR System Reporter installation notes
Detailed instructions are in Chapter 3, “Installation, Configuration, Update, and Removal” of the HP
3PAR System Reporter 3.1 MU2 Software User Guide. The CD now includes a spreadsheet for sizing
the system that will be used to run System Reporter and the database system.
To install and use System Reporter, a license is required for each HP 3PAR StoreServ Storage that is
to be sampled by System Reporter. If you plan to use AO, you must also have an additional license
to take advantage of the storage optimization capabilities offered by this optional component. If you
do not have a license for AO with HP 3PAR OS 3.1.1, the monitoring and system reporting features
are still accessible, but the optimization capabilities are inactivated. With HP 3PAR OS 3.1.2, the
system reporting feature is in the HP 3PAR Management Console rather than in System Reporter.
Before installing the System Reporter, the HP 3PAR CLI for Windows and Linux must be installed. See
the HP 3PAR Command Line Interface Reference for setting up the CLI client on the host machine for
Windows and Linux platforms, and see HP 3PAR Command Line Interface Administrator’s Manual.
These documents are available on the HP BSC (Business Support Center) website:
http://www.hp.com/support/manuals.
In the Storage section, click Storage Software, and then select HP 3PAR Operating System Software
under Storage 3PAR Device Management Software.
If you choose to use Microsoft SQL, MySQL or Oracle instead of the default SQLite database, these
must be installed and configured before installing HP 3PAR System Reporter Software, as described
in Chapter 3 of the HP 3PAR System Reporter 3.1 MU2 Software User Guide.
You must install Apache 2.0 (or later) before installing System Reporter. A binary installation package
for Windows is included in the CD for your convenience. Red Hat Linux includes packages for Apache.
You may choose to download your own Apache package from the following website:
www.apache.org.
If the Priority Optimization license is installed on the Storage System before upgrading from SR 3.1
MU1 to SR 3.1 MU2, HP recommends that you perform the following steps to remove the existing
erroneous QoS data from the database:
1. Stop the sampleloop service.
2. Login to the database as Administrator or CLI user, and select the schema that contains the System
Reporter related tables.
3. Execute the following commands in the database prompt:
• DROP TABLE statqos_hires_1;
• DROP TABLE statqos_hourly_1;
4 HP 3PAR System Reporter installation notes