Troubleshooting
Problem
The DB2 Connector stage is missing Connection properties for particular users. However this does not happen for all users. Example of missing properties are: User name, Password, Database, Instance The Connector icon at top of properties dialog for selecting output, output or stage properties is also missing, along with all panels/tabs except the Advanced settings panel. This worked previously on all machines.
Cause
It was found that another piece of software was installed on the client machine that upgraded the ExGrid.dll to a higher version which is incompatible with DataStage Clients.
Resolving The Problem
This is a problem on the Client machine. The ExGrid.dll was upgraded to higher version from another software package. In this case it was 3.0, DataStage is only compatible with version 2.0.0.8.
There are three options to fix this problem:
- Open a command (DOS) window on the non-working DataStage Client
- Execute the following command:
regsvr32 C:\IBM\InformationServer\Clients\Classic\ExGrid.dll
Where C:\IBM\InformationServer\Clients\Classic is the default install location. If your install location is different point to your install directory.
Please note this may break the third party client software. - Another alternative would be to install client patch JR34751. This tells the connector stages to look in C:\IBM\InformationServer\Clients\Classic to resolve ExGrid.dll. This will allow multiple versions of the ExGrid.dll exist on the DataStage Windows Client. Note that the readme file for JR34751 contains post-install steps which need to be peformed on Windows Vista and Windows 7 for patch to work.
- Option 3 may be the best option as it should work on all Datatage 8.x clients, including those installed on Windows Vista and Windows 7, without breaking other installed software dependent upon a different release of ExGrid.dll. We accomplish this by telling windows that any dependent libraries (such as ExGrid.dll) which are required by DSDesign.exe should be search for first in the same directory that contains DSDesign.exe. The following steps will accomplish this.
- Go to the directory for the Information Server DataStage client files (if you only have one release of the client, it will usually be directory: C:\IBM\InformationServer\Clients\Classic
If you have multiple DataStage client releases on same machine, you may need to make this change for each instance. - In the Classic directory where you have file "DSDesign.exe" you need to create new, empty file called DSDesign.exe.local. You can do that at the windows command prompt in that directory with command:
touch DSDesign.exe.local - Next, if client machine is using Windows Vista or Windows 7, then you also need to make the following registry change:
- Open system registry in edit mode with "regedit" command.
- Locate the key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Image File Execution Options - Add a new attribute with name "DevOverrideEnable" of type DWORD and set the value to 1. To do that, right click on "Image File Execution Options" and select to create new DWORD and enter name DevOverrideEnable.
- Next, right click on DevOverrideEnable once added and select Modify option to change value to 1.
- Exit regedit and then reboot the machine. After reboot confirm that the Connector properties now display correctly.
Note that the version of APAR JR34751 provided for IIS 8.5 and 8.7 performs these same changes (the patch ships empty file DSDesign.exe.local and then the readme file for patch lists the above commands to perform manually to update the registry. Thus if you have applied JR34751 and still have the issue on Windows Vista or Windows 7 machines, it is due to the registry commands not peformed yet.
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21450055