Search found 250 matches
- Thu Mar 14, 2013 3:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Read from a MQ Cluster using the MQ Connector
- Replies: 0
- Views: 2154
Read from a MQ Cluster using the MQ Connector
Hi, How to connect to a MQ cluster to read messages using the MQ Connector stage? I have an MQ cluster consisting of 4 Queue Managers (QM) - to which Message Broker (MB) is publishing. DataStage job has to read the published messages and process them. The messages published by MB is available across...
- Fri Jul 13, 2012 4:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Publishing a Topic with a custom Message Type
- Replies: 0
- Views: 1677
Publishing a Topic with a custom Message Type
Hi, I have a Publish job using MQ Connector Stage in Client mode - set to use Publish/Subscribe mode, publishing records/messages with a Topic. When the Message Type is set to Default i.e, Datagram - everything works well and the messages are routed to the subscription queues correctly by MQ. But wh...
- Thu Apr 19, 2012 4:25 am
- Forum: General
- Topic: $DSHOME/bin not part of dsenv file
- Replies: 4
- Views: 3969
$DSHOME/bin not part of dsenv file
Hi, We have just moved over to version 8.5 and I see that $DSHOME/bin has not been included in the dsenv file. Typically I have seen the $DSHOME/bin always included as part of the PATH environment variable. How this was noticed was - a job sequence which was designed to call dsjob in a Routine Activ...
- Thu Nov 11, 2010 12:42 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: SAP CLUSTER TABLE SUPPORT IN ABAP Stage
- Replies: 2
- Views: 4283
Re: SAP CLUSTER TABLE SUPPORT IN ABAP Stage
Given that ABAP stage also does not support IN CLAUSE AS OF THIS TIME IN VERSION 8.0.0 ( engineering is working to fix that bug) I am curious if any one had experience of using cluster table and joining it with a transparent table. If you were to do this in a stand-alone ABAP program how would you ...
- Thu May 13, 2010 10:00 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Always-on job using MQ stages
- Replies: 22
- Views: 12521
- Wed May 12, 2010 4:42 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Always-on job using MQ stages
- Replies: 22
- Views: 12521
Works like a charm!!! Tested it out having the XML Output before the final queue as well, and it worked. Thanks for holding on till the end, Ernie. Now before I mark this as resolved, I have a couple of questions regarding the always-on topology. a) Prior to v8.x - can we not have an always-on Paral...
- Wed May 12, 2010 12:02 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Always-on job using MQ stages
- Replies: 22
- Views: 12521
- Wed May 12, 2010 9:15 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Always-on job using MQ stages
- Replies: 22
- Views: 12521
- Wed May 12, 2010 1:49 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Always-on job using MQ stages
- Replies: 22
- Views: 12521
Also tried these designs- 1. MQ------>XMLInput---------->Trx-------->Oracle Same result, with no data being written into the database. Had set options in the MQ stage - - Destructive Read - Commit/Backout only once at the end of the job As soon as a message comes into the queue, it disappears (which...
- Tue May 11, 2010 11:28 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Always-on job using MQ stages
- Replies: 22
- Views: 12521
- Tue May 11, 2010 6:31 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Always-on job using MQ stages
- Replies: 22
- Views: 12521
I have another question... more because of a post that talked of an IBM patch causing an issue - almost similar... The Message Limit in the MQ stage if set to 5 - and suppose the queue has only 3 messages, is it supposed to wait till there are 5 messages in the queue to write all of them together in...
- Tue May 11, 2010 3:39 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Always-on job using MQ stages
- Replies: 22
- Views: 12521
- Tue May 11, 2010 9:39 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Always-on job using MQ stages
- Replies: 22
- Views: 12521
Also tried out with an Oracle database at the target with commit frequency to 1 - nothing was written into table in the always-on mode. When the job is run with message limit set to 1, the record was written into the out queue as well as into the database. Still not getting a clue as to what is happ...
- Tue May 11, 2010 8:59 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Always-on job using MQ stages
- Replies: 22
- Views: 12521
Ernie, Set everything to 1 - rows per message and rows per transaction. Still the same result - i.e, no output seen in the queue. If I keep another link from the XML input straight to another Queue - the output from the XML input stage is written to this queue - but still nothing shows up in the que...
- Tue May 11, 2010 6:30 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Always-on job using MQ stages
- Replies: 22
- Views: 12521
Thanks for your time Ernie! Thats what I thought! Transformers have been in use for long time and a XMP input+Transformer seemed like quite a normal and regular requirement for an always-on job (any job for that matter). But eow was the only issue I could think off, why messages were not getting wri...