Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2013
    Posts
    1

    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?

    Thanks.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    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)?

    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
  •