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.