Im running a cross connection query between multiple servers and I wasnt having a problem until I added a few more servers to my query. Now I keep getting an error message stating the new table cannot be mapped, If I delete the new stuff, the query runs fine. Its having an issue mapping the tables on the servers I just added I guess. These are DB2 databases if that helps.
As a trial I created an new cross-connection query builder and tried just adding one of the newer DB2 databases to this only, and I still get the error. If I run a single query against the db it runs no problem. Is there a way to fix this or go around this type of error. I need to run a query across 17 connections which is insane, but only get a handful to work.