CLEAR.FILE - complains file is read-only

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
sjordery
Premium Member
Premium Member
Posts: 202
Joined: Thu Jun 08, 2006 5:58 am

CLEAR.FILE - complains file is read-only

Post by sjordery »

Hi All,

In one of our projects, attempting to open the log on one of the job sub-directories results in the Director hanging until 'Not Responding' appears at the top of the window. I'm guessing that the logs are too big..

I did a little research on here and came up with a way of getting the biggest logs for the project, and then using CLEAR.FILE in Administrator to clear them down.

However, logging on as dsadm and attempting this on one of the RT_LOGnnn files, I get an error that:

"CLEAR.FILE attempted on a read-only file"

And the command is then aborted.

Any ideas appreciated.

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

Post by chulett »

Who actually owns the RT_LOG hashed file and its components? Does it work if you log in as that user?
-craig

"You can never have too many knives" -- Logan Nine Fingers
sjordery
Premium Member
Premium Member
Posts: 202
Joined: Thu Jun 08, 2006 5:58 am

Post by sjordery »

Hi Craig,

I'll try logging in as the owner and see what happens. Will report back...

Thanks,
S
sjordery
Premium Member
Premium Member
Posts: 202
Joined: Thu Jun 08, 2006 5:58 am

Post by sjordery »

Logging in to Adminsitrator as the owner of the file and running the command worked.

Thanks Craig.
Post Reply