HP XP P9000 Performance Advisor v5.5 Software Troubleshooting and FAQs Guide (T1789-96344, February 2013)

However, you can first import the v3.5.2 data onto another management station and then upgrade
it to v4.0.
During the upgrade, can I move or copy the HP XP P9000 Performance Advisor database folders
to a different location on the same or a different management station?
No. HP recommends that the HP XP P9000 Performance Advisor database folders remain untouched,
as HP XP P9000 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 XP P9000 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 XP P9000 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 XP P9000 Performance Advisor version:
If you are upgrading HP XP P9000 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 XP P9000 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 XP P9000 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 XP P9000 Performance Advisor is installed contains any non-HP XP
P9000 Performance Advisor related data, move that data to another drive location or delete
the non-HP XP P9000 Performance Advisor data.
If the drive where HP XP P9000 Performance Advisor is installed contains only HP XP P9000
Performance Advisor related data, complete the following steps:
1. Stop the HP XP P9000 Performance Advisor services (Start -> Programs -> HP XP P9000
Performance Advisor -> Stop services).
2. Move the data located in %HPSS_HOME%\cache folder to another location on the
management station.
54 Frequently Asked Questions