DSXchange

You can clear out any and all files in &PH& subdirectory; but not any files in the parent project directory, otherwise you will break that project and make it unusable.

splayer - look at the filesystems and options used for your two partitions.

sheema wrote:...But incase we have 2 rows which are identical...

How can you do this in a hashed lookup?

No, you use the $PROJDEF as the parameter value and continue to use the parameters to fill out the different columns in your job.

Hashed file keys are unique, so a lookup on a key will return only one row. If you use another stage type for a reference then that is a different matter.

No problem, the names in the data folder will be unique.

...Both versions output the file to the same folder... No, probably just your dataset descriptor and sequential file are in the same directory. You should try writing your sequential file to the directory pointed to by the resource disk setting in your APT_CONFIG file. That way you are comparing pe...

What happens to the speed of the sequential version if you output it to the same directory as your dataset data files as specified in the APT_CONFIG file? If is slows down then it might be related to the disk partition and not directly to the DS job.

You need to specify the -MODE NORMAL. Is your project actually called "PROJECTNAME"? What happens if you try to start the job by typing in all the actual values?

Look at web site here

in the Input properties for you DB2 enterprise stage the Options -> Row commit interval is to be set to 0. This option doesn't exist when you do a "load"

You can force sequential execution so that you only have one process, then use @INROWNUM to limit output from a link to 500.

You will need to use SET.INDEX first in order to fix the indices.

As balajisr mentioned, you might be running sequentially instead of in parallel. Turn on APT_DUMP_SCORE to see what is really happening at runtime. A dataset, even in sequential mode, should run at about the same speed as a sequential file for what you've described, so something is definately amiss.

Is the stage DJobFlushLogicaPrepaidDailyBalanceHash4 a write, read or a reference stage? How do you reference the hashed file - by path or by name?