HP XP7 Performance Advisor v6.1 Software Troubleshooting and FAQs Guide

No. HP recommends that the HP XP7 Performance Advisor database folders remain untouched,
as HP XP7 Performance Advisor uses the files in these folders for the upgrade to complete. The
folders not being available can lead to data corruption, permanent data loss, and upgrade failure.
Can the database size be reduced using DefragmentDB.bat?
No. DefragmentDB.bat was provided prior to HP XP7 Performance Advisor v3.5 for the purpose
of defragmenting the SOLID database space. It cannot be used to defragment the Oracle database,
which is provided with HP XP7 Performance Advisor, v3.5 onwards.
Why do I see reducing of free space in PADB Drive?
When there are increased database operations, there might be an increase in the size of the
following files:
• Export/Import
• Purge
• Auto Purge
• Backup and Restore operations.
In such a scenario, the UNDOTBS2.DBF and Temp.DBF file sizes will increase to a maximum of
32 GB.
During upgrade, what should be the available free disk space for the upgrade to complete?
It depends on the HP XP7 Performance Advisor version:
• If you are upgrading HP XP7 Performance Advisor from a pre 3.5 version to v3.5 or later,
following is the requirement: 10 GB free space on the hard drive (minimum), 32 GB free disk
drive space (for cache swap space and database) (NTFS)
• If you are upgrading HP XP7 Performance Advisor from a v3.5 or later version to v4.5, at
least 2GB free disk space is recommended
I manually purged the database when the system disk space on the management station was
showing low. Then, I verified if the purge was successful by plotting performance graphs for the
specific purge duration. However, the system disk space of the management station is still showing
low and I am unable to do a configuration collection. What has happened to the disk space that
got released when the data was purged?
Even though the HP XP7 Performance Advisor database space is released, this disk space can only
be used for Oracle database activities and cannot be used by other system resources. You can do
the following to reinitiate the configuration data collections:
• If the drive where HP XP7 Performance Advisor is installed contains any non-HP XP7
Performance Advisor related data, move that data to another drive location or delete the
non-HP XP7 Performance Advisor data.
• If the drive where HP XP7 Performance Advisor is installed contains only HP XP7 Performance
Advisor related data, complete the following steps:
1. Stop the HP XP7 Performance Advisor services (Start -> Programs -> HP XP7 Performance
Advisor -> Stop services).
2. Move the data located in %HPSS_HOME%\cache folder to another location on the
management station.
3. Move the logs in the pa\tomcat\logs folder to another location on the management
station.
4. Start the HP XP7 Performance Advisor services (Start -> Programs -> HP XP7 Performance
Advisor -> Start services).
Is there a procedure to downgrade the HP XP7 Performance Advisor database? For example, if
HP XP7 Performance Advisor was upgraded from v3.5.2 to v4.1, can the database be downgraded
to v3.5.2?
HP XP7 Performance Advisor database management 57