DSXchange

Hi,
I am facing similar issue with WebSphereMQ stage. With 2 node configaration it is reading twice the number of records. where as with one node it is working fine. I am still investigating the problem .

Regards.
Suman

Stopped usually only means through operator intervention - a stop request was issued. This might have been through a Terminator in a sequence. In that case, there will be an entry in the sequence lo ... Hi.. I am not talking about jobs getting stopped. I mean jobs are getting finished and the stage...

Hi, I have paralell job reading MQ messages using WebSphereMQ stage. working correctly with single node config file. But when i changed to 2nodes. Job is reading twice of MassageQuantity mentioned in the stage. I changed the config file just copying the node1 and pasting it again as node2. Am I doin...

Are all of these open connections to DB2 from DataStage and from this run? You certainly shouldn't have that many open from one DataStage run, as you've already stated with 1-node and 15 DB2 stages that is how many connections you should have. Is your Db2 partitioned? Sorry for a late reply. We sto...

Thanks Every one.

Issue got solved by increasing the size of APT_MAX_TRANSPORT_BLOCK_SIZE.

Regards,
Suman

Log seems to correct. Nothing out of ordinary. I also observed that this condition occurs randamly. and thers is no differnece in log when monitor was showing 'finished' and 'stopped' status for the stages.

Regards,
Suman.

Clarify what you mean by "stopped status". If you mean literally that, it could simply mean that someone clicked on "Stop" from the Director for that job. ... Hi, Thanks for looking into this. I mean job status is finished not stopped .but through monitor we can see the number o...

Hi..

some of my jobs ran with status 'finished'. But when I checked the monitor for these jobs,few of the job's stages are in stopped status and the data is not getting processed.

what could be the issue.

Regards,
Suman.

HI.. We are trying to read a huge XML message from WebSphere MQ connector stage. Data Element of Mesage ID is WSMQ.CORRELID and XML message is just read as varchar of 99999 size. Most of the messages were correctly read, but some XML messages are read in multiple records. NOt sure of whats going wro...

Hi, I am reading the data from Message Queue and loading into API tables. I am calling through the sequencer and sequencer has five subjobs. There are 15 DB2 API stages used across three jobs. I have processed 1000 messages as 10 differernt loads of 100 messages each. After the successful load, I ch...

We have Datastage engine installed in one LPar (say LparA) and the Information server is installed in other LPar(LParB). There were other two LPars installed for fail over. If LParA goes down, LParC will be up and similarly LParD will be substituted for LparB in case of failure. Iam new to datastage...

OOH :D
Correction. Thankyou for all your replies.

ray.wurlod wrote:

suman27 wrote:Thanks for all ur replies.

Ur? Ur was a city in ancient Babylon or thereabouts. The second person personal pronoun (possessive case) in English is spelled "your".

Hi..
Iam Pretty new to DataStage. Iam trying to build a re-usable job for my project.
Is there any way to papulate meta data at runtime, so that I can use the same job for different sources having different metadata.


Regards,
Suman.

Now I can able to validate my XML using a custom Java Code...
Thanks for all ur replies.

Regards,
Suman.

chulett wrote:Not all validators are created equal. We had to do our validation outside of DS using Java to match the level of 'checkness' that our consumer (Google) was expecting. ...

Hi Ernie, Thanks for looking into this, I am reading XML from MQ server, and I want my XSD location as parameter. Doing String operation on XML is good idea, But I am wondering if there is any option to add XSDpath in XML Input,XML Output or XML transformer stage. Regards, Suman. good point...here's...