var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: federated from AIX DB2 to WIN DB2
S1: AIX7.1 DB29.7 FP6
S2: WIN8 DB29.7 FP6
the same table(same records and schema) A in both server
When S2 federated to S1, the performace of doing the select nickname action(no join) is satisfied in S2 db.
While S1 federated to S2, the performace of the same action is so poor in S1 db that at least ten times slower than S2 federated to S1.
Beg someone's help?
How is the performance if you eliminate the federation (instead of running query on S1 and federating to S2 to get the data, run the query on S2)?