Dynamic Hash File showing up as multiple small files in OS

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
kcbland
Participant
Posts: 5208
Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:

Post by kcbland »

Somehow you're probably missing the ".Type30" file, probably from doing a manual creation of directories as opposed to "mkdbfile" statement or the "CREATE.FILE" statement. Because of that, the hash file reverts to a type 1 which means every row of data is a separate file within the hash file directory.

Don't do whatever it is you're doing! :lol:
Kenneth Bland

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
ray.wurlod
Participant
Posts: 54595
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

I agree with Ken's diagnosis; if you - or someone else - has removed the .Type30 hidden file, then DataStage has no way of knowing that the directory is supposed to be a dynamic (Type 30) hashed file. Therefore DataStage treats the directory as a directory (Type 19) file. [Type 1 requires a hidden file called .Type1 to exist.]

Find the culprit(s) who removed .Type30 and educate them. About a 34 inch baseball bat should be an appropriate educational tool. :lol:
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply