How can we convert MQ Stage to MQ Connector?

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
g_rkrish
Participant
Posts: 264
Joined: Wed Feb 08, 2006 12:06 am

How can we convert MQ Stage to MQ Connector?

Post by g_rkrish »

we trying to use MQ connector for our Parallel jobs is any specific steps or any thing need to be followed to convert the MQ stages to MQ Connector stage.Also can MQ connector can be used in Server job.
RK
eostic
Premium Member
Premium Member
Posts: 3838
Joined: Mon Oct 17, 2005 9:34 am

Post by eostic »

Nothing in particular.....the MQ Connector can do a lot more things, but most of them have specific purposes......If your job is "working", there should be no reason to change it. Here are some of the more significant reasons someone might move to the connector:

It can do both MQ client and MQ Server api's. MQ Plugin requires a choice at install time for one or the other.

It can send end-of-wave signals on its own when it is a source. MQ Plugin cannot, and would require the end-of-wave operator afterwards....

MQ Connector can work with DTS to provide ensured delivery from a queue to a database table.

Making the change is fairly easy ...I would suggest playing with the connector in a test job, reading queue messages, writing them, until you are comfortable with how it works.

Ernie
Ernie Ostic

blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
g_rkrish
Participant
Posts: 264
Joined: Wed Feb 08, 2006 12:06 am

Post by g_rkrish »

Ernie,

I am trying some simple audit job with audit queue it is connecting by server mode and it has no problem in opening the queue in partiotion wise it is showing up the error saying

There are irreconcilable constraints on the number of
partitions of an operator: parallel TestctrSendAuditPXC313.WebSphere_MQ_Connector_7.
The number of partitions is already constrained to 4,
but an eSame partitioned input virtual dataset produced by
parallel TestctrSendAuditPXC313.XML_Output has 1.


Mq connector get it from the xml o/p stage

But we have specifed as 4 node partions in all our stages is anything specific needs to be done for the MQconnector stage or it takes project default.
Last edited by g_rkrish on Thu Jun 24, 2010 6:01 am, edited 1 time in total.
RK
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

I got 17 other matches when I did an exact search for "There are irreconcilable constraints on the number", perhaps one of them will help you out.
-craig

"You can never have too many knives" -- Logan Nine Fingers
g_rkrish
Participant
Posts: 264
Joined: Wed Feb 08, 2006 12:06 am

Post by g_rkrish »

chulett wrote:I got 17 other matches when I did an exact search for "There are irreconcilable constraints on the number", perhaps one of them will help you out.
sorry Criag I forgot the search before posting anyways will the propagte options need to be clear? any reason behind it or any thing need to be configured for MQ connector stage.
RK
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

I have no clue, never having used MQ anything. Just wanted to point out that others have seen that message and there are Resolved posts on the subject. If that's the advice you're finding, give that a shot and see if it indeed fixes it for you.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply