472,805 Members | 1,018 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,805 software developers and data experts.

Nicknames are pointing to what tables????


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

Nov 12 '05 #1
1 2233
Try this for starters....got that from "back stage".

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

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?)


Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: global | last post by:
Hi, we have UDB 8.1.4 on W2K and defined federated database with nicknames, which cann't be seen in control center. (filter is not activ). Thx
by: db2sysc | last post by:
We have defined a NICKNAME to go to Mainframe table and when do a SELECT * FROM NICKNAME from a version 8 client we get SQL0101N error. The same select from V7 client works fine. The SELECT...
by: _link98 | last post by:
On Linux or Solaris with UDB 8.2.2, can an SQL/PL stored-procedure use two-phase-commit with nicknames and if DB2 provides the Transaction-manager? i.e. in the same transaction, can an SQL/PL...
by: Asphalt Blazer | last post by:
Hi, This problem seems to be trivial but yeah its happening to me. I am trying to drop a nickname db2 "drop nickname <schemaname>.<tablename>" after I execute the command, the cursor just hangs...
by: mailforpr | last post by:
How do I do that? The thing is, the only information I have about the iterator is the iterator itself. No container it is belonging to or anything. Like template<Iteratorvoid...
by: Prasad | last post by:
Hi, We have DB2 version 7 fixpak 14 on AIX 5.1. We have nicknames to another RDBMS tables. These nicknames have views and specification only indexes. I would like to know how we can extract...
by: ebusiness | last post by:
I am trying to create nicknames for tables in a remote database. The federated database and remote database are both DB2 UDB V8.2, both OS are AIX. Could anyone tell me how to create a nickname...
by: VikingDK | last post by:
Hi all Please bear with me, I'm still very inexperienced when it comes to DB2, so my questions might seem a little silly. With that covered, now on to the question :) I have a DB2 Enterprise...
by: DataFinder | last post by:
Not wanting to re-create the wheel, I have a need for a two-column table that links nicknames and given names if they are a derivative or source of another. Can you help? Using an Access...
by: linyimin | last post by:
Spring Startup Analyzer generates an interactive Spring application startup report that lets you understand what contributes to the application startup time and helps to optimize it. Support for...
by: erikbower65 | last post by:
Here's a concise step-by-step guide for manually installing IntelliJ IDEA: 1. Download: Visit the official JetBrains website and download the IntelliJ IDEA Community or Ultimate edition based on...
by: kcodez | last post by:
As a H5 game development enthusiast, I recently wrote a very interesting little game - Toy Claw ((http://claw.kjeek.com/))。Here I will summarize and share the development experience here, and hope it...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Sept 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
by: Rina0 | last post by:
I am looking for a Python code to find the longest common subsequence of two strings. I found this blog post that describes the length of longest common subsequence problem and provides a solution in...
by: DJRhino | last post by:
Private Sub CboDrawingID_BeforeUpdate(Cancel As Integer) If = 310029923 Or 310030138 Or 310030152 Or 310030346 Or 310030348 Or _ 310030356 Or 310030359 Or 310030362 Or...
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
by: lllomh | last post by:
How does React native implement an English player?
by: Mushico | last post by:
How to calculate date of retirement from date of birth

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.