IBM MQ Connector > Mappings and mapping tasks with IBM MQ Connector > IBM MQ sources in mappings
  

IBM MQ sources in mappings

To read data from IBM MQ, configure an IBM MQ object as the Source transformation in a mapping. Enable partitioning when you configure the Source transformation in the Mapping Designer to optimize the performance of the mapping task.
Specify the name and description of the IBM MQ source. Configure the source and advanced properties for the source object.
The following table describes the source properties that you can configure for an IBM MQ source:
Property
Description
Connection
Name of the source connection.
You can select an existing connection, create a new connection, or define parameter values for the source connection property.
If you want to overwrite the source connection properties at runtime, select the Allow parameter to be overridden at run time option.
Specify the parameter file directory and name in the advanced session properties.
Source Type
Type of the source object.
Select one of the following source types:
  • - Single Object
  • - Parameter
Default is Single Object.
Parameter
A parameter file where you define values that you want to update without having to edit the task.
Select an existing parameter for the source object or click New Parameter to define a new parameter for the source object.
The Parameter property appears only if you select parameter as the source type.
If you want to overwrite the parameter at runtime, select the Allow parameter to be overridden at run time option.
Object
Name of the IBM MQ source object.
Specify the source object that you want to use. You can also select an existing object from the list.
Filter
Not applicable.
Sort
Not applicable.
The following table describes the advanced source properties that you can configure for an IBM MQ source:
Property
Description
Destructive Read
Determines whether Data Integration permanently deletes messages from the source after it reads the messages.
If you select this option, specify the directory of the cache folder where you want to store messages in the Recovery Cache Folder field.
Default is disabled.
Realtime
Specifies whether Data Integration reads the messages from the message data component in real time.
If you select this option, Data Integration continues to read messages from the message data component and does not terminate the mapping.
Default is disabled.
To read messages in real time, select Source as the commit type and set a commit interval in the Advanced Session Properties section in the mapping task.
Recovery Cache Folder
The directory of the cache folder where the recovery files are created when the mapping runs with the Destructive Read option enabled.
The recovery file stores messages that Data Integration deletes from the IBM MQ source.
Specify the directory of the recovery cache folder in the following format:
/root/<folder name>/
Tracing Level
Determines the amount of detail that appears in the log file.
Select one of the following options:
  • - Terse
  • - Normal
  • - Verbose Initialization
  • - Verbose Data
Default is Normal.

Fixed partitioning

You can configure fixed partitioning to optimize the performance of mapping tasks when you read data from IBM MQ sources.
When you run a mapping task enabled for fixed partitioning, the Secure Agent distributes the source data across the partitions to read data in parallel based on the number of partitions that you specify in the Source transformation.
To configure fixed partitioning, on the Partitions tab, select fixed partitioning and enter the number of partitions based on the amount of data that you want to read. By default, the value is one. The maximum number of partitions you specify must not exceed 25.
The following image shows the configured fixed partitioning:
The configured fixed partitioning for the IBM MQ source in the Source transformation