Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2007
    Posts
    49

    Unanswered: DB2 - Create Alias locally for a remote table

    Hello All

    I Work in DB2 on AIX Platform. I would like to create an alias on my local system for a remote table on AIX.

    Can some one tell me how ?

    If the remote table is dropped what will happen to the local alias ? Can I Access the data in the local alias ?

    Can some one let me know please

    Thank You
    Neharao

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Look up "Federation" in the manuals.

    If the remote table is dropped, you alias will fail when it is accessed.

    Andy

  3. #3
    Join Date
    Dec 2007
    Posts
    49
    Then what is the advantage of creating alias as such ..!

    Request you to correct me if I am wrong in the below two
    • When a table is dropped alias which resides locally and it is not dropped
    • When a table is dropped synonym is also dropped

  4. #4
    Join Date
    Apr 2005
    Location
    USA
    Posts
    130
    Read Andy's reply again to make out the difference between Alias and Synonym.

  5. #5
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    You really need to read the manuals on Federation to understand it properly.

    It work like this:

    You have 2 servers S1 and S2, and a table T1 on S1.

    S2 has a nickname F1 that is a federation link to T1, so queries against F1 on S2 are automatically routed to S1 to read T1, and the result is sent to S2 to return to the client. As far as S1 is concerned, S2 is just another client. So if T1 is dropped, S1 does nothing more. Then when F1 is accessed again on S2, it will fail because T1 no longer exists.

    Andy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •