HP StorageWorks P9000 Performance Advisor Software v5.4 Troubleshooting and FAQs Guide (T1789-96336, April 2012)

During the upgrade, can I move or copy the P9000 Performance Advisor data-
base folders to a different location on the same or a different management sta-
tion?
No. HP recommends that the P9000 Performance Advisor database folders remain untouched, as
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 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 P9000 Performance Advisor, v3.5 onwards.
Why do I see reducing of free space in PADB Drive?
There might be increase in the size of following files, if there are more database operations:
• Export/Import
• Purge
• Auto Purge
• Backup and Restore operations.
In such scenarios, the UNDOTBS2.DBF and Temp.DBF 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 P9000 Performance Advisor version:
• If you are upgrading 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 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 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 P9000 Performance Advisor is installed contains any non-P9000 Performance
Advisor related data, move that data to another drive location or delete the non-P9000 Performance
Advisor data.
• If the drive where P9000 Performance Advisor is installed contains only P9000 Performance Advisor
related data, complete the following steps:
HP StorageWorks P9000 Performance Advisor Software Frequently Asked Questions 63