Restore purge settings
Moderators: chulett, rschirm, roy
Restore purge settings
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
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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If it's in VOCLIB, then
It it's not in VOCLIB but is in another job log, then
Note that neither of these is SQL, so there is no terminating semi-colon.
Code: Select all
COPY FROM VOCLIB TO RT_LOGnnn '//PURGE.SETTINGS'
Code: Select all
COPY FROM RT_LOGkkk TO RT_LOGnnn '//PURGE.SETTINGS'
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.