var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Accessing tables across the servers
How to access tables across the server in db2 9.7?
For eg: I have server1,have tables like table1 and table2 and a query like:
select a.col1,a.col2 from table1 a join table2 b on a.col1=b.col1
In another server server2, i need to execute same above query but tables will not be present in this server.
So can we access tables present in server1 from server2, if yes what is the procedure to do that? Is there any server linking facilities in db2?
Yes, this is called FEDERATION in db2.
You setup federationk, create servers, wrappers, mappings, nicknames...