PowerExchange for WebSphere MQ User Guide for PowerCenter

10.5
- 10.5.7
- 10.5.6
- 10.5.4
- 10.4.0

Back Next

Configuring a Session with a WebSphere MQ Mapping

When you configure a session with WebSphere MQ sources or targets, set the following session properties:

Set the connection type and value for WebSphere MQ sources and targets.

Define session properties for associated source qualifiers for WebSphere MQ sources.

Define session properties for static WebSphere MQ targets.

You can also set the following session properties:

Commit type and interval

Filter conditions

Message recovery

Millisecond flush latency

Pipeline partitioning

To configure session properties for a WebSphere MQ session:

In the Task Developer, double-click a WebSphere MQ session to open the session properties.

From the General Options on the Properties tab, optionally edit the commit type.

Select Source as the Commit Type in the following cases:

To specify how the PowerCenter Integration Service writes XML data to WebSphere MQ targets.

To run the session in real time using the FlushLatency(n) function in a filter condition.

To configure transactional consistency for MQ Series targets.

Optionally, edit the commit interval.

To specify how the PowerCenter Integration Service writes XML data to WebSphere MQ targets, and you set Source as the Commit Type, you must set a Commit Interval value.

Select a recovery strategy.

To enable message recovery or if you are configuring the session for resilience, select Resume from Last Checkpoint.

If you enable message recovery, you can configure a value for the recovery cache folder from the Properties settings of the Mapping tab (Sources node). Or, use the default cache folder $PMCacheDir\.

Click the Mapping tab.

From the Connections settings on the Mapping tab, select a connection type for each source definition.

Select

None

to connect to the associated source definitions, such as VSAM or flat file.

Select

Queue

to connect to the MQ Source Qualifiers.

In the Value pane, select a connection value for the MQ Source Qualifier.

If you want the PowerCenter Integration Service to try to reconnect to the WebSphere MQ queue if the connection fails, select a Message Queue connection object that has a positive value for the Retry Connection Period property.

From the Properties settings on the Mapping tab (Sources node), verify the following settings for associated sources:

Source File Directory
. Use the default value.

Source Filename
. Use the default value.

Source Filetype
. Set to Direct.

Click the Targets node.

From the Connections settings on the Targets node, select a connection type for each MQSeries target definition:

For static MQSeries target definitions, set the connection type to Queue.

For dynamic MQSeries target definitions, the connection type is set to Queue.

To specify how the PowerCenter Integration Service writes XML data to WebSphere MQ targets, select Queue as the connection type for XML target definitions in the mapping. If you want to configure the session for transactional consistency, verify that all WebSphere MQ targets in a single pipeline belong to the same target connection group.

In the Value pane, select a connection value for each target definition.

If you configure the session for transactional consistency, verify that all dynamic WebSphere MQ targets in a single pipeline belong to the same target connection group.

From the Properties settings, optionally select Destructive Read to remove messages from a queue when you enable message recovery and specify the recovery cache folder.

If you select Destructive Read, the mapping cannot contain an associated source qualifier. If the mapping contains an associated source qualifier and you select Destructive Read, the mapping becomes invalid. To remove messages from a queue for a mapping that contains an associated source qualifier, enter the RemoveMsg(TRUE) function in a filter condition.

Optionally, select Millisecond Flush Latency to process flush latency in milliseconds.

Optionally, click the right corner of the Filter option to enter a filter condition.

Enter the filter conditions. Click OK.

When you enter a value for the MsgCount(n
), Idle(n
), FlushLatency(n
), or ForcedEOQ(n
) functions, enter 0 or a positive value. Otherwise, the PowerCenter Integration Service ignores the filter condition.

Enter a recovery cache folder if you selected Destructive Read.

From the Properties settings on the Mapping tab (Targets node), verify the following settings:

Output File Directory
. Use the default value.

Output Filename
. Use the default value.

Click OK.

Creating and Configuring WebSphere MQ Workflows Overview

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal