DSXchange

Did you check to see if the directory containing the library file is on the library search path? That's what the error suggests is the likely problem.

Second one should be set to 'Otherwise' unless you were purposefully wanting the overlap between the two.

Make sure you use the exact search option with an appropriate string, the others are a little... limited.

Ray, for your last suggestion - won't all the jobs still run in a serial fashion? The Job Activity stage forces a wait, so nothing in the sequence will happen until the first job finishes at which point the second will start. Yes? :? I'm remembering several conversations on this topic here over the ...

pavankvk wrote:which behavior is correct 8.1 or 11.3?

Short answer? 11.3

'Same' as in exact same database or they are two different databases but set up exactly the same? Where exactly is this CHAR(2) in your job? I'm more surprised to hear it doesn't get padded with 'an extra space' in DEV than it does happen in PROD. That's the nature of CHAR fields, they automatically...

Never mind about the Toolkit reference, that was only valid on a Windows server. Since you are on a UNIX one, you have the Power Of Shell Scripts at your disposal! Is there anyone you work with that can help you with crafting one? It's not something to pick up from a forum post or two, unfortunately...

I don't believe that affects Server jobs at all...

Are these actually Server jobs? Do you have this issue with all Oracle sources or just literally when you select something from DUAL?

Is your ETL server truly on Windows? If so that would mean a DOS batch file, something that's not my strong suit. Or (question to the general audience) can one still craft shell scripts and take advantage of the MKS Toolkit to run it? The problem with dumping them all in a Sequence job and using the...

All it needs to do is run all 40 jobs at once. Are you sure this is wise, as in you've done this before and you know your system can handle it? :? If literally all you need to do is start 40 jobs and not have any monitoring in place, I'd look into scripting a loop around dsjob. Iterate through a li...

Don't have any thoughts on the first question right now but the second about making sure a job is in a runnable state - how are your scripting skills? Typically one would build a 'wrapper' script to run any DataStage job and part of that would to be check the current status of the job using -jobinfo...

The 'delay' you are seeing is the amount of time from when the request to start the job was made and when it actually started. This log entry matches up with the summary: Item #: 4 Event ID: 423 Timestamp: 2015-08-22 00:13:45 Type: Info User Name: dsadm Message Id: IIS-DSTAGE-RUN-I-0019 Message: LD_...

Moved.

So... this is a QualityStage topic?