If you are managing a partitioned UDB database, I would appreciate any
answer on this:

Lets say that I have a performance problem (query which runs slowly,
locks, etc.) and would like to tune a partitioned UDB installationI.
What would be the methodology of solving the problem?

Would it be better to first examine the whole database behaviour and
then go to the partition level, or would it be better to first check
the relevant partitions and only then go to the database level?

I have experience in Oracle DBA and now moving to UDB. In Oracle one
would first examine the partition level (it is called instance there)
and only then try to figure out problems in the database level (Real
Applications Cluster, in Oracle terms).

Thanks,
Ilan