Design advisor hangs
DB2 V9.5, Design advisor invoked from control center hangs loading page 3 of 10.
Design Advisor Hangs
Resolving the problem
The issue could be due to the APAR:JR31851.
Here is the workaround :
If you have multiple instances on the same server:
1) Open command prompt
2) set DB2INSTANCE=<instancename>
Now bring up the design advisor from the control center.
APAR to be fixed in V9.5 FP4.