Hash file weired character

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
kab123
Participant
Posts: 92
Joined: Tue May 18, 2004 4:05 pm

Hash file weired character

Post by kab123 »

I have seen a weired scenario. In test environment, it writes 8 rows and reads 8 rows from hash file. but in prod, it writes 8 but reads 9 (which we think is from previous run and file was not flushed properly).. Is that possible ?? just curious to know as the job was runn ing for years and it never occured before.
'Delete file before create' not checked
'Create file' checked
'Clear file bfore creating' checked

does this cause the issue ?? because it appears it does.

Thanks
Thanks
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

No clue how to explain that one as long as you are certain you are reading and writing to the exact same hashed file. Worst case, manually delete the hashed file's directory and it will recreate it on the next run.
-craig

"You can never have too many knives" -- Logan Nine Fingers
kab123
Participant
Posts: 92
Joined: Tue May 18, 2004 4:05 pm

Post by kab123 »

100% positive on that. like i said the same job has been running differently in 2 environments. same input data.
Thanks
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

Write the output to a sequential file and find the difference / extra line.
Post Reply