Hi,

I have a federated database system question on db2 v8.1 fp6 on Windows. I would like to know in which system catalog table is written relation bettween nickname and remote table.

I would like to get something like:
nickname_schema, nickname_table, remote_schema, remote_table.

Thanks,
Grofaty

have a look in syscat.taboptions : multi rows for each remote nickname
ORA10NT BELGIUM SERVER ORA10NT
ORA10NT BELGIUM REMOTE_SCHEMA DB2ADMIN
ORA10NT BELGIUM REMOTE_TABLE BELGIUM
ORA10NT BELGIUM TUPLE_ID_TYPE ROWID
Hope this will help
Best Regards, Guy Przytula

Hi przytula,

Thank you very much. It works for me.

Grofaty