In Classic event publishing, a publication associates
a source table or view with a WebSphere® MQ message queue. Messages
that describe changes to source data are put on that message queue. Applications
that need to be aware of the changes can read the messages from the message
queue.
Before you begin
- The source table or view for your publication must exist in the metadata
catalog of the data server where the correlation service will run.
- The table or view that you want to use as the source must be altered to
support change capture.
- You must know the name of the publication queue map with the send queue
that you want to use for the publication.
- You must have $VSAM authority or SYSADM authority on the data server where
you will store the information about the publication.
About this task
The
source table or view maps to a data source such as Adabas, CA-IDMS, CICS® VSAM, IMS™,
or native VSAM. When a change occurs to the data that is mapped to the source
table or view, Classic event publishing captures the change, converts it to
a message, and puts the message on the message queue, called a send
queue.
Publications are used only in Classic event publishing.
They are not used in Classic replication.
Procedure
To create a publication:
- In Classic Data Architect, open the New Publication wizard. In the Database Explorer, right-click the Publications folder
for the data server that you want to create the publication in. Select New
Publication.
- In the New Publication wizard, provide the following information:
- The name of the publication
- The schema and name of the table or view that you want to use as the source
for the publication
- The WebSphere MQ
name of the message queue to use as the send queue to transport messages for
the publication. The publication queue map that you select determines whether
the messages for the publication will be in XML, XML with a Java™ Message
Service (JMS) topic, or a delimited format.
- If you are publishing to JMS applications, the topic that you want to
send in the messages for the publication
- Whether to publish the before values in addition to the after values for
a data event
- For every row-level change, whether to publish values in changed columns
only or publish the values for all columns in the row
- Click Finish to create the publication.
The publication appears in the
Publications folder.
If the corresponding correlation service is running, right-click the publication
and select
Activate to start publishing messages.
If
you want to change the properties of the publication, right-click the publication
and select Update.