Page 1 of 1

issue on CLEAR.FILE

Posted: Wed Mar 21, 2012 4:32 am
by karthi_gana
All,

I just tried to clear the log by using CLEAR.FILE command as below.

. ./dsenv

bin/uvsh

logto <my project>

LIST DS_JOBS Change_Capture_Test

got the job id


CLEAR.FILE RT_LOG<above jobid>

>clear.file RT_LOG2451
CLEAR.FILE attempt on read-only file.
** CLEAR.FILE processing aborted. **

it seems like RT_LOG2451 file doesn't have the write permission. am i correct? if yes, how to apply chmod command for this file?

Re: issue on CLEAR.FILE

Posted: Wed Mar 21, 2012 4:33 am
by karthi_gana
what is the exact difference between RT_LOG and RT_STATUS table?

Re: issue on CLEAR.FILE

Posted: Wed Mar 21, 2012 4:35 am
by karthi_gana
I just tried this one too.

>LOGTO UV
>CLEAR.FILE RT_LOG2451
Unable to clear file RT_LOG2451.
File name = Change_Capture_Test
Unable to clear file Filter_Stage.
File name =
>

Posted: Wed Mar 21, 2012 6:00 am
by arvind_ds
use datastage administrator tool and then command option over there to clear the desired file.

Re: issue on CLEAR.FILE

Posted: Wed Mar 21, 2012 6:59 am
by chulett
karthi_gana wrote:it seems like RT_LOG2451 file doesn't have the write permission. am i correct?
Yes, for whatever user you are using that is correct. Use the proper user, the one that does have the permissions it needs.

As to the "this one too" error, you don't do any log clearing while logged into the UV project.... because the logs are not in the UV account; they are specific to project accounts. :wink:

Posted: Wed Mar 21, 2012 3:03 pm
by ray.wurlod
... because the logs are not in the UV account; they are specific to project accounts.

Posted: Wed Mar 21, 2012 8:54 pm
by qt_ky
Try your original commands after you telnet and login as dsadm or an equivalent user.

Re: issue on CLEAR.FILE

Posted: Wed Mar 21, 2012 9:31 pm
by ray.wurlod
karthi_gana wrote:how to apply chmod command for this file?
In the usual way, with the -R option. But, if you don't have write permission, what chance is there that you'll have sufficient permission to execute a chmod command?!!

Re: issue on CLEAR.FILE

Posted: Fri Mar 23, 2012 3:29 am
by karthi_gana
$ chmod 777 -R RT_LOG2451
chmod: -R: not found [No such file or directory]
chmod: RT_LOG2451: cannot change mode [Operation not permitted]

It seems like i don't have the access to execute CHMOD command.

Posted: Fri Mar 23, 2012 5:40 am
by chulett
Sorry but don't you have people with UNIX skills where you work you can talk to? This really isn't a "teach you UNIX" forum, I'm afraid.

You have to own a file in order to be able to chmod it.

Posted: Fri Mar 23, 2012 10:04 am
by qt_ky
Be careful since you're not familiar with the chmod command, especially with the -R option! :!:

Posted: Fri Mar 23, 2012 3:30 pm
by ray.wurlod
You're not even familiar with the syntax of chmod command. Find someone who has knowledge and permission.

Note: the better solution is to be granted membership of the correct group.

Code: Select all

chmod 777
should not be used as a universal panacea. They won't allow that in production.