Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2011

    Unanswered: Federation in DB2 9.7 UDB

    I have two databases, b1 and b2. and want to access tables present in b2 from b1.So I created nicknames in b1 for tables present in b2(before this I completed necessary steps like creating wrapper,server,user mapping)

    Now the problem is password for database b2 has been not able to access tables in b2 through nicknames created in b1,getting authorization error.

    I gave instance username and password while creating user mapping and now instance password has been changed. Both databases in the same server.

    Can anyone suggest me, Whether I need to reset password for user mapping using alter command or what else need to be done?

    Thanks in advance

  2. #2
    Join Date
    Jun 2003
    Toronto, Canada
    Provided Answers: 1
    Check out the ALTER SERVER command in the manual.
    "It does not work" is not a valid problem statement.

Posting Permissions

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