Nicknames are pointing to what tables????

[dbtoo_dbtoo]

Hello

If we have nicknames created in DB1 to, say, three other databases
(DB2,DB3, and DB4) in the same instance. How can one find out what
table/database is a nickname pointing to?
For example, how do I know if a nickname called S1.nick1 in DB1 is
referencing DB2, DB3, or DB4?
DB2 Version: 7 or 8 Platform: AIX

Thanks

[Serge Rielau]

Try this for starters....got that from "back stage".

"The server name for a nickname is stored as a nickname option called
SERVER.

SELECT setting AS server FROM syscat.taboptions WHERE option = 'SERVER'
AND tabschema = '<my schema>' AND tabname = '<my nickname>'

You can join this with syscat.servers and syscat.serveroptions to get
more information about the server."

I would hope that TABOPTIONS hold more information (possibly the name of
the target?)

Cheers
Serge

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab