HP StorageWorks XP Performance Advisor Software v4.6 User and Troubleshooting Guide (T1789-96094, June 2010)

9 Managing the XP Performance Advisor
database
This chapter discusses the following topics:
• “Introduction” on page 147
• “Configuring database size” on page 149
• “Purging data” on page 151
• “Creating and viewing Export DB CSV files” on page 154
• “Archiving data” on page 160
• “Importing data” on page 163
• “Deleting logs for archival and import activities” on page 166
Introduction
XP Performance Advisor uses Oracle as its database. When XP Performance Advisor is installed, all
the database related files are also automatically installed on the management station. To start with,
a default disk space of 3 GB is allocated from the management station's available disk space to XP
Performance Advisor database. If you have upgraded from a previous version of XP Performance
Advisor to the current version, the management station's available disk space is automatically allocated
to the database migrated during the upgrade process. You can manage XP Performance Advisor
database in the following ways:
• Configure the database size manually, where you allocate the available disk space on your system
to XP Performance Advisor database
• Configure XP Performance Advisor to automatically determine the available disk space on your
system and allocate to XP Performance Advisor database (Auto Grow)
• Purge data that belongs to an XP array or data older than the specified date
• Purge data automatically, where XP Performance Advisor purges the oldest data in its database
to accommodate new data
• Archive data from XP Performance Advisor database
• Import data into XP Performance Advisor database
• Generate or schedule Export DB reports, and also view records for the Export DB files
The above mentioned activities can be performed on the Database Manager screen.
IMPORTANT:
You have to log into XP Performance Advisor as an Administrator or a user with administrative
privileges to configure, purge, archive, or import XP Performance Advisor database. You also need
this privilege to view or delete Export DB schedules.
HP StorageWorks XP Performance Advisor Software User Guide 147