Adapter type: wsmq_out. The default WebSphere MQ Output adapter publishes a string in CSV format.
The WebSphere MQ adapter does not produce a header line because the schema of the stream publishing to the adapter determines the order and datatypes of the fields. Columns are published in the default display format for the appropriate datatype. The adapter prepends stream names and opcode instructions (insert, delete, update, upsert) to CSV data added to a queue. See the prependStreamNameOpcode property.
To run the adapter successfully in Linux and UNIX installations, set the LD_LIBRARY_PATH to point to the MQ client libraries to run the adapter successfully.
If you use the CCL ATTACH ADAPTER statement to attach an adapter, you must supply the adapter type.
Property Label | Description |
---|---|
Queue Name |
Property ID: QueueName Type: string (Required) Name of the queue on the server to send messages. This queue must be managed by the indicated Queue Manager Name. No default value. |
Queue Manager Name |
Property ID: QueueManagerName Type: string (Required) Name of the queue manager on the server to send messages. No default value. |
MQ System Name |
Property ID: SystemName Type: string (Required) Name of the MQ server system. This may be a symbolic name or an IP address. No default value. |
Port |
Property ID: Port Type: string (Required) Port number on the MQ server system to which the MQ server queue listener is attached. No default value. |
MQ Channel |
Property ID: Channel Type: string (Required) Name of the MQ server channel associated with the queue. No default value. |
CSV Field Separator |
Property ID: CsvSeparatorChar Type: string (Optional) The CSV field separator. Specify a single character. Default value is a comma ( , ). |
CSV Escape Character |
Property ID: CsvEscapeChar Type: string (Optional) The character to escape the meaning of special characters, including the field separator, escape character, and quote character. Default value is a backslash ( \ ). |
CSV Quote Character |
Property ID: CsvQuoteChar Type: string (Optional) The character to delineate the beginning and end of a field, which can include anything. Any embedded quote characters are escaped. Default value is a double quote ( " ). |
Include Base Content |
Property ID: outputBase Type: boolean (Optional) If set to true, the adapter outputs the initial stream contents in addition to stream updates. If this option is enabled and the adapter is running in GD mode, once the adapter has done a GD commit on the entire base data, the ESP Server does not redeliver the base data on adapter restart and only sends deltas that are saved for delivery. The default value is false. |
Prepend Stream Name, Opcode |
Property ID: prependStreamNameOpcode Type: boolean (Advanced) If true, every CSV record is prepended with stream name and an opcode. Default value is false. |
Timestamp Column Format |
Property ID: TimestampColumnFormat Type: string (Advanced) The format for timestamp values. Default value is YYYY-MM-DDTHH:MM:SS.SSS. |
Date Column Format |
Property ID: DateColumnFormat Type: string (Advanced) The format in which date values are stored in the file. Default value is YYYY-MM-DDTHH:MM:SS.SSS. |
Runs Adapter in PSP GD Mode |
Property ID: enablePSPGDMode Type: boolean (Advanced) If set to true, the adapter runs in persistent subscribe pattern (PSP) guaranteed delivery (GD) mode and all GD-related parameters become required. Default value is false |
Name of Column Holding PSP GD Key |
Property ID: gdKeyColumn Type: string (Advanced) Specifies column name in the Flex operator holding the PSP GD key. The GD key is a constantly increasing value that uniquely identifies every event regardless of the opcode in the stream of interest. No default value. |
Name of Column Holding opcode |
Property ID: gdOpcodeColumn Type: string (Advanced) Specifies name of column in Flex operator holding opcode. The opcode is the operation code (for example, inserts, update, or delete) of the event occurring in the stream of interest. No default value. |
Name of Truncate Stream |
Property ID: gdControlStream Type: string (Advanced) Specifies name of the control window in the GD setup. The control window is a source stream that informs the Flex operator of which data has been processed by the adapter and can be safely deleted. No default value. |
Purge After Number of Records |
Property ID: gdPurgeInternal Type: int (Advanced) Specifies number of records after which to purge the Flex operator. Default value is 1000. |
Batch Size to Update Truncate Stream |
Property ID: gdPSPBatchSize Type: int (Advanced) Specifies number of records after which the control window must be updated with the latest GD key. Default value is 1000. |
Delay Between Reconnection Attempts |
Property ID: reconnectAttemptDelayMSec Type: int (Advanced) Number of milliseconds between attempts to reconnect to the WebSphere MQ server. Default value is 1000. |
Maximum Number of Reconnection Attempts |
Property ID: maxReconnectAttempts Type: int (Advanced) Number of attempts at reconnecting to the WebSphere MQ server before stopping. Use -1 to retry an unlimited number of times. Default value is 1. |
PropertySet |
Property ID: propertyset Type: string (Advanced) Specifies the name of the property set. Property sets are reusable sets of properties that are stored in the project configuration file. Using these sets allows you to move adapter configuration properties out of the CCL file and into the CCR file. If you specify the same properties in the project configuration file and the ATTACH ADAPTER statement, the values in the property set override the values defined in the ATTACH ADAPTER statement. No default value. |
Runs Adapter in GD Mode |
Property ID: enableGDMode Type: boolean (Advanced) Specifies whether the adapter runs in guaranteed delivery (GD) mode. GD ensures that data continues to be processed in the case that the ESP Server fails, or the destination (third-party server) fails or does not respond for a long time. See Guaranteed Delivery in the Event Stream Processor Programmers Guide for details on enabling GD for your project. The default value is false. |
Enable the Adapter Internal Cache Mode |
Property ID: enableGDCache Type: boolean (Advanced) If set to true, only rows that can be recovered (that is, checkpointed) by the ESP Server on restart are sent to WebSphere MQ. Other rows are cached internally by the adapter. When this option is enabled, you may see a significant increase in latency depending on how frequently the attached stream delivers checkpoint messages. Streams support three modes related to GD: GD not supported, GD supported, and GD supported with checkpoint messages. This setting is ignored if the attached stream does not support GD and does not deliver checkpoint message. The default value is true. |
GD Batch Size |
Property ID: gdBatchSize Type: int (Advanced) Specify after how many message blocks (transactions or envelopes) the adapter issues a commit command to WebSphere MQ and a GD commit to the stream to which the adapter is attached. The default value is 10. Increasing this value improves performance at the expense of latency (specifically, how soon rows are available in WebSphere MQ to be consumed by other applications. Increasing this value also increases memory consumption in the ESP Server because the uncommitted rows need to be preserved for redelivery in case of failure. |