DSXchange

thanks for the reply but it really does not address my question at all.

I'm not attempting to run sequencer.sh but rather an in house developed shell script. The priimary goal is to get the script to run on a compute node rather than the head node.

When running on a grid, what is the best way to execute a shell script to ensure that it will run on an available compute node rather than the head/conductor node? I tried using the exec_command activity in a sequencer, but that executes the script on the head node and never even calls the load leve...

What I like to say about RCP is:

If you know what it is doing, it is doing it FOR you, If you don't know what it is doing, it is doing it TO you

Unfortunately I've not used the CFF stage much either, but like Craig have quite a bit of experience with mainframe and variable lenght files. My only contribution to the conversation at this point is to say that the 4 bytes at the beginning of the variable length record are not always apparent when...

Ray, Thanks for the reply. I agree the stop button in Director should normally work; but in those rare cases like sometimes happens in small retail companies like you work in, I'm sure there are times when what normally or should work... simply doesn't work. In one of those cases, what steps should ...

Personally, I prefer the method you are taking instead of using the auto partitioning that has been previously recommended. Yes, Auto normally works, but I like to be as explicit as possible. It ensures that the developer has considered sorting and partitioning thoroughly. As to why your job suddenl...

Are there any special considerations when sttempting to stop jobs on a grid? I've seen several posts on here regarding how to stop and how not to stop DataStage jobs. And, I know kill-9 falls in the center of how NOT to stop a job. What I have not seen is anything that mentions if there are special ...

Are there any special considerations when killing a job that is runnning on a grid?

What is the proper sequence of steps to use to kill a job running on a grid that seems to be hung? (i.e. does not respond to a stop request from Director)

start with setting environment variable APT_DISABLE_COMBINATION to true to determine in which stage the problem is occurring

You should also try surrounding the password with quotes. Unfortunately I don't remember if it requires single or double quotes.

I've just received the following error in a Trasnsform stage: Xfm,5: Field 'HOURS_FLAG' from input dataset '-1' is NULL. Record dropped. The problem was resolved with a simple restart of the job, but, I don't recall seeing "dataset '-1'" before. What would the '-1' represent The job is a s...

I did not try the local fix as suggested yet, however, I am at the client site today and connected directly to their network as opposed to via VPN and the jobs are now precompiling and compiling within seconds as one would typically expect. Not sure that helps to answer my question or solve anything...

Bob, Do you have XML stages (with plenty of columns defined) in those jobs? Nope, no XML I also tried a force compile earlier today and though I did not time it the precomp still took a long time. And, I looked at the tech note referenced earlier. It seems that one was related to the actual compile...

I'm not sure what you found in your Google search nor what TPT has to do with blob, clob data, but what I can tell you is that TPT is required to use the Teradata Connector.

I am sure this is a loaded question, but, generally speaking, what occurs during the pre-compilation of a parallel job? The reason I ask is that most of our jobs go through precompilation in just a few seconds. However, I have seen several jobs that consistently take several minutes for precomp and ...