You can configure sessions to stream the XML between the WebSphere MQ sources and the XML Parser transformation. When the PowerCenter Integration Service streams XML data, it splits XML data from the MQ Source Qualifier into multiple segments. You can configure a smaller input port in the XML Parser transformation and reduce the amount of memory that the XML Parser transformation requires to process large XML files. The buffer pool size is from 50 to 100 percent smaller, depending on message size.

When you enable XML streaming, the XML Parser transformation receives the XML data in memory. The PowerCenter Integration Service compares the XML file size to the transformation input port precision. If the XML file is larger than the port precision, the PowerCenter Integration Service divides the data into rows that are less than or equal to the port precision. The PowerCenter Integration Service sets each row type as streaming except for the last row. The last row has a row type insert.

If you enable XML streaming for the WebSphere MQ message, you must also enable it in the XML Parser transformation.

To enable XML streaming for WebSphere MQ: