09-19-2012 10:20 AM
We ran into an issue while I was out for an extended period in which we could not login using the Java GUI to OML. We'd get a message indicating that the connection attempt timed out. It was happening to our primary and backup servers. I pointed out the possibility of it being because of so many messages being loaded and support advised that wasnt the issue. When I eventually deleted the active messages in the backup server and then the primary (after downloading the critical and major messages), I was able to log back in.
I found out why the active table filled up so fast (2 nodes out of control) but in the meanwhile was wondering if anyone could advise on a best practice for keeping the active message table under 50K messages. I know about alerts that will appear in the events browser but I'm looking for something we can cron that can run regularly. Commands like opcack just do all and don't have date filtering. Others, like opcactdwn, have date filtering but wont help in this scenario.
Thanks in advance,
09-19-2012 10:18 PM
'opcack' does have some date filtering - the following options are available:
time_from, time_to, last_time_from, last_time_to
As an alternative, you could write your own tool for this. There's a number of tools in the "/opt/OV/OpC/examples/progs" directory that you can use as a starting point. Ask here if you need help with some specific task.
09-20-2012 08:30 AM
you could use opcackmsg to acknowledge some old messages.
We have implemented some scripts which run as cronjobs to do so.
First figure out the messages (message-id's) you want to acknowlege via an sql-statement, based on message groups and local-receiving-time.
Then pass these message-id's to the opcackmsg command.
We even have created an "AUTOACK" operator which we use with the command to see that the messages have been acknowledged by our scripts.
Hope this helps,
09-20-2012 01:44 PM
Thanks, Goran. I never noticed that examples dir before. I looked at it now after your post. May be useful. Also, I see that I need to use the -e option on opcack to invoke those filters. I didn't pick up on that when reading the man page at first.