Creating publications

With Event Publishing, you can publish changed rows or transactions from a source table to a user application by creating publications.

Each publication is a single object that identifies:

  • The source table that you want to publish changes from
  • The columns and rows from the source table that you want to be published
  • The publishing queue map, which names the IBM® MQ queue that changes are published to

In Event Publishing, you can create one or multiple publications at one time.

Attention: Publications are separate objects from Q subscriptions. Publications do not publish data to the Q Apply program, but to an application of your choice. Publications are for publishing data, and Q subscriptions are for replicating data. If you want to replicate changes from a source table and want the Q Apply program to apply those source changes to a target table or pass them to a stored procedure for data manipulation, create a Q subscription, not a publication.

The following topics explain how to create one or many publications and further customize the publications based on your business needs.