IBM Support

Design advisor hangs

Technote (troubleshooting)


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

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

Related information

Fixpak download

Document information

More support for: DB2 for Linux, UNIX and Windows
OTHER - Uncategorised

Software version: 9.5

Operating system(s): Windows

Reference #: 1381845

Modified date: 15 April 2009