At the OS level, the directory and *.30 files have RWX permissions. This is the first time I'm seeing this error with CLEAR.FILE and I couldn't find this on dsxchange.
pandeesh wrote:I believe clear.file should be followed by set file command.
Followed by, no. Since CLEAR.FILE only works on "account-based" hashed files, then you may need to preceed it with one if it was "pathed". However, Maveric is talking about one in a project so it comes with one at no charge.
If there was no VOC entry then the command would simply fail to find the hashed file.
-craig
"You can never have too many knives" -- Logan Nine Fingers
mavrick21 wrote:Now I'm wondering if a hashed file can be marked read-only in VOC.
Possible. I believe all objects have a "read only" attribute but don't recall ever seeing a hashed file with that set. If that's the case, any reason you can think of why someone may have set that?
-craig
"You can never have too many knives" -- Logan Nine Fingers
Some special hashed files (for example system tables like UV_SCHEMA) have a read-only bit set in their file header. You will never be permitted to clear these, or even to edit them inappropriately (via DML), because doing so would break the engine. Which hashed file did you try to clear, and what are the permissions on the directory containing DATA.30 and what are the permissions on all three files within that directory?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
When I run the job it runs fine (slowly but fine) and reads the content from the hashed file. Hence I want to clear this hashed file and do a clean run of the job.
I cleared this hashed file 2 days ago but now I can't. I'm the only person who is working/using this hashed file and I haven't run any other command on this hashed file.
I didn't get an email notification when you replied and yesterday I ended up just manually deleting the VOC entry, the hashed file directory and D_hashed file. I thought of updating my thread now and I saw your response. Unfortunately couldn't give UVFIXFILE a try
Anyways, thank you!
@Others,
Thank you all for your help!
-Mav
Just FYI - This is the 4th or 5th time I haven't received an email notification when others replied to my thread. If anyone can notify the site owner about this issue that would be very helpful (I would do it myself but I don't know the steps to report a bug). Thanks!