Error clearing a hashed file

mavrick21 · Post by **mavrick21** » Sat Oct 01, 2011 12:04 am

Hello Gurus,

I'm trying to clear a hashed file but I get the following error:

/ps/dsadm/Ascential/DataStage/Projects/DWDEV> uv 'CLEAR.FILE BLAH_BLAH'
CLEAR.FILE attempt on read-only file.
** CLEAR.FILE processing aborted. **

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.

Please advise.

Thanks

chulett · Post by **chulett** » Sat Oct 01, 2011 7:57 am

Let's not continue to pile on that four page thread, new issue = new post.

Now... what about the hidden file in the directory? Wasn't sure if you had checked that or not. And how about the D_BLAH_BLAH dictionary file?

mavrick21 · Post by **mavrick21** » Sat Oct 01, 2011 10:50 am

Hi Craig,

Just checked now, without making any changes, and got the same error.

Code: Select all

/ps/dsadm/Ascential/DataStage/Projects/DWDEV/BLAH_BLAH> ls -la
total 650184
drwxrwxrwx     2 dsadm dsadmdev      4096 Jul 22 13:02 .
drwxrwxrwx 42929 dsadm dsadmdev   2101248 Sep 30 15:02 ..
-rwxrwxrwx     1 dsadm dsadmdev 561053696 Oct  1 10:41 DATA.30
-rwxrwxrwx     1 dsadm dsadmdev 102612992 Sep 15 14:56 OVER.30
-rwxrwxrwx     1 dsadm dsadmdev         0 Jul 22 13:02 .Type30
/ps/dsadm/Ascential/DataStage/Projects/DWDEV/BLAH_BLAH> cd ..
/ps/dsadm/Ascential/DataStage/Projects/DWDEV> ls -l D_BLAH_BLAH
-rwxrwxrwx 1 dsadm dsadmdev 2048 Jul 22 13:06 D_BLAH_BLAH
/ps/dsadm/Ascential/DataStage/Projects/DWDEV> uv 'CLEAR.FILE BLAH_BLAH'
CLEAR.FILE attempt on read-only file.
** CLEAR.FILE processing aborted. **
/ps/dsadm/Ascential/DataStage/Projects/DWDEV>

Now I'm wondering if a hashed file can be marked read-only in VOC. Just a thought.

Thanks

pandeesh · Post by **pandeesh** » Sat Oct 01, 2011 2:49 pm

I believe clear.file should be followed by set file command.
Someone correct me if I am wrong.

chulett · Post by **chulett** » Sat Oct 01, 2011 2:54 pm

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.

chulett · Post by **chulett** » Sat Oct 01, 2011 2:57 pm

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?

ray.wurlod · Post by **ray.wurlod** » Sat Oct 01, 2011 4:18 pm

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?

mavrick21 · Post by **mavrick21** » Sat Oct 01, 2011 5:16 pm

Ray,

I'm trying to clear a hashed file created by our project. Here are the permissions on them:

Code: Select all

/ps/dsadm/Ascential/DataStage/Projects/DWDEV> ls -l | grep BLAH_BLAH 
-rwxrwxrwx  1 dsadm dsadmdev     2048 Jul 22 13:06 D_BLAH_BLAH
drwxrwxrwx  2 dsadm dsadmdev     4096 Jul 22 13:02 BLAH_BLAH
/ps/dsadm/Ascential/DataStage/Projects/DWDEV> cd BLAH_BLAH
/ps/dsadm/Ascential/DataStage/Projects/DWDEV/BLAH_BLAH> ls -la
drwxrwxrwx        2 dsadm dsadmdev           4096 Jul 22 13:02 .
drwxrwxrwx 42929 dsadm dsadmdev     2101248 Sep 30 15:02 ..
-rwxrwxrwx         1 dsadm dsadmdev 561053696 Oct  1 17:08 DATA.30
-rwxrwxrwx         1 dsadm dsadmdev 102612992 Sep 15 14:56 OVER.30
-rwxrwxrwx         1 dsadm dsadmdev                0 Jul 22 13:02 .Type30

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.

Thank you

chulett · Post by **chulett** » Sat Oct 01, 2011 9:16 pm

Sometimes he just jumps in at the end without reading all the boring stuff before that.

ray.wurlod · Post by **ray.wurlod** » Sun Oct 02, 2011 12:08 am

Well, I began with the intention just of mentioning the special files.

Clearly permissions aren't the problem. Can you perform a UVFIXFILE scan of the file?

mavrick21 · Post by **mavrick21** » Tue Oct 11, 2011 10:42 pm

Ray,

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!