DSXchange

Thanks Ray for your immediate response. Here i need your suggestion, 3. The UniVerse-based technology does not enforce the same number of columns in every record. In addition, it supports nested structures, which made UniVerse an ideal choice for storing DataStage design objects (not just job object...

Thank you guys for your witty responses. And here i pose a few more questions over your answers. 1. Is there anything like DataStage Server Engine Architecture Diagram so as to illustrate the Interfacing between DataStage GUI and UniVerse with the flow of BASIC Language. 2. Ray, RT_CONFIGnn contains...

Hello Everybody, I have a few questions about DataStage Server Engine(UniVerse). Questions: 1. How internally DataStage Server engine functions in the respect of UniVerse, Basic and DataStage? How these components are interacting with each other when a Server Job is designed and executed? 2. What ar...

Thanks Ray,

Here is link for those tools,

http://www.ibm.com/developerworks/forum ... 7&tstart=0[/url]

It is not ginving any error message. Our concern is slowness. Job is working fine. We want the job to process faster. I cant increase transaction count as it is message by message processing. It will create the duplicates at end if i do process in batch mode.

My job is designed as below. MQ --> XML input stage --> transfrmer --> funnel --> XML output --> transformer --> MQ We get around 2million records into the queue almost in less time. Our job not able to consume fast enough and MQ getting overloaded. Finally it job got aborted. When I checked the pro...

Its because of european character in data. I made it none in encoding format furing XML generation. Now issue is resolved. thanks

I have a real time job where MQ stages are source and target. Job structure: [img]MQ%20---%20XML%20input%20stage%20----%20transformer%20---%20XML%20output%20stage%20----%20transformer%20stage%20---%20MQ[/img] Source has 19000 records and in every run it posts 18999 records. XML output stage. MQ sour...

I can find one way as setting property "transaction record count" for target MQ stage as 0. By this means I can assure all the source records will be processed if job succeeds otherwise nothing. Is it right approach?

Hi Ray,
My source is dataset and target is queue. If job got aborted at 5lakh record level, at current settings of queue 5lakh messages are available.After reset I want job should start processing other data rather then all data available in source dataset.

I have a job with one dataset and MQ stage. Source dataset has 18lakh XML messages. Before job aborted there was 5lakh messages. Now after resetting the job, I want job should start processing from next messages. But job is now start processing from message one. This way we end up with duplicates in...

Yes, but if you have an output file created every 5 minutes then you only lose the last 5 minutes worth of statistics. If you need every row accounted then you have to implement other changes. If you continuously update the same file then you have to deal with operating system buffering and/or excl...

Write a DS function that outputs to a Sequential file the metrics you desire. Consider using a Common block to hold row counts as the job continously runs. Then, every hour output a file containing metrics for that hour. You can easily gather up the metrics for the day that way. The reason I would ...

I have job which has source and target as MQ. This job runs continuously 24*7. As the job never ends, we are not able to find the link count for the job as dsjob command returns 0. But I have a requirement where we need to find the number of records loaded in a single day. Can anyone give suggest on...

I have recompiled and tested it. Now no error. But not able to find the real cause.