Spurious Hash File Allocation message

[flashgordon]

Hi,

We have "Create File" checked on a hash file and we are getting that spurious "Unable to create file /ibdd/..." message that is a know Datastage problem. We are running DS 7.5 and HP/UX 11.11. I re-run the job a few minutes later with no code changes and the job runs. We are running these sequences in tight succession, so the Create File is probably being encountered a few minutes after the hash file was read in a prior execution. Does anyone have a silver bullet for this spurious hash file allocation problem. We do have Create File and "Clear file before Writing" set on update action. Is that a no-no for some reason?

... Flash Gordon

[ArndW]

Flash,

are you intentionally deleting and re-creating the file on each job run? Unless you have specified this the job should never branch into the CREATE statement after the first job run. The CLEAR.FILE is no problem unless you have multiple processes running that read/write to this file; but even then you wouldn't be getting an abort, just unexplained data contents.

If you are intentionally deleting the hash file and creating it each run it might be worthwhile to rethink that approach as there is overhead involved with file creation and the delete does need exclusive access to the file.

[Sainath.Srinivasan]

Your error appears to do with operating system permissions to create the hash file.

You may probably be using a script to move the hash-files around.

Also check whether you use any parameter(s) embedded in the hash-file names and ensure that the values are passed correctly.