Db2 adapter only shows the Remove option on the shortcut menu after new install


Diagnostics

Product: Reporting Server
Release: 8207
Primary OS: Windows
Solution Date:

Problem

Db2 adapter only shows the Remove option on the shortcut menu. Other options, such as Show Connections, should be present.

Solution

The Reporting Server was a new install, but the edaserve.cfg and edasprof.prf contents were copied from another environment. The edaserve.cfg had a db2_rel=97 parameter which indicates that the 97 version of the Db2 adapter should be configured. However, the Db2 Client is not the 97 version, but the 11 version.

The issue was resolved by removing the Db2 adapter and configuring it. This caused the Db2 11 adapter to configure successfully and match the Db2 client version.