DSXchange

Hi, I would appreciate your inputs on how to get the filenames that are selected by a sequential file stage in an output store (Peek stage for now) Here is what I am trying to do in a test job. This is an RCP enabled job. SequentialFileStage ==> Peek Sequential file stage is set to read using "...

4Friends,

Is this what you are trying to do...?

Read from DB2 ==> Any applicable data transform(s) ==> Write to Oracle

Hi Amit/Deepthi (I presume both are in the same team), We had this exact issue in a new LINUX server and it went through several iterations with the UNIX team, Mail support team and all that jazz. Like Craig said, you need to make sure the OS sendmail command works without any issues. This can be ea...

Roy, How was the metadata (XML Table Definition) created. Did you use an XSD to create your Table definition or did you use the XML itself to create the table definition. Like Ernie said, your XPath expressions, if not laid out correctly, might have issues when parsing the input file and emitting th...

Hi Roy, I think, this should ideally be in the Parallel thread. Anyway, check out http://www.dsxchange.com/viewtopic.php?t=116649 http://www.dsxchange.com/viewtopic.php?t=114855 You are probably hitting the Namespace related issue in Version 8.0 that ernie has mentioned several times in various thre...

This is my first attempt at putting together the various different jobs I have been working on into a sequence. So pardon my descriptive post. To start with, the high-level requirement is as follows. Various providers supply feed files at FTP sites. One provider might provide 3 files whereas the nex...

Hi Craig, Group, I should have mentioned this earlier - apologies. We recently got a new Linux Grid environment and I tried this job over there about 2 weeks ago. The only difference I saw was that it ran for about 4 hours before giving up on memory. In the Windows server I would have a failure with...

It will be helpful to understand what your feedback might be for Craig's question about the directory name part of your file name. Are you trying to have a job parameter for the folder name? Check out http://www.dsxchange.com/viewtopic.php?t=115830&postdays=0&postorder=asc&highlight=exte...

Hi lstsaur,
Thanks for the followup. There are folks that can handle XML via Java. I can give it a shot myself with some refresher/reading.
Let me know your thoughts/suggestions.

Thanks for your time.

Hi Kumar66, Could you provide some additional details about the server configuration? What is the CPU, RAM, Page File limits et al? Based on feedback from IBM Support on an issue that we had in an EE job, it was stated that XML Input stage in Datastage uses DOM Object model to load the entire XML in...

Hi Group, After a longggg journey of support tickets, page file adjustments, testing and feedback, we have decided to take a workaround approach - a few approaches, actually. 1. Convert the input XML to a delimited text in a pre-processing stage (PERL script that parses the file in SAX model and gen...

While closing the thread, if you could also throw some light on how you fixed this issue, it will be of help for "future" generations.

Cheers!!!

Hi Ray, Team, Wanted to give an update on this item. I submitted this to IBM Support late yesterday, just in case, we missed something on the configuration. Here is what was suggested. From DOS, go into the "PXEngine\java" directory of the information server datastage server. Then perform ...

Hi Ray, First the Server Vs Parallel category posting - my apologies for the confusion. Before posting the query, i looked at the description of the forums and saw "Job Sequences" belonged to "IBM(R) DataStage Server Edition" category and posted it there. I mentioned RCP because ...

Ray, Thanks for the followup. Appreciate your time. I reviewed the job once again and can confirm that I have checked "Include job status in email" checkbox in the Notification tab of the Notification stage. The rest of the SMTP parameters are all setup correctly. Here is what i got in the...