wtdbclear and wrmdbclear

[aofan]

How do you automate the wtdbclear and wrmdbclear in AIX?
I know that I need some kind of script to run cron job so that it will run it periodically.

I need Help.


Thank you


aofan

 

[Reilus]

I've not heard of wrmdbclear before but if you script the following and schedule it nightly, it should keep your database under control.

wtdbclear.pl -a 20 -lt 86400 > /tmp/wtdbclear_rl.log 
wtdbclear.pl -a 20 -et 604800 > /tmp/wtdbclear_er.log

The perl version of wdbclear is more reliable than the standard binary.

Options Explained :
-a is the number of lines to commit after
-l means work on reception log
-e means work on event repository
-t deletes events older than number given (secs)

 

[aofan]

So, I just save the above script in a file and do the cron job? or use the Tivoli Scheduler?


Thanks

aofan

 

[Reilus]

Yup, just add the lines to a simple shell script.
It shouldn't matter if you use cron or Tivoli Scheduler so long as you are running it on your TEC server.

Reilus

 

[aofan]

for the cron job, do I need to setup any enviorment variable?

Thanx

aofan

 

[rodneywill]

Yes,

You have to set the environment

. /etc/Tivoli/setup_env.sh

regards,
Rodney