DSXchange

kcbland wrote:I've got a good document describing divide-n-conquer job design if you want it.

Is there anywhere on the site where people can upload stuff like that? Can there be? More of a question for Dennis or Walter, I 'spose...

If 'invoke' means 'use', you need to have the 390/Mainframe version of DataStage in order to be use certain stages and some are specific to the PX version. You can tell which stages below where by looking at their backgrounds in the online help. They'll be a different color than Server stages and wi...

Also a sequencer can do much more than a batch viz. parallel job running ,running before and after routines etc. In addition to what Ray and Vincent said, I just wanted to emphasize that your statement above is incorrect. Maybe someday Sequence jobs and the GUI that supports them will approach the ...

Very nice... and so simple.

You have to 'detach' the job when you are done. Sounds like you are missing that step.

Be patient, it won't 'hang' for as long as opening the Log view would. Bringing up the Log requires that all zillion rows be brought up to your PC, while doing it from the Status view only requires it to find the oldest entry so it can give you an idea how much you will be purging. Give it some time...

There's a big difference between a job that says it is running versus one that actually is. If you've rebooted the DataStage server than your job, she ain't running. It is just a flag and it says it is 'Running' because it never heard back that the job ended. Use the 'Clear Status File' command from...

Don't you already have a thread open on this subject?

Let me second what Ken said. Control-M doesn't give a hoot if it is starting a Sequencer job, a Server job or hand-rolled Job Control, it is all the same to the dsjob command. You need the functionality that Sequences and Job Control give you, Control-M can't help with passing job parameters, diggin...

kcbland wrote:Here's a copy of a shell script I use:

http://www.dsxchange.com/viewtopic.php?t=85578

You might want to save that for the Advanced Class, Ken.

Which is it, 6x or 7x? Do you know how to update an existing record with new information? Not really all that different. Pull all existing relevant information into a Hash and use it as a Reference Lookup. Insert or Update from there. How much of an 'example' do you need? Is that enough to get you g...

There is a Command Line utility called dsjob which is used to invoke DataStage jobs from, amongst other things, Enterprise Schedulers like AutoSys. Search the forum, it has been discussed rather thoroughly here. As in a lot. There is a section in the Server Job Developers Guide dedicated to it, look...

Well, right off the bat there's one thing that jumps out at me... You said your SMTP sever is abc.mot.com but in your example of the error you are showing abc@mot.com instead. Note that there is a DSSendMail testing routine in the 'sdk' category, from what I remember. It is the easiest place to make...

If running DataStage on it is a make-or-break decision for you, I'd try to contact Ascential ASAP and see if it will install or not before you potentially 'waste' your money. If it's just a 'gee it would be nice' kind of thing, then... well, let us know. What kind of horsepower does one of those thi...

Yah, I really doubt it. It won't even install on a pc with XP Home as it requires XP Pro and checks for it. It's not the old - hey, it's not supported but go ahead and try it, it may work - as I said, it blocks the physical install.