Restore purge settings

prasad111 · Post by **prasad111** » Wed Oct 08, 2008 6:07 pm

Hi,

I followed the below link for clear.file and restore the purge settings.
viewtopic.php?t=92145&highlight=%2F%2Fpurge

[code]
cd $DSHOME
bin/uvsh
>COPY FROM RT_LOGnnn........
>CLEAR.FILE RT_LOGnnn
>COPY FROM .............. TO RT_LOGnnn
[/code]

There is a situation where clear.file was executed without copying the purge settings to VOCLIB.

[code]
cd $DSHOME
bin/uvsh
>CLEAR.FILE RT_LOGnnn
[/code]
How can I restore the purge settings from administrator to assign the value to the RT_LOGnnn.

I can get the administrator settings value from DSParams file

[AUTOPURGE]
PurgeEnabled=4
DaysOld=4
PrevRuns=4

how can assign these value to the purge settings for the job in the basic command at
bin/uvsh......

suggestions are highly appreciated

chulett · Post by **chulett** » Wed Oct 08, 2008 6:12 pm

Use the GUI, i.e. the Director.

prasad111 · Post by **prasad111** » Wed Oct 08, 2008 6:17 pm

We are trying to write a UNIX shell script to automate the cleanup/archive process.........

ray.wurlod · Post by **ray.wurlod** » Wed Oct 08, 2008 6:28 pm

You don't need to anything. If you want the same settings as project default to be in place, just run the job again - the absence of control records will be understood to mean (a) that you want the log to be purged using default settings and (b) that you want the control records to be created. This is how newly-created jobs do it too.

chulett · Post by **chulett** » Wed Oct 08, 2008 7:04 pm

Interesting... that makes sense but I don't recall anyone explaining it like that. I've always assumed I had to put them back (which is no big deal) or they would be gone forever.

ray.wurlod · Post by **ray.wurlod** » Wed Oct 08, 2008 7:12 pm

You only need to put non-default ones back.

prasad111 · Post by **prasad111** » Thu Oct 09, 2008 10:43 am

Current project default is to Auto purge the job log up to 5 previous runs.

But when I execute CLEAR.FILE RT_LOGnnn and rerun the job, it keeps on adding the log it is not getting purged (its keep the log for more than 5 previous runs).

prasad111 · Post by **prasad111** » Thu Oct 09, 2008 10:45 am

Current project default is to Auto purge the job log up to 5 previous runs.

But when I execute CLEAR.FILE RT_LOGnnn and rerun the job, it keeps on adding the log it is not getting purged (its keep the log for more than 5 previous runs).

Any suggestions is highly appreciated........

ray.wurlod · Post by **ray.wurlod** » Thu Oct 09, 2008 2:28 pm

OK, so put the control record //PURGE.SETTING into the job log.

prasad111 · Post by **prasad111** » Thu Oct 09, 2008 3:58 pm

How, that is my original question?

I tried to use couple of commands, but not succesfull.
COPY '//PURGE.SETTINGS' TO RT_LOGnnn
WRITE RT_LOGnnn

ray.wurlod · Post by **ray.wurlod** » Thu Oct 09, 2008 7:52 pm

If it's in VOCLIB, then

Code: Select all

COPY FROM VOCLIB TO RT_LOGnnn '//PURGE.SETTINGS'

It it's not in VOCLIB but is in another job log, then

Code: Select all

COPY FROM RT_LOGkkk TO RT_LOGnnn '//PURGE.SETTINGS'

Note that neither of these is SQL, so there is no terminating semi-colon.