DSXchange

The issue is that in the sequence the stage names have to be different for each call so I am unable to retrieve the log from the second stage name as it not the same as the underlying job I'm a little lost by this. There's no requirement that any stage has any kind of meaningful name, and I've seen...

1. Restore your UNIX level backup. Not just any individual project directories but the 'entire' DataStage installation. 2. From your support provider or direct from IBM. Yes, it will be free as long as you are under a maintenance agreement. 3. Suprisingly, it's already been done by the vendor. You'l...

but instead of terminator stage what i will suggest is let the otherwise link from all job activity go to sequencer and for 'Any' option. after that you put a routine activity stage and then use the routine UtilityAborttoLog routine in routine--->SDK---->Utility.. This is better i think rather make...

So, what database are we talking about here? What stages are you currently using? Array Size? Transaction Size?

More specifically, are you aware that you need to include an 'Invocation ID' when starting a multi-instance job to allow more than one instance to run at the same time? This can be pretty much any continuous alphanumeric value, as long as it is unique per run. And you specify it via dsjob by appendi...

Searching on the topic of 'dsadmin' would turn up your answer. Or, to throw the lazy dog a bone:

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

One such example.

If you're just using cron/Director for that, no wonder it is becoming a problem. We use Control-M, but any kind of Enterprise Scheduler would simplify your life.

Right, in pre-8 releases that would be in the Manager.

Not knowing XML will make the behaviour of the XML stages rather... mysterious. Some kind of 'dummies' / introductory book may be in order. From a 'how to' in DataStage, while you could read the 'PACK' documentation installed on your pc, you'd be much better off (IMHO) if you read the Best Practices...

#Include the DB2 libraries into the LIBPATH AIX or LD_LIBRARY_PATH for SUN and Linux
LIBPATH=$LIBPATH:$DB2DIR/lib64;export LIBPATH

This looks to be an issue. Try pointing to the 32bit libary rather than the 64bit one.

Oh Bejeebus, sucked back in again. Well Chulett, Of course. However, like most of the time, there's more than one way to skin this cat. All I was attempting to point out was that (in my opinion) the focus on just warnings was too narrow, but that rather you should handle all outcomes outside of the ...

ag_ram wrote:chulett,

Can we now add that Enviroment variable in the project using Administrator.

Of course. That's how one would add any environment variable to a specific project.

Dunno if this adds any value to the discussion but there is an option in the sequential file stage that's titled: "Clean up on Failure" which is defaulted to true. Setting it to false may give you some data in the file. Actually, it does. Thank you for posting that. I assume 'clean up' in this case...

'The first man'? Dude, it's just you and Ray (as usual) going back and forth. And at this point it's just annoying when you drag threads off on tangents like this. Why don't we setup an Ram Ruminations topic over in the General forum? That way, when you want to do things like this, you can simply li...

Cannot be more than one passed in, actually. So use a delimited list (pipe, perhaps) and then parse out the components inside the routine.