Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Posts
    1

    Wink Unanswered: triggers & remote database

    I'm on DB2 8.1 WG and I'm wondering about propagating data to a remote DB system that's already cataloged in the db directory. Is it possible to use a simple trigger to do this? If not, what's the best way to do this? DB2 replication?

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    When you say that the remote DB is cataloged in the DB directory, do you mean through Ferderation or that there is just an entry in the DB catalog (LIST DB DIRECTORY). If the system is Federated then triggers will work for this. If not, the trigger would need a connection to the remote DB, which it cannot do. You will need to use Replication for this scenario.

    If you potentially might have more than 1 remote DB to copy the data to, I would strongly suggest you use Replication.

    Andy

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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