I have setup a linked DB2 server and i c the table/view list in EM>Security. But in QA when i run

select * from servername.catalog.user.tablename

i get the following error msg:

Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error. The provider does not support the necessary method.
[OLE/DB provider returned message: Method is not supported by this provider.]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBSchemaRowset::GetRowset returned 0x80040e53: The provider does not support the necessary method.].

Any way to solve this?

You might want to look into creating a federated server in DB2 for your environment to solve these problems. Check the online DB2 support documentation for how to do this.
Hope this helps.

Scott