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

Look up "Federation" in the manuals.

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

Andy

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

Read Andy's reply again to make out the difference between Alias and Synonym.

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