We have been unable to successfully issue a compact command from the console since we upgraded our server to V9 (all fix packs have also been installed) and, since the upgrade, I am unable to see any log statements that give the status of archiving and/or compacting, whether via program or via the console. I have tried to use the database management tool, but when I load it from the console, I get an error that the file does not exist.
Normally, if I am unable to compact a user during the day, the server takes care of it overnight. However, that is no longer happening. All of my program tasks are still active. These were not changed.
Any ideas what I can check next?
Subject: Can you post a screen shot?
How are loading compact or dbmt and the error that is being returned? Thanks!
jpaganet@us.ibm.com
Subject: Solution
This can happen after an upgrade
stop your “Events Monitor” task.
You can do this from the server tab, then go to the point “Server tasks” on the left side. Right mouse click - stop task, and then look in your console.
Chances are your console will now show a proper compact, run “load compact -c -v -n” without a target, if this works, then your DDM/Events config is either corrupt or just wrong.
The fix is easy, just go to the “Configuration” tab in your admin client.
On the left there is a point for “Monitoring configuration”, open it. There is an under point “Log Filters”, just delete the contents of the view. There are other methods to do this too, but this is the most simple.
Now start your Events task using the server tab, tools on the side then “Start”, “Event Monitor”.
Sincerely
Douglas Bryant
email@dbryant.de
www.dbryant.de http://www.dbryant.de