We have 6 identical RBD 9.0.1 installations connecting to iSeries V7R1 using default driver com.ibm.datatools.db2.iseries_3.2.700.v20131113_0832. Retriveve SQL works in all but one machine. Copying workspace and settings does not help. When I attempt to Retrieve SQL I get the following error:
IWN.VAL.4582.e 0/0 Retrieve SQL failed because table XXX.YYY is not defined in database or because the user ID lacks SELECT authority.
The same user ID and database connection is used in all installations. Nothing wrong with the ID or authorities. Ping succeeds fine Preferences -> EGL -> SQL Database Connections. Is there some setting I should check? There are also some unnecessary Derby SQL connections, but the interface does not have a delete button. Could they cause disturbance? This post mentions enabling trace. How can I do that?