DSXchange

We are calling datastage job through scripts.oci stage output is connected to hashfile and the hashfile output is used as lookup.What is happening is sometimes hash file is populating and sometimes it is not populating.The server has enough free space.What might be the problem for the strange behaviour.Whether any patch required

Welcome aboard. :D

(The term is "hashed" file, not "hash" file.)

When the hashed file is not populated, what row count is reported through the job? Is there a Transformer stage in the job?

If not, put one in, even though it does nothing. Then you will be able to isolate the problem to "0 rows selected from Oracle" (in which case you would reasonably expect the hashed file not to be populated), or something else.

Let us know how far you get with that, and then we can work out whether any further investigation is needed.

the row count is showing as zero and hash file is connected to transformer stage in the job for lookup .These problem is occuring occasionally only not all the times

Not the job that does the lookup; the job that populates the hashed file. Is there a Transformer stage between the OCI stage and the hashed file stage in the part that populates the hashed file? If not, put one in.

The most probable cause for not populating the hashed file intermittently is that no rows were selected from Oracle on that run. Putting a Transformer stage between the OCI stage and the hashed file stage will allow that to be proven whenever it next happens.

The part which populates hash file doesn't have transformer.The oci stage is directly connected to hash file.

When the hashed file was not populated, how many rows went from the OCI stage to the hashed file? If "0" then you need to look at your database and SELECT statement.

One other thing you can do is select the option "clear file before write" on the hashed file stage. I believe you have run this many time.

The other thing is to give the hashed file a different name with the "clear file before write" option and see what happens.


Ralleo

The only man who never makes a mistake is the man who never does anything.
.Theodore Roosevelt

pat_raman2000 wrote:The part which populates hash file doesn't have transformer.The oci stage is directly connected to hash file.

I want you to put one in, as an aid to diagnosis.

With two links we get separate counts of rows selected from Oracle table and rows sent to hashed file.