I'm having problems selecting data from a Linked Server pointing ta a UDB DB2 database.
I'm able to connect to the database, however, for some reason I can't read the tables. My queries returns that the table does not exists.
Am I missing something here?
The user db2admin is the database administrator.
This is my Linked Server definition:
@srvproduct='IBM OLE DB Provider for DB2',
EXEC sp_addlinkedsrvlogin 'TESTE', 'false', NULL, 'db2admin', 'db2admin'
-->RPC enabled via Enterprise Manager
This is my test:
SELECT * FROM TESTE..DB2ADMIN.TMK0101
Msg 7314, Level 16, State 1, Line 1
The OLE DB provider "IBMDADB2" for linked server "TESTE" does not contain the table ""DB2ADMIN"."TMK0101"". The table either does not exist or the current user does not have permissions on that table.