IBM Support

Design advisor hangs

Technote (troubleshooting)


Problem(Abstract)

DB2 V9.5, Design advisor invoked from control center hangs loading page 3 of 10.

Symptom

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>
3) db2cc

Now bring up the design advisor from the control center.
APAR to be fixed in V9.5 FP4.

Related information

APAR:JR31851
Fixpak download

Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.5

Operating system(s): Windows

Reference #: 1381845

Modified date: 2009-04-15