DSXchange

Hi, I have a simple job developed by some one else. ORAOCI9 stage --> Transformer --> ORAOCI9 stage. I am trying to tune the performance of the job. The job is currently processing 650 rows per second. My source has 10 million rows. At the rate of 650 rps its taking 4 hrs. We have the same job in In...

Another possibility is that the job was exported from another project and imported into this one but the routine was not, so that ClearHashFile does not even appear in the Repository. If this is the case, you must obtain the routine from wherever the job was exported from. Yep, Ray nailed it. The r...

narasimha wrote:Re-compile your routine ClearHashFile and try if it works.

I tried re-compiling the job I am still getting the same error

I have a simple job
HashFile -> IPC-> Transformer->IPC->Hashfile.

This job is called as a after job sub routine. And the parameters are seem to be passing right. Any of you guys seen this error before? Any ideas what could be causing this?

Thank you.

DSguru2B wrote:Great, you can mark the post as "Resolved" then.

I guess I can't mark the post as resolved as I am not the one started it.

The problem has been resolved. I am able to view data now. It was wrong TNSnames that was causing the problem. I think I am wrong regading the dsenv file not being needed when we are using the Oracle DataDirect wire protocol. I think no matter which protocol we are using we need dsenv file to let DS...

You are configuring this for ODBC or OCI? The first two files you mentioned are for ODBC while the third is needed for OCI. LIBPATH = SHLIB_PATH on some operating systems, you set whichever is appropriate for yours. You also need to make sure ORACLE_HOME is set in the dsenv file as well, then stop ...

You need to properly configure DataStage for Oracle, something that is documented in both the Plug-in Configuration Guide and the OCI documentation. It involves editing the dsenv file to set $ORACLE_HOME and to include the proper libraries in your equivalent SHLIB_PATH. Once that is done you need t...

Thanks Narasimha and Craig, that answers my question. And would it be OK to assume that it is the same thing when we reset the Job Sequence status?. For instance, If the underlying job aborts for some reason, the sequence will also abort. In this situation, if I just modify the job, recompile it and...

I have a Master Jobsequence 'A' calling multiple job sequences jobsequence1, job sequence2, job sequence3... and so on. If I modify a job in the job sequence1 and compile the job but not the jobsequence1, would it cause any trouble when I kick off the Master Jobsequence? In other words what happens ...

Maybe your computer is too fast! It could be exhausting the number of retries before the timeout kicks in. Search the Forum for information about the SPINTRIES and SPINSLEEP configuration variables that can be used to tune mutex lock behaviour. You might also increase the timeout on your IPC stages...

Maybe your computer is too fast! It could be exhausting the number of retries before the timeout kicks in. Search the Forum for information about the SPINTRIES and SPINSLEEP configuration variables that can be used to tune mutex lock behaviour. You might also increase the timeout on your IPC stages...

What exactly is the problem you are waiting on a resolution for? With cryptic messages and obviously edited posts from other folks, I can't really tell at this point. :? Craig, We are trying to find how to get the job end date time as the following command triggering a warning message "DSGetJo...

narasimha wrote:Can you please go for a new post for this, it is not related to the discussion in this thread.

Can you please tell me how do I look up the new post, if you've started it. Its an interesting topic, I would like to know more about it.