When you write XML message data to WebSphere MQ, you can use the On Commit property in the XML Generator tab to specify how the PowerCenter Integration Service writes the XML data.

You can select the following values for the On Commit property:

When you select Create New Document, select Source as the commit type and set a commit interval in the session properties. The PowerCenter Integration Service commits data to the target based on the number of records in an active source. When you set a commit interval, the PowerCenter Integration Service commits data to the target based on the number of records you specify.

The commit interval also specifies the number of second-level nodes in the XML document that you write to a WebSphere MQ message. The number of second-level nodes corresponds to the number of records in the source data. The commit interval you set determines how many second-level nodes the PowerCenter Integration Service writes to a WebSphere MQ message.

For example, if the source data contains 12 records, and you set the commit interval to 4, the PowerCenter Integration Service creates three separate XML documents. Each document contains four second-level nodes to three WebSphere MQ messages. If you select Create New Document, each of the three XML documents are complete XML documents.

When you configure a session to create a single XML document on commit to WebSphere MQ, the PowerCenter Integration Service generates an extra XML document at the end of the session. It writes the XML document to a WebSphere MQ message.